Re: db [Viruschecked] - Mailing list pgsql-jdbc

From Patric Bechtel
Subject Re: db [Viruschecked]
Date
Msg-id 20030702085236.DA15E310E36@svr1.postgresql.org
Whole thread Raw
In response to db  ("Daniel Phlander" <phlander@friendnet.org>)
List pgsql-jdbc
-----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-----



pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: New patches
Next
From: "Akash Shah"
Date:
Subject: Please help with binary file