================================================================================
Using the Postgres RPM on Fedora Core 4 (FC4)

             http://www.cis.rit.edu/~njs8030/
================================================================================

(1) Install postgres:
	yum install postgres postgres-server

(2) Start the postgres database server:
	/etc/init.d/postgres start

(3) The start script will recognize that the data directory hasn't been 
    initialized and do it for you.  Crap gets dumped in /var/lib/pgsql/data.

(4) Change the default postgres user password:
	su postgres
	psql template1
	ALTER USER postgres WITH PASSWORD 'newpass';

(5) Change the ident method from requiring DB name == UNIX name to arbitrary 
    username/password access.  Open the file /var/lib/pgsql/data/pg_hba.conf and
    change the last three lines

From:
	# "local" is for Unix domain socket connections only
	local   all         all                               ident sameuser
	# IPv4 local connections:
	host    all         all         127.0.0.1/32          ident sameuser
	# IPv6 local connections:
	host    all         all         ::1/128               ident sameuser

To:
	# "local" is for Unix domain socket connections only
	local   all         all                               md5
	# IPv4 local connections:
	host    all         all         127.0.0.1/32          md5
	# IPv6 local connections:
	host    all         all         ::1/128               md5

(6) Restart the database server.
	/etc/init.d/postgres restart

=END=

You can now add users with the "adduser" command.  Once a user has an account 
with create database access, they can use the "createdb" command.

createdb -U webtest webtest
psql -U webtest


=REDHAT9=

To make this work on redhat 9, I had to edit /var/lib/pgsql/data/postgresql.conf
Make "tcpip_socket = true"

The syntax for pg_hba.conf is slightly different.  IPv6 stuff isn't recognized 
at all.  The IPv4 line should read:

host    all         all         127.0.0.1       255.255.255.255 md5

Like usual, restart the postgres server after these changes.

You can now connect in php by setting the dbhost to "127.0.0.1".