Re: postgres account default password - Mailing list pgsql-novice

From Yves
Subject Re: postgres account default password
Date
Msg-id 20040716112623.92492.qmail@web41511.mail.yahoo.com
Whole thread Raw
In response to Re: postgres account default password  (Julian Leyh <oenone@oenone.de>)
Responses Re: postgres account default password  (Frank Bax <fbax@sympatico.ca>)
List pgsql-novice
Thanks fo the replies,

I changed the password of the postgres account and
still cannot log in...

Should the root account be like an administrative
account having all rights and privileges within the
postgres server?

Thanks,

Yves


--- Julian Leyh <oenone@oenone.de> wrote: > ok, here
for the list.. sorry..
>
> On Thu, 15 Jul 2004 14:31:26 -0400
> Frank Bax <fbax@sympatico.ca> wrote:
>
> > Login as yourself, 'su' to root, then 'su' to
> postgres (there will be
> > no password prompt), then change the password.
>
> better: use sudo(8).
> for example: sudo -u postgres psql foobar
>
> no need to enter root password.
>
> cu
> JRL
>
> --
> visit my OpenBSD ports page: http://vgai.de/ports
> --
> If you don't remember something, it never existed...
> If you aren't remembered, you never existed...
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
>       joining column's datatypes do not match
>

______________________________________________________________________
Post your free ad now! http://personals.yahoo.ca

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Assigning a return value from a function to a variable.
Next
From: "M. Bastin"
Date:
Subject: Multiple clients over singele TCP/IP connection