Re: 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: <rdkurth@starband.net> > To: "php-general" <php-general@lists.php.net> > 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:rdkurth@starband.net > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > >