Is it possible to downgrade PostgreSQL by a major version?
If I want to upgrade a PG database from 8.x to 9.x, I have to dump the db,
install the new binaries and import the dump file. This works fine going
forward, but what if I need to rollback my changes? I cannot dump the 9.x
database and
ommands instead of using pg_dump/pg_dumpall.
Thanks, Adrian.
On 4/5/13 6:35 PM, "Adrian Klaver" wrote:
>On 04/05/2013 03:33 PM, Pete Wall wrote:
>> Is it possible to downgrade PostgreSQL by a major version?
>>
>> If I want to upgrade a PG database from 8.x to
All tables and rules would be the same. I assume with the -a flag, we'd
need to create the database and relations beforehand, but that shouldn't
be too much trouble.
Thanks again,
-Pete
On 4/8/13 8:46 AM, "Adrian Klaver" wrote:
>On 04/08/2013 06:41 AM, Pete Wall wr
Hello,
I am upgrading the version of PostgreSQL used in our product from 8.3.9 to
8.3.15 to close some of the vulnerabilities. After upgrading, I found that it
wouldn't work on our Windows 2003 boxes, but it was fine on the 2008 ones. I
downloaded every binary release from ..9 to ..15 (from he
Any ideas? Has anybody else had luck or problems with the new versions on
Windows Server 2003?
Thanks,
-Pete
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Pete Wall
Sent: Thursday, August 18, 2011 4:58 PM
To: pgsql-general@postgresql.org
As an update, we found a 2008 box that had the same problem as below, so it
doesn't seem to be a problem with Windows 2003.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Pete Wall
Sent: Wednesday, August 24, 2011 2:54 PM
To: pgsql-ge
