Re: core dump - Mailing list pgsql-general

From Bill Moran
Subject Re: core dump
Date
Msg-id 20040607181940.57d434d7.wmoran@potentialtech.com
Whole thread Raw
In response to core dump  ("John Liu" <johnl@emrx.com>)
Responses Re: core dump
List pgsql-general
"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.

Otherwise, you may want to provide more details about the host system and
the upgrade procedures you followed.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com

pgsql-general by date:

Previous
From: Richard Poole
Date:
Subject: Re: generic insert into table
Next
From: "Scott Marlowe"
Date:
Subject: Re: generic insert into table