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