Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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?



--- 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
> -- 
> visit my OpenBSD ports page:
> --
> 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!

In response to


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group