PostgreSQL Database Installation in Linux/Unix

10 Feb 2009

Create Database

  1. Database is located in DATADIR
  2. init_db -D DATADIR -U SUPERUSER -W

Init Database

  1. Edit pg_hba.conf; located at DATADIR
  2. Add host all all 10.1.16.0/20 trust {according to your network}
  3. Edit postgresql.conf, located at DATADIR
  4. Replace listen_addresses=’localhost’ with listen_addresses=’*’ to allow connection from any host.
  5. Start database: pg_ctl -D DATADIR

Example

in our development server

/usr/postgres/8.3-community/bin/pg_ctl -D /export/home/pg_data start


TAGS


-

Author

Follow Me