Στις 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
Στις 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
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
Στις 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
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
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
"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
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
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
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
10 matches
Mail list logo
