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;}