Re: db [Viruschecked]

-----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 ), which I 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 PgSQL 7.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-----