> Maybe. How would I do that? I'm running whatever version of PostgreSQL was current in mid-2004.
2004 was a very long time ago :-(. A quick look at the release history
suggests that you could not be running anything newer than about 7.4.2,
and it could easily be a 7.3.x release or something even older instead.
You really ought to update the server version before expending any
additional thought on this, since the odds are reasonably good that that
crash is something we fixed long since.
Do "select version();" to see exactly what version you have got, and
then see about updating to the latest minor release in that major
release series. Such an update should be relatively painless (no dump
and reload) though it'd still be smart to peruse the release notes to
see if there were any small behavioral changes that might affect your
If you still see the crash on the latest minor version, it'd be worth
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Didier Gasser-Morlay||Date: 2010-01-28 06:46:00|
|Subject: PpgSQL Autovacuum|
|Previous:||From: peter||Date: 2010-01-27 23:23:42|
|Subject: Re: Database handle destroyed without explicit