-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Tue, 1 Jul 2003 13:34:35 +0300, Daniel Phlander wrote:
>Hello!
>I have a problem:
>I have installed PostgreSQL 7.3.3 and I have also put in the db a ( /usr/local/pgsql/bin/pg_dumpall > backup.sql ),
whichI made from a PostgreSQL 7.2.4.
backup.sql; has uploaded with no problem, but now in the applications on which I work I have to make backup.sql from
PgSQL7.3.3 and to put into PgSQL 7.2.4., but
I see this is not working (I have errors).
>I want to know how can I put a backup.sql made on a PgSQL 7.3.3 and to upload it into PgSQL 7.2.4. ?
>I look forward to hear from you! Thanks.
>Daniel
Hello Daniel,
I do this regularly, too, and do it with this combination:
pgdump -Fp -f <file> -d <databasename>
and then (on the "other side")
psql <databasename>
\i <file>
works fine. Sometimes I've to correct a few lines at the beginning, meddling with schema paths and such. But that's it.
Hope that helps,
Patric
PGP Public Key Fingerprint: 2636 F26E F523 7D62 4377 D206 7C68 06BB
-----BEGIN PGP SIGNATURE-----
Version: PGPsdk version 1.7.1 (C) 1997-1999 Network Associates, Inc. and its affiliated companies.
iQA/AwUBPwKPFnxoBrvMu8qQEQKfiQCgttjLDoHBppyVM7K16R32lauXCV8AoNHZ
kjB6sNT757Is8NriN01UUxkU
=auKY
-----END PGP SIGNATURE-----