Re: Not Finding password for Postgres user on linux

Hi Amol,

PLEASE upgrade to PostgreSQL 7+ !  The latest production-quality release
of PostgreSQL is 7.1.3, and if you've got a choice, that's your best
one.  :)

Versions of PostgreSQL older than version 7.x (you're running version
6.5.3) have some pretty nasty bugs in them, and because they're so old
we have difficulty in offering much in the way of assistance when you
have a problem.  :(

If you can upgrade, it'll give you a better (faster, more stable, more
powerful SQL capabilities, better crash recovery (if it ever crashes))
database, and it's also easier to tune for better performance.

Hope this helps.

:-)

Regards and best wishes,

Justin Clift


Nandu Garg wrote:
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi