Hello,
in one (out of our 60+) PostgreSQL systems which are deployed on tanker vessels
at open sea, we had the following problem:
One (ON DELETE CASCADE) FK constraint which was supposed to be there was found
to be (mysteriously) absent.
That caused am erroneous behaviour which manifested the pr
Achilleas Mantzios wrote:
> One (ON DELETE CASCADE) FK constraint which was supposed to be
> there was found to be (mysteriously) absent.
Do you have old backups to see how long it has been gone?
> So we pg_dumped the schema on a known good 8.3.3 identical test
> database
That's an oxymoro
Kevin thanx,
I explicitly wrote that:
"One additional issue that is worsening our situation is that we dont have
TCP/IP access to the vessel.
We only have term emulator (minicom) which dials up a remote mgetty
(which works only if the weather conditions are ok, and nothing else is broken:
read
"Kevin Grittner" writes:
> Achilleas Mantzios wrote:
>> I am puzzled about the differences in the schema, if any one has
>> any ideas of why this might be happening, would be great.
> My first guess is that they were dumped by pg_dump executables from
> different versions.
The differences do
Achilleas Mantzios 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 do
I must add (which i should have included in the original post),
that apart from the FK also 2 triggers on the same table were lost.
And in a 2nd table also two triggers were lost.
(all triggers for use with tsearch2)
Στις Monday 22 November 2010 18:11:12 γράψατε:
> The differences do look suspici
Στις Monday 22 November 2010 18:45:28 γράψατε:
> Achilleas Mantzios 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
Achilleas Mantzios writes:
> At this time our problematic vessel was running 7.4.2. This vessel upgraded
> to 8.3.3
> some time in January 2009.
7.4!?
I can't shake the suspicion that some of your issues arose from trying
to load a later-version pg_dump output into an older-version server.
The
Στις Tuesday 23 November 2010 17:22:29 ο/η Tom Lane έγραψε:
> Achilleas Mantzios writes:
> > At this time our problematic vessel was running 7.4.2. This vessel upgraded
> > to 8.3.3
> > some time in January 2009.
>
> 7.4!?
>
> I can't shake the suspicion that some of your issues arose from try
Στις Tuesday 23 November 2010 17:22:29 ο/η Tom Lane έγραψε:
> I don't have enough information to show the exact chain of events, but I
> think that something like this is a lot more probable than a random
> hardware failure that just happened to produce these particular results.
>
I just got repl
10 matches
Mail list logo
