Re: Not Finding password for Postgres user on linux

Hi

I am connected to Linux $ prompt with user 'amol' which has Oracle DBA privileges. When I try to connect using
$su postgres       It prompts me for the password (which I donno) and when I issue $psql -U postgres Template1
I give me 'psql: invalid option -- U'
Therefore I tried small u i.e. I issued the command
'$psql -u postgres template1' It prompted me like this
Username: postgres
Password:

Connection to database 'postgres' failed.
FATAL 1:  Database postgres does not exist in pg_database

When It asked me for username I entered 'postgres' as username and  password I kept empty but still it gave me above
errormessge. I donno how suddenly it said 'database postgres ' does not exists because I entered postgres as username. 

Amol



On Thu, 24 Jan 2002 Dmitry Alyabyev wrote :
> Thursday, January 24, 2002, 9:13:22 AM, Nandu  Garg
> wrote:
>
>
> > Hi All
>
> > I have just now got the Postgresql installed again.
> But again before connecting it it requires me to
> connect to Postgres user. Now how could I get
> connected. There is nothing mentioned in Postgre
> > documentation about the default password. Is the
> password allocated dynamically?
> > My linux administrator says he could not find the
> password. Do I have to create a new user where it's
> group is pg_database or what?
>
> Take a look at data/pg_hba.conf file.
> By default postgres allow connect without password for
> user 'postgres'
> so you can type: psql -U postgres template1
>
>
> --
> Dimitry
>
>
>
> ---------------------------(end of broadcast)
> ---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org