> From: Tom Lane <[EMAIL PROTECTED]>
> Date: Wed, 09 Feb 2005 23:50:47 -0500
> To: Steve Lane <[EMAIL PROTECTED]>
> Cc: "Joshua D. Drake" <[EMAIL PROTECTED]>, ,
> Jesse LaVere <[EMAIL PROTECTED]>
> Subject: Re: [ADMIN] PG 7.4: duplicate rows in violation of unique
>
> Steve Lane <[EMAIL PROTECT
Tom:
Thanks. What's odd here is that we seemed to have none of them, and then
found a bunch, immediately after processes starting crashing.
This is not the first time this has happened -- we had an outbreak once
before.
It's quite possible that we had these lurking in there for a while, and only
Steve Lane <[EMAIL PROTECTED]> writes:
> Sorry -- 7.4.5
I'm wondering if this could be related to this post-7.4.5 fix:
2004-10-13 18:22 tgl
* contrib/pgstattuple/pgstattuple.c,
src/backend/access/heap/heapam.c,
src/backend/utils/adt/ri_triggers.c (REL7_4_STABLE): Repair
Sorry -- 7.4.5
-- sgl
> From: "Joshua D. Drake" <[EMAIL PROTECTED]>
> Date: Wed, 09 Feb 2005 17:26:12 -0800
> To: Steve Lane <[EMAIL PROTECTED]>
> Cc: , Jesse LaVere <[EMAIL PROTECTED]>
> Subject: Re: [ADMIN] PG 7.4: duplicate rows in violation of unique constraint
>
> Steve Lane wrote:
>
>> A
Steve Lane wrote:
All:
Puzzling PG 7.4 behaviors. Began yesterday, running under RedHat ES 2.1.'
Which version of 7.4?
First symptom were many query failures, along with the message that a server
process had crashed, possibly corrupting shared memory. These messages kept
coming. I shut down the
All:
Puzzling PG 7.4 behaviors. Began yesterday, running under RedHat ES 2.1.
First symptom were many query failures, along with the message that a server
process had crashed, possibly corrupting shared memory. These messages kept
coming. I shut down the postmaster, and did ipcclean.
Started pos
On Wed, 2005-02-09 at 11:01, Marek Lewczuk wrote:
> Shashi Gireddy napisaÅ(a):
> > I recently migrated from MySql, The database size in mysql was 1.4GB (It is
> > a static database). It generated a dump file (.sql) of size 8GB), It took
> > 2days to import the whole thing into postgres. After all
Shashi Gireddy napisaÅ(a):
I recently migrated from MySql, The database size in mysql was 1.4GB (It is a static database). It generated a dump file (.sql) of size 8GB), It took 2days to import the whole thing into postgres. After all the response from postgres is a disaster. It took 40sec's to run
