Build and install of Postgres
6/6/06
Laird Bedore

At the time of this writing, Postgres 8.0.4 is the current version.

./configure
make
make install
- If this is a postgres server and not just a library installation,
  Do the stuff below. Otherwise, you're done! 

chown -R pgsql /usr/local/pgsql
su - pgsql -c "bin/initdb -D /usr/local/pgsql/data"
touch /var/log/pgsql.log
chown pgsql /var/log/pgsql.log
- Add the following line to startup scripts in order to start the database:
su - pgsql -c "bin/pg_ctl -D /usr/local/pgsql/data -l /var/log/pgsql.log start"

go to /usr/local/pgsql/data.
Edit pg_hba.conf. At the bottom, set the following auth lines:

local   all     all                             trust
host    all     all     127.0.0.1/32            md5
host    all     all     10.10.10.0/24           md5


OLD LINES:

local	all					trust
host	all	127.0.0.1	255.255.255.255	md5
host	all	10.10.10.0	255.255.255.0	md5

The local line will be changed to md5 after the "pgsql" SQL-user has set
its password.

Edit postgresql.conf.
listen_addresses = '10.10.10.2'
## OLD ## tcpip_socket = true
port = 5432

Now you can start up postgres.

su to pgsql.
bin/psql template1
in sql:
alter user pgsql with password '(your sql admin pw)';
(do any other user creations you need to do)
\q

Now, insert any database dumps. RTFM to figure out how to make it happen.

Postgres is up and ready.