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

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

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

Jeff Kowalczyk wrote:
> Joshua D. Drake wrote:
>>> 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:

>   If you prefer to work in postgresql's psql console, the equivalent SQL
>   statement to create the ledgersmb role is:
> 
>   => CREATE ROLE ledgersmb LOGIN PASSWORD 'MYROLEPASSWORD' NOINHERIT
>   CREATEDB;
> 
>   Further commands and database interaction should be conducted using
>   the new LedgerSMB admin role 'ledgersmb'.
> 
> 
> Do we need a note for postgresql-8.0?

Yeah probably, as 8.0 as USER/GROUP versus ROLE. However it should be
noted that as of 1.3, 8.0.x is deprecated.

Joshua D. Drake


> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> 


- --

      === 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

iD8DBQFG7/9bATb/zqfZUUQRAqKTAJwJmTd8BdJz7RdtvgP62Zs/cxGiKACfWQ7X
oygmGlJqiYzW5Nzx2NBck2c=
=CV65
-----END PGP SIGNATURE-----