Selon Guillaume Yziquel <guillaume.yziquel@bluebottle.com>:
> Harold A. Gim�nez 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@seldon:~$ psql -U postgres
> psql: impossible de se connecter au serveur: Permission non accord�e
> Est-ce que le serveur tourne sur l'h�te local
> et accepte des connexions au socket Unix �
/var/run/postgresql/.s.PGSQL.5432 �?
Doing su - postgres and psql yields:
> postgres@seldon:~$ psql
> psql: FATAL: La base de donn�es � postgres � n'existe pas
> postgres@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.yziquel@free.fr
> > <mailto:guillaume.yziquel@free.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.
