Re: [GENERAL] copying databases - Mailing list pgsql-general

From Stephane Bortzmeyer
Subject Re: [GENERAL] copying databases
Date
Msg-id 200002211556.QAA28861@ezili.sis.pasteur.fr
Whole thread Raw
In response to copying databases  (Marco Giardini <marco@tecnogi.com>)
List pgsql-general
On Monday 21 February 2000, at 14 h 34, the keyboard of Marco Giardini
<marco@tecnogi.com> wrote:

>  i have created a DB on one server using postgresql 6.5.3 and now i need
> to move this DB to a machine running the postgresql 6.3 release (theone
> shipped with debian slink).

The simplest solution is 'pg_dump BASE' on one machine and 'psql -f FILE BASE' on the other. It frees you from
Postgres'versions. 

[The only problem I know is if you use BLOBs.]



pgsql-general by date:

Previous
From: Marco Giardini
Date:
Subject: copying databases
Next
From: "Paulo Parola"
Date:
Subject: No pg_hba.conf entry ???