Moving data directory from one server to another

From: Ehsan Haq <ehsan_haq98(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Moving data directory from one server to another
Date: 2010-03-26 18:25:56
Message-ID: 741639.12107.qm@web31802.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2010-03-26 18:32:00 Re: Warm Standby Setup Documentation
Previous Message Tom Lane 2010-03-26 18:19:09 Re: Error 42501 permission denied for schema