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
