Re: postgres account default password

From: Yves <yvenault(at)yahoo(dot)ca>
To: postgreSQLNovice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: postgres account default password
Date: 2004-07-16 11:26:23
Message-ID: 20040716112623.92492.qmail@web41511.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)oenone(dot)de> wrote: > ok, here
for the list.. sorry..
>
> On Thu, 15 Jul 2004 14:31:26 -0400
> Frank Bax <fbax(at)sympatico(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message M. Bastin 2004-07-16 11:57:57 Multiple clients over singele TCP/IP connection
Previous Message Tom Lane 2004-07-16 03:35:31 Re: Assigning a return value from a function to a variable.