Re: Not Finding password for Postgres user on linux

Hi all

Just now I tried following

$psql -u template1
Username: postgres
Password:

Welcome to the POSTGRESQL interactive sql monitor:
  Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]

   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: template1

template1=>

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