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

[Michael Larocque <mlarocque@xxxxxxx>]

On Mon, 25 Feb 2002, Taco Scargo wrote:

> Hi Mike,
> 
> > Is there any chance that there will be an upgrade of postgresql on the 
> > RaQ 4 any time? The 4R is currently running 7.0.2. Current is 7.2.
> > There have been lots of problems solved, and lots of new features 
> > added between those two versions.
> 
> As Postgresql is used in the administrative server (it is used to store all 
> configuration) I don't expect Sun Cobalt (or pkg.nl.cobalt.com) to create an 
> update.
> 
> With regards,
> 
> Taco Scargo

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.

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'

Any ideas?

Carpe viam,
Mike