From: | "Nandu Garg" <focussed(at)rediffmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Not Finding password for Postgres user on linux |
Date: | 2002-01-24 09:27:15 |
Message-ID: | 20020124092715.10200.qmail@mailweb14.rediffmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 error messge. 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(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Nandu Garg | 2002-01-24 09:48:39 | Re: Not Finding password for Postgres user on linux |
Previous Message | Denis Perchine | 2002-01-24 09:14:11 | Problem with btree index on 7.1.3 |