Re: core dump - Mailing list pgsql-general

From Scott Marlowe
Subject Re: core dump
Date
Msg-id 1086647698.27200.23.camel@localhost.localdomain
Whole thread Raw
In response to Re: core dump  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general
On Mon, 2004-06-07 at 16:19, Bill Moran wrote:
> "John Liu" <johnl@emrx.com> wrote:
>
> > We upgraded from 7.2 to 7.4, it looks like everything working, but when I
> > issue a query such as select * from tab (tab has about 2-3 million records),
> > it causes core dump. I tuned some the parameters, it still produce the core.
>
> It's unlikely that any config settings are causing coredumps.
>
> Did you backup and rebuild the database during the upgrade procedure?  If not,
> this could be your problem.  You can't run 7.4 on a 7.2 database.

7.4 should refuse to start, without touching the data directory in the
old 7.2 directory

You should get a version mismatch and a bail out when trying to do so.


pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: core dump
Next
From: Eric.Hillmuth@anr.state.vt.us
Date:
Subject: could not bind IPv4 socket: Address already in use