| From: | "Scott Marlowe" <smarlowe(at)qwest(dot)net> |
|---|---|
| To: | "Bill Moran" <wmoran(at)potentialtech(dot)com> |
| Cc: | "John Liu" <johnl(at)emrx(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: core dump |
| Date: | 2004-06-07 22:34:58 |
| Message-ID: | 1086647698.27200.23.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2004-06-07 at 16:19, Bill Moran wrote:
> "John Liu" <johnl(at)emrx(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric.Hillmuth | 2004-06-07 23:04:06 | could not bind IPv4 socket: Address already in use |
| Previous Message | Scott Marlowe | 2004-06-07 22:31:09 | Re: core dump |