What am I missing? When you installed PostgreSQL you set the passwords,
etc as part of the installation process, no?
If you have not started to populate the database yet, how about
uninstalling, rebooting, and then reinstalling with a note made of your
password and other settings?
From: guillaume(dot)yziquel(at)free(dot)fr [mailto:guillaume(dot)yziquel(at)free(dot)fr]
Sent: Thursday, May 22, 2008 12:46 PM
Subject: Re: [NOVICE] 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>
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
Doing su - postgres and psql yields:
> postgres(at)seldon:~$ psql
> psql: FATAL: La base de donnes postgres n'existe pas
Seems like I need to know what are the databases inside my cluster...
Thanks again for your help.
> > 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
> > 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
> > 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
> > unable to find
> > them again).
> > My question is the following: How can I get to connect directly
> > 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
> > the wrong
> > placem or perhaps in the right but failing to see the light...
> > you have a
> > relevant link, I'm dying to hear about it.
> > Guillaume.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2008-05-22 19:50:04|
|Subject: Re: How to connect to the database server |
|Previous:||From: guillaume.yziquel||Date: 2008-05-22 18:46:15|
|Subject: Re: How to connect to the database server|