Re: [cobalt-users] Re: Upgrage of Postgresql (was: PHP 4.1.1 for RaQ 4 betatesters needed !)

[Gerald Waugh <gwaugh@xxxxxxxxxxxxxxxxxxxxxxx>]

On Mon, 25 Feb 2002, Michael Larocque wrote:
> As Sun/Cobalt is unlikely to upgrade postgresql, I'll ask a followup:
> Has anyone built a second instance of postresql on a RaQ4? I've
> checked the archives but haven't found a message about someone
> actually installing a second instance. I've grabbed 7.2, configured it
> to install in /home/local/pgsql and run on a different port, ran
> 'make' but I haven't done a 'make install'. As I don't have a test
> cobalt machine to try this on, I'm a bit reluctant to try this on our
> production box.

Many people have done this. I am sure there must be incidents in the archives,
I read in the last few days Steve Werby tell about it.

> 
> As an aside, before I do anything, I'd like to pg_dump all the 
> databases on this box. However the 'cobalt' database is protected with 
> a password. When I attempt a
> 
> 	pg_dump -u cobalt
> 
> and enter 'postgres' for the username, and the postgres unix password 
> for the password, it returns with
> 
> 	Connection to database 'cobalt' failed.
> 	Password authentication failed for user 'postgres'
> 


Your password for the user admin in postgres is in /etc/cobalt/.meta.id
So, if you want to connect as admin, you type 
psql -u cobalt 
username is admin
password (whatever is in /etc/cobalt/.meta.id).

Easiest to open the file and copy the password to the clipboard.

--
Gerald Waugh