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: 20040716112623.92492.qmail@web41511.mail.yahoo.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group