Good call on that Adam... One thing to note is that when you call the postmaster here you are calling it with the pg_ctl command...so it is beneficial to pass the postmaster options to the pg_ctl command...like so...
su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -o '-i' -D $PGDATA -p /usr/bin/postmaster start >/var/log/pgsql 2>&1" < /dev/null And for debugging purposes I like to add a file to log all errors and notices...which has saved me tons of time...I am logging to /var/log/pgsql file... Also you can edit the pg_hba.conf file that is located in /var/lib/pgsql/data/pg_hba.conf for network and ip access...if redhat rpm installed... .: B i g D o g :. ----- Original Message ----- From: "Adam Williams" <[EMAIL PROTECTED]> To: "Ray Hunter" <[EMAIL PROTECTED]> Cc: "PHP GEN" <[EMAIL PROTECTED]>; "Richard Kurth" <[EMAIL PROTECTED]> Sent: Wednesday, August 21, 2002 12:55 PM Subject: Re: [PHP] problem with PostgreSQL > Just to throw my $.02 in, if you are running an RPM based linux > distribution on your server (such as RedHat), edit your > /etc/rc.d/init.d/postgresql file and look for the code in it: > > # Check for postmaster already running... > pid=`pidof -s postmaster` > if [ $pid ] > then > echo $"Postmaster already running." > else > #all systems go -- remove any stale lock files > rm -f /tmp/.s.PGSQL.* > /dev/null > echo -n "$PSQL_START" > > If you find that (its under the start section), then immidately after the > "echo -n "$PSQL_START"" change the next line to: > > su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o -i start > /dev/null 2>&1" < /dev/null > > Adam > > On Wed, 21 Aug 2002, Ray Hunter wrote: > > > Basically, > > > > That is your problem here: > > > > > [Wed Aug 21 11:06:56 2002] [error] PHP Warning: pg_pconnect() unable to > > connect to PostgreSQL server: PQconnec > > > tPoll() -- connect() failed: Connection refused > > > Is the postmaster running (with -i) at '127.0.0.1' > > > and accepting connections on TCP/IP port '5901'? > > > > Postgresql needs the postmaster started with the '-i' option...meaning that > > it can allow access from TCP/IP connections. Also you need to verify if > > postgresql is listening on port 5901, because its default port is 5432... > > > > I would check both of those and then verify that you can connect from your > > ip-address (or network) to the postmaster in the pg_hba.conf file. > > > > > > -- > > .: B i g D o g :. > > > > > > ----- Original Message ----- > > From: <[EMAIL PROTECTED]> > > To: "php-general" <[EMAIL PROTECTED]> > > Sent: Wednesday, August 21, 2002 12:33 PM > > Subject: [PHP] problem with PostgreSQL > > > > > > > Can somebody tell me what this mines in my error log > > > I have PostgreSQL compiled in to php so that should not be the problem > > > PHP Warning: Function registration failed - duplicate name - pg_connect > > in Unknown on line 0 > > > PHP Warning: Function registration failed - duplicate name - pg_pconnect > > in Unknown on line 0 > > > PHP Warning: Function registration failed - duplicate name - pg_close in > > Unknown on line 0 > > > PHP Warning: Function registration failed - duplicate name - > > pg_connection_status in Unknown on line 0 > > > PHP Warning: Function registration failed - duplicate name - > > pg_connection_busy in Unknown on line 0 > > > PHP Warning: Function registration failed - duplicate name - > > pg_connection_reset in Unknown on line > > > I am also getting this error > > > [Wed Aug 21 11:06:56 2002] [error] PHP Warning: pg_pconnect() unable to > > connect to PostgreSQL server: PQconnec > > > tPoll() -- connect() failed: Connection refused > > > Is the postmaster running (with -i) at '127.0.0.1' > > > and accepting connections on TCP/IP port '5901'? > > > in /home/sites/site61/web/util/session_management.phps on line 69 > > > > > > > > > -- > > > Best regards, > > > rdkurth mailto:[EMAIL PROTECTED] > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
