Re: problem with PostgreSQL

Sorry Adam, I just realized that you are totally correct...damn brain farts or something... excuses my stupidity.... -- RAY HUNTER ----- Original Message ----- From: "Adam Williams" <awilliam@mdah.state.ms.us> To: "Ray Hunter" <rhunter@venticon.com> Cc: "PHP GEN" <php-general@lists.php.net>; "Richard Kurth" <rdkurth@starband.net> 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: <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 > > > > > >