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, Gerald Waugh wrote:

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

Oh, I'm sure of that.

> I am sure there must be incidents in the archives,

Well, not that I've found. I've checked.

> I read in the last few days Steve Werby tell about it.

Yup, saw that:

	http://marc.theaimsgroup.com/?l=cobalt-users&m=101295575022994&w=2

However, he didn't actually say that he's done it. Nor have I found
anyone else in the archives that have said that they've done it. As I
mentioned above, I don't have a spare raq and I'm hesitant to try this
out for the first time on my _production_ box - that's always fraught 
with danger.

I've managed several *nix servers in the past, rarely use rpms, and
build most things (including kernels) from source, so I have a good
grasp of what I'm doing [1]. What I'm concerned about is that there's
some 'cobaltism' lurking somewhere where I'm going to find out that:
Oh, you should have run 'cobalt-foo' before you ran 'bar'.

> 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).

Thanks for that. I've now managed to back up all my db's.

[1] So why are you running a cobalt, you ask? That's another story. :)

Carpe viam,
Mike