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

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

"Michael Larocque" <mlarocque@xxxxxxx> 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?

Yes, I just installed it on a different port than Cobalt's install.  I've
installed PostgreSQL on the RaQ2, RaQ3 and RaQ4 with no problem.

> 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 long as you configured it to use different paths than the current install
you'll be ok.  You can always do "make -n install" to check what that step
will do without actually running it so you can verify it won't be a problem
before you run it for real.

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

IIRC, the password is located in /etc/cobalt/.meta.id.  And in any case you
could change the access control in /var/lib/pgsql/data/pg_hba.conf
temporarily and then run pg_dump.  Accessing the cobalt db has been covered
on-list so you may want to search the archives again.  Maybe "cobalt
postgresql password" or something similar.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/