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

Re: step 2..

From: Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de>
To: tallison(at)tacocat(dot)net (Tom Allison)
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: step 2..
Date: 2004-03-17 10:03:23
Message-ID: 200403171003.i2HA3NE4006995@lurza.secnetix.de (view raw or flat)
Thread:
Lists: pgsql-novice
Tom Allison wrote:
 > I got postgres installed and working.
 > I created some users and a database.
 > 
 > but I don't see where I set the passwords or know the passwords for 
 > these users.  Or user postgres for that matter.

template1=# ALTER USER foobar ENCRYPTED PASSWORD 'xxxxxxxx' ;

You have to specify the cleartext password (but it will be
stored encrypted by PostgreSQL).  It's an SQL string, so be
sure to enclose it in single quotes.  For details, see:

http://www.postgresql.org/docs/7.4/static/sql-alteruser.html

Regards
   Oliver

-- 
Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.

PI:
int f[9814],b,c=9814,g,i;long a=1e4,d,e,h;
main(){for(;b=c,c-=14;i=printf("%04d",e+d/a),e=d%a)
while(g=--b*2)d=h*b+a*(i?f[b]:a/5),h=d/--g,f[b]=d%g;}

In response to

  • step 2.. at 2004-03-17 02:28:22 from Tom Allison

pgsql-novice by date

Next:From: Christian PöcherDate: 2004-03-17 10:13:58
Subject: Re: Removing "lost" locks
Previous:From: Christian PöcherDate: 2004-03-17 09:55:24
Subject: Error in book

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