[cobalt-users] Re: PostgreSQL HowTo

[Bruce Timberlake <bruce@xxxxxxxxxx>]

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

> I have looked for, but not found, a HowTo for accessing the
> PostgreSQL DB on a RAQ4. Anyone know of such a document?

Depends on what you mean by "access" - for command-line tools, there 
is actually some info in the RaQ 4 manual... :)

1. The "admin" user password is in /etc/cobalt/.meta.id - I usually 
"cat" it then copy the string to the paste buffer

2. psql -Uadmin cobalt  (then paste the password and you're in)

(alternatively you can edit the pg_hba.conf file and change the line 
"local cobalt crypt" to "local all trust" and then do

su - postgres; psql cobalt

Remember to put pg_hba.conf back the way you found it when you're 
done...


If you mean access via Perl, etc, that gets more complicated, and I 
recommend looking at the various Cobalt Perl modules already on the 
system for specific examples and code snippets.

- -- 
Bruce Timberlake

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+bQQtvLA2hUZ9kgwRAgiRAJ4+rQtqFHp2/XxAohKRjn0yGsGe2ACfXDkL
elMGZZ0Wgr+5Me7cKkZJ6SQ=
=wBiu
-----END PGP SIGNATURE-----