Moving a PostgreSQL database from one server to another

Bruno Wolff III bruno at wolff.to
Mon Jan 17 05:54:59 UTC 2005


On Fri, Jan 14, 2005 at 14:39:03 +0200,
  "Anthony E. Greene" <tony at greene-family.org> wrote:
> On 1:16 Jan 14, 2005 Aly Dharshi <aly.dharshi at telus.net> wrote:
> > <snip>
> >
> > >  If the destination is the same CPU type you
> > >  can get away with copying the files under /var/lib/pgsql/ instead,
> >
> > isn't this something dangerous to do, regardless of the cpu being the
> > same ?
> 
> The PostgreSQL versions should be the same too. Sometimes the binary file
> format changes between versions.

It should also be bult with the same configure options. If you are using
the same rpm on the same architecture type you should be OK.




More information about the fedora-list mailing list