Installing postgres

From DreamsteepWiki

INSTALLATION NOTES

#

INSTALLING LINUX
 yum -y install postgresql postgresql-server php-pgsql 


#

CONFIGURE/STSRT SERVICE 
  /sbin/chkconfig postgresql on
  /sbin/service postgresql start

  IT TELLS YOU TO :

  service postgresql initdb


#

be sure to open port 5432 tcp(udp?) on firewall

#

START THE postgresql interactive shell and create your first user and database.

 su - postgres         [The dash is important!]

 psql template1        [template1 is a database that is included by default with PostgreSQL.]

psql#  create user web_user;
psql#  create database web_database owner web_user;
psql#  \q


##############DIDNT ACTUALLY DO THIS BUT KEPT NOTES #############
Edit the postgres host based access configuration file:

/var/lib/pgsql/data/pg_hba.conf

Modify the local line to use "trust" based authentication rather than "identity". Please review the PostgreSQL documentation before making this change and take the security

local	all		all			trust

Restart the database service.
 /sbin/service postgresql restart

4. Test your connection.
 psql -U web_user web_database
####################################################################

configure?

/opt/fgs/www/conf/php.ini