Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Friday's Server Login - Updated


  • From: Matthew Wetmore <m(dot)wetmore(at)secomintl(dot)com>
  • To: Los Angles PostgreSQL Users Group <lapug(at)postgresql(dot)org>
  • Subject: Friday's Server Login - Updated
  • Date: Tue, 22 Apr 2008 17:05:11 -0700
  • Message-id: <480E7D37.9020802@secomintl.com> <text/plain>

Test Server is up. (please don't publish outside of pug)
can someone log in to check permissions.


64.167.95.139
ssh/sftp via port 22
pgsql via 5432

Red Hat (CentOS5) /var/lib/pgsql/data

user=pug
pass=pugpug

feel free to leave any scripts and notes in /home/pug/

Since I am extremely lazy, here are some bash aliases to ease your
usage. Just use the underprivileged password when asked


 alias pggo='sudo -u postgres pg_ctl -D /var/lib/pgsql/data start'
        # Start postgres
 alias pgno='sudo -u postgres pg_ctl -D /var/lib/pgsql/data -m fast
stop'       # Stop postgres
 alias pgre='sudo -u postgres pg_ctl -D /var/lib/pgsql/data -m fast
restart'    # Restart postgres
 alias gwsbin='sudo /sbin/shutdown -r now'
        # restart linux
 alias pghba='sudo vi /var/lib/pgsql/data/pg_hba.conf'
        # PG IP Permissions
 alias pgconf='sudo vi /var/lib/pgsql/data/postgresql.conf'
        # PG CONF
 alias gwvac='vacuumdb -z'
        # VAC



-- 


-- 
-- 

Matthew Wetmore

Secom International, Inc.
9610 Bellanca, Ave.
Los Angeles, CA 90045
310-641-1290

Download my Public PGP encryption key
from http://cryptonomicon.mit.edu/ (or any other public key server)

PCI COMPLIANCE UPDATE:
SECOM CANNOT RECIEVE ANY CREDIT CARD CARDHOLDER DATA FROM CLIENTS.
IF YOUR EMAIL IS SCANNED AND FOUND TO CONTAIN CARDHILDER DATA,
IT WILL BE DELETED AUTOMATICALLY.

This e-mail is intended for the addressee shown. It contains information
that is confidential and protected from disclosure.  Any review,
dissemination or use of this transmission or its contents by persons or
unauthorized employees of the intended organizations is strictly
prohibited. The contents of this email do not necessarily represent the
views or policies of Secom International Inc., or its employees.



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group