Re: PostgreSQL from a newcomers perspective

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://USERNAME@unix(/tmp)/DBNAME');

Jon

On Mon, 1 Dec 2003, Peter Eisentraut wrote:

> 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
> > that PostgreSQL would require something simular to MySQL.. if it does..
> > then I would expect it to be in the docs->installation->long version.
>
> Agreed, that could be added.
>
> > 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 postmaster did turn up the app_postmaster page..
>
> Would you care to tell us what you had to do?  Because using the standard
> installation I can connect via PHP just fine.
>
> --
> Peter Eisentraut   peter_e@gmx.net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>