-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Tom Lane wrote:
> When dumping from 9.2 or newer, it'll be worth your trouble to refine
> that strategy by using pg_dump's new "--section" switch to split the
> dump file three ways: pre-data, data, post-data.
And if you have a dump from 9.1 or
Adrian Klaver writes:
> On 04/08/2013 06:41 AM, Pete Wall wrote:
>> I think the only way would be to "manually" dump the data using custom
>> psql commands instead of using pg_dump/pg_dumpall.
> You could use the -a (data only) switch to pg_dump:
> http://www.postgresql.org/docs/9.2/interactive/a
On 04/08/2013 06:49 AM, Pete Wall wrote:
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.
The complementary switch to -a is -s which dumps only the schema. Might
be worth it 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 wrote:
>> It was the data chang
On 04/08/2013 06:41 AM, Pete Wall wrote:
It was the data changes I was concerned about: Any
additions/deletions/modifications done on the database while it's using
the 9.x binaries that should be brought back if we downgrade to the 8.x
version.
I think the only way would be to "manually" dump th
It was the data changes I was concerned about: Any
additions/deletions/modifications done on the database while it's using
the 9.x binaries that should be brought back if we downgrade to the 8.x
version.
I think the only way would be to "manually" dump the data using custom
psql commands instead o
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 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 ch
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 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 chan
On 4/5/2013 3:33 PM, Pete Wall wrote:
Is there a supported way to downgrade PostgreSQL by major versions?
no.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
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
10 matches
Mail list logo
