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.