It took me a week to figure out how to figure out how and where to enter that "select version();" command.
I've figured out that I am running PostgreSQL 7.4.3 on i386-portbld-freebsd4.10, compiled by GCC 2.95.4.
I'm guessing, after looking at <http://www.postgresql.org/>http://www.postgresql.org/ that I should upgrade to Version 7.4.27, correct? This upgrade won't confuse old shell, PHP and Perl scripts or otherwise confuse FreeBSD, correct?
Can you point me to novice-friendly step-by-step instructions?
At 06:50 PM 1/27/2010, Tom Lane wrote:
>> 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: peter||Date: 2010-02-06 15:08:50|
|Subject: Incomplete pg_dump operation|
|Previous:||From: Mladen Gogala||Date: 2010-02-05 23:07:57|
|Subject: Re: trouble with an older version of postgresql|