php &amp; postgreSQL

php & postgreSQL

Anon

hi
I'm a Linux RH6.2 user. I want to run PHP with postgreSQL. I'm facing some problems. Kindly help me:

1) How to run postmaster? usr/bin/postmaster is saying that: unable to find systemdata or unable to open "/usr/include/pgsql//base/template 1/pg_class"

error:postmaster does not know to find the database system data.You must
specify the directory that contains the database system either by
specifying the -D invocation or by setting the PGDATA environment
variable

2) pg_connect() cannot find postgreSQL server.
error:Connection to database 'postgres' failed.connectDB() failed: Is the
postmaster running and accepting connections at 'UNIX Socket' on port
'5432'?

3) How to use and configure pg_hba.conf?

PLZ Reply Soon

Anshuman
India
anshuman@simblos.com

Anon

First, if you installed from RPM's all of that stuff should have been taken care of for you. Well, let me rephrase, the database and data directory should have been created. (It likes /var/pgsql/data). If you compiled it yourself please refer to the extremely detailed instructions in the INSTALL file that came with the source. FYI you need to specify the data directory with the -D switch

/usr/bin/postmaster -D /var/pgsql/data

There should also be some scripts put in the /etc/rc.d/init.d directory for PostgreSQL. You can use those as ROOT to start and stop the server.

If you want to accept connections from any machine other than the localhost you need to add -i switch to the startup.

/usr/bin/postmaster -i -D /var/pgsql/data

Your second problem will be solved when you actually get the postmaster running. It can't connect to a server that isn't actually running.

The pg_hba.conf is quite well documented right within the file. It has a number of examples as well. If you need any specific help then feel free to ask.

Tim Frank

Anon

Don't forget, before all that he's gotta run initdb to build the initial database or postmaster won't have anything to run against. But as you stated so well, the VERY detailed INSTALL file says all that and more.