Re: prob in accessing psql at all - Mailing list pgsql-novice

From Christoph Frick
Subject Re: prob in accessing psql at all
Date
Msg-id 20060202124500.GI1068@byleth.sc-networks.de
Whole thread Raw
In response to prob in accessing psql at all  (Morganne witheredrose <maniki@gmail.com>)
Responses Re: prob in accessing psql at all
List pgsql-novice
On Thu, Feb 02, 2006 at 02:40:29PM +0200, Morganne witheredrose wrote:

> I installed postgresql from ports (OpenBSD 3.8) i initialised the db
> using initdb from the user _postgresql everything goes well
>
> but the user postgres seems not to exist the template1 db seems not to
> exist
>
> is it another way to connect to my db and to see what are the
> available users and dbs ?
>
> I am looking forward to hear news from you

AFAIR also the user in the db is then named _postgresql. one thing that
_should_ work with the base install as root is:

 su - _postgresql
 psql template0

next thing is then to add the users you want and fix the settings in the
ph_hba.conf.

--
cu

Attachment

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: prob in accessing psql at all
Next
From: Adam Witney
Date:
Subject: Re: prob in accessing psql at all