Postgres Pro
Downloads
Home   >   mailing lists

Moving data directory from one server to another - Mailing list pgsql-general

From Ehsan Haq
Subject Moving data directory from one server to another
Date
Msg-id 741639.12107.qm@web31802.mail.mud.yahoo.com
Whole thread Raw
List pgsql-general
Tree view
Hi,
   I have two Linux servers both having same Hardware architecture one have ES5 and the other having ES4. Both the servers have same version of PostGres installed (8.3). I want to move all my DBs from ES5 server to ES4 server. I have tried the pg_dump but there are a lot of encoding problems, so can I copy the whole data directory from ES5 server to ES4 server when the PostGres server is not running? Will it be safe?

Thanks
Ehsan

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error 42501 permission denied for schema
Next
From: Greg Smith
Date:
Subject: Re: Warm Standby Setup Documentation