Re: How to connect to the database server

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?

Regards,
GREG COCKS
gcocks(at)stoller(dot)com

-----Original Message-----
From: guillaume(dot)yziquel(at)free(dot)fr [mailto:guillaume(dot)yziquel(at)free(dot)fr]
Sent: Thursday, May 22, 2008 12:46 PM
To: harold(dot)gimenez(at)gmail(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
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>

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.