Re: How to connect to the database server

Selon Guillaume Yziquel <guillaume(dot)yziquel(at)bluebottle(dot)com>:

> Harold A. Gimnez Ch. a crit :
> > Have you tried loging in with the default user (postgres)?
> >
> > psql -U postgres
> >
> > or, try su'ing as postgres and login in then:
> >
> > su - postgres<enter>
> > psql<enter>

Hello, Harold.

I thank you very much for your answer.

psql -U postgres yields:

> yziquel(at)seldon:~$ psql -U postgres
> psql: impossible de se connecter au serveur: Permission non accorde
> Est-ce que le serveur tourne sur l'hte local
> et accepte des connexions au socket Unix
/var/run/postgresql/.s.PGSQL.5432 ?

Doing su - postgres and psql yields:

> postgres(at)seldon:~$ psql
> psql: FATAL: La base de donnes postgres n'existe pas
> postgres(at)seldon:~$

Seems like I need to know what are the databases inside my cluster...

Thanks again for your help.

Guillaume.

> > On Thu, May 22, 2008 at 1:14 PM, <guillaume(dot)yziquel(at)free(dot)fr
> > <mailto:guillaume(dot)yziquel(at)free(dot)fr>> wrote:
> >
> > Hello list.
> >
> > My problem is the following: I've installed a postgresql server on
> > my debian
> > GNU/linux system. I've not installed for postgresql itself, but
> > rather because I
> > needed a database server for other applications that use the
> > database for
> > storage purposes.
> >
> > Usually, using aptitude is always a pleasure... However, I now have
> > a database
> > server and I do not have any more the credentials to access the
> > database as the
> > database administrator (or perhaps I have them somewhere, but I'm
> > unable to find
> > them again).
> >
> > My question is the following: How can I get to connect directly to
> > the database
> > as the database superuser? Do I need to delete and reinstall my
> > whole database?
> >
> > I've been looking for documentation on this topic, but perhaps in
> > the wrong
> > placem or perhaps in the right but failing to see the light... So if
> > you have a
> > relevant link, I'm dying to hear about it.
> >
> > Guillaume.