Re: [GENERAL] copying databases

From: Stephane Bortzmeyer <bortzmeyer(at)pasteur(dot)fr>
To: Marco Giardini <marco(at)tecnogi(dot)com>
Cc: pgsql-novice(at)postgreSQL(dot)org, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] copying databases
Date: 2000-02-21 15:56:56
Message-ID: 200002211556.QAA28861@ezili.sis.pasteur.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday 21 February 2000, at 14 h 34, the keyboard of Marco Giardini
<marco(at)tecnogi(dot)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.]

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pete Bass 2000-02-21 16:35:37 Update Error
Previous Message Marco Giardini 2000-02-21 13:34:36 copying databases