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

From Peter Eisentraut
Subject Re: [GENERAL] copying databases
Date
Msg-id Pine.LNX.4.21.0002220044480.349-100000@localhost.localdomain
Whole thread Raw
In response to copying databases  (Marco Giardini <marco@tecnogi.com>)
List pgsql-general
On 2000-02-21, Marco Giardini mentioned:

>  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).

pg_dump it to a file and read it back in with psql. Chances are you won't
have much luck though, since what 6.5.3's pg_dump creates is generally
only intended for later releases. Software is generally not optimized for
downgrading. ;)

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-general by date:

Previous
From: Teruel Tony
Date:
Subject: Passwords
Next
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] Error using update