the query worked before on the old installations,
now also core dump in the old installations [I can't think of
any settings' changes, the olnly change is the volume of the data
increased],
which might be indicated the core dump issue
is caused by something else.
Here's the logs whenever this core dump happens -
2003-11-24 14:22:25 LOG: pq_flush: send() failed: Broken pipe
is it socket related? how and why?
Again, the same query + "limit 20000" works.
thanks.
johnl
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Friday, November 21, 2003 12:42 PM
> To: John Liu
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] core dump
>
>
> "John Liu" <johnl@emrx.com> writes:
> > 1. I copied the entire data directory [including
> > postgresql.conf, base, ...] from postgreSQL 7.3.2 (AIX4.3)
> > to the installation postgreSQL 7.3.4 (AIX5.1), the same filesystem
> > setup. I didn't do an dump/reload process
> > since the copy process is faster.
>
> > Is it OK to take this shortcut in postgreSQL? any side-effects?
>
> Given that you are now seeing problems on the new installation, it seems
> it didn't work too well :-(
>
> I'm not sure why though. 7.3.2->7.3.4 should not have any file-level
> incompatibilities, assuming you built both with the same configure
> options (might be worth double-checking that). The OS version jump
> might possibly be the culprit --- is it possible they changed the
> compiler's struct packing rules between 4.3 and 5.1? Oh, and I'm
> assuming these systems are the same underlying hardware architecture ...
>
> regards, tom lane
>
