Re: FK disappeared in 8.3.3

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-admin(at)postgresql(dot)org
Subject: Re: FK disappeared in 8.3.3
Date: 2010-11-23 08:39:27
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Στις Monday 22 November 2010 18:45:28 γράψατε:
> Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> wrote:
> > (imagine having to upgrade 61 installations for which you dont
> > have ssh/scp ;) sounds fun right? )
> I don't have to imagine -- been there, done that. (Not with ships
> but large geographical distances and needing to trudge through
> secure facilities with big steel doors every so many feet.) It can
> be time-consuming and tedious. But then, so can recovering a
> corrupted database.

What you describe is an entirely different situation.

> If I were in your shoes, I'd consider arranging to have a CD-ROM
> mailed to someone on each ship at its next port, with a script which
> would automatically perform the update. (Heavily tested in advance,
> of course.)

This in unrealistic. Many things can go wrong, and in this case the vessel
stays offline, which is a very very bad thing.
(imagine to be hard to make a telephone call, and after hours of effort to hear a nice Indian
guy with whom you cant communicate due to different accents of English
since both we are non native english speakers)
btw, we use tsearch2, intarray, which require an upgrade plan by their own,
if you have ever done this.
In addition, i must say that we have about 290 tables in our schema.
Its not the kind of DB you would simply upgrade with a CDROM.
The huge improvements between 7.4.* and 8.3.* were about performance
and not stability. Lack of stability is not smth PostgreSQL is famous for.
So we perform the upgrade to 8.3 only when we send one of our people

> Of course, none of that helps with your current issue; I would just
> hate to see you pop up here in a few months with bigger problems
> than this if it can be avoided.

We had bigger problems than this and still survived, dont worry ;)
PostgreSQL (be it 7.4.2, 7.4.19 or 8.3.3) in our 60+ vessels, is the last thing we have worried about
over the last 10 years. Generally PostgreSQL lasts even after hardware/OS have given up.

Dont get me wrong, i would love to see all our systems running the latest 9.0.1, and all the rest of software
(jboss, java, linux) to be on their latest releases.
However this is such a huge project to accomplish and our human resources are very limited.
(i am the DBA, linux, freebsd sysadm, java j2ee programmer, architect, etc.....)

Also, if there is no explicit upgrade plan (first in the office, second on vessels), then i prefer sticking
to 8.3.3 on the vessels, until we commit to do a serious upgrade.
I cannot start an initiative by myself, only to find later, that i just increased my own time spend on managing
who has what in the whole fleet.

But the real pain is the lack of TCP/IP and remote shell whenever we want it.

Anyways thanx for helping by sharing your thoughts.

> -Kevin

Achilleas Mantzios

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message tomislavb 2010-11-23 12:24:25 managing access to database
Previous Message Achilleas Mantzios 2010-11-23 08:14:57 Re: FK disappeared in 8.3.3