Re: Can't login/createdb - Mailing list pgsql-general

From Doug McNaught
Subject Re: Can't login/createdb
Date
Msg-id m37ks1e1pg.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to Re: Can't login/createdb  (Joe Koenig <joe@jwebmedia.com>)
List pgsql-general
Joe Koenig <joe@jwebmedia.com> writes:

> Alright, I've got that taken care of now. Thanks to everyone who
> responded. Next dumb question - I need to be able to connect to postgres
> from PHP - I know that I need to start it up with the '-i' option, but I
> need to make sure it starts up with that option when the machine
> reboots.

Are you sure?  If PHP uses libpq than it should be able to use Unix
domain sockets (on the same machine of course).

>                    I found the 010.pgsql.sh file and it says to edit
> $PG_DATA/postgresql.conf - so I went to my data dir and uncommented the
> line that said 'tcpip_socket = false' and changed it to true. When
> trying to connect from PHP, I get an error stating:
>
> Warning: Unable to connect to PostgreSQL server: pqReadData() -- backend
> closed the channel unexpectedly. This probably means the backend
> terminated abnormally before or while processing the request.

Well, this is either a backend crash (bad) or possibly an
authentication failure.  What do your logs say?  Are there any core
files in $PGDATA?

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: DEBUG messages
Next
From: Jan Wieck
Date:
Subject: Re: [HACKERS] How to turn off TOAST on a table/column