The problem here is really on the PHP side, because the docs of PHP don't
tell you how to create a connect string that works for local Postgres
installs (well, the docs exist, but they are hard to find).
For PEAR, it's
$db = DB::connect('pgsql://[EMAIL PROTECTED](/tmp)/DBNAME');
Jon
On Mon, 1 D
On Mon, 2003-12-01 at 17:50, B. van Ouwerkerk wrote:
> This is the error I got in my errorlog:
> Unable to connect to PostgreSQL server: could not connect to server:
> Connection refused
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/5432"
> I couldn't without modifying either postgresql.conf or start PostgreSQL
> with --i
There must be something wrong. PHP should be able to connect via
Unix-domain sockets.
I'll be the first to admit that I might have made a mistake. This is on a
box I use for testing only.. so nothing bad will ha
> Here I find myself behind a Linux box that can't connect via PHP.. solved
> that one too.. Found the solution quicker on PHP.net then on
> postgresql.org.. even searched for postmaster -i (and other keywords I
> could think of) on postgresql.org.. no results.. FWIW.. seaching for the
> keyword p
B. van Ouwerkerk writes:
> >Would you care to tell us what you had to do? Because using the standard
> >installation I can connect via PHP just fine.
>
> I couldn't without modifying either postgresql.conf or start PostgreSQL
> with --i
There must be something wrong. PHP should be able to conne
> Here I find myself behind a Linux box that can't connect via PHP.. solved
> that one too.. Found the solution quicker on PHP.net then on
> postgresql.org.. even searched for postmaster -i (and other keywords I
> could think of) on postgresql.org.. no results.. FWIW.. seaching for the
> keyword p
B. van Ouwerkerk writes:
> Installation went fine. I decided to read the long version.. at some point
> I was told to create a user postgres.
> I didn't find recommended settings for this user like if it needs a shell
> and where the users homedir is supposed to be.. I mean.. I can understand
> th
