Re: Almost done with manual for Gentoo - but need some help

["Joshua D. Drake" <..hidden..>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Joseph wrote:
> When I type:
> $ psql -U ledgersmb -d ledgersmb_db
> 
> I get:
> Welcome to psql 8.0.13, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> ledgersmb_db=#
> 
> At this point to change or setup password for this user "ledgersmb" and
> database "ledgersmb_db" do I type:
> UPDATE users_conf SET password = md5('MYPASSWORD') WHERE id = 1;

Wrong... use:

ALTER USER name WITH ENCRYPTED PASSWORD 'password';

Joshua D. Drake

> 
> Do I need to type password within bracket and quotation: ('phrase') 
> 


- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
			UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG7yXnATb/zqfZUUQRAmFGAJ94ft49iPgS0oQPrsCprFW+GSvRPQCgkQA+
hK+KGYUEf2xa+dRpTYWI9ec=
=TNN2
-----END PGP SIGNATURE-----