Hi Yar, Thanks for the reply. I gave it a try, but found that there was a slight problem as the directory path of PostGres on the two servers were different. Thats why my test failed. If you have any ideas about how to overcome this (which configuration files are required to be changed). Please let me know. Thanks Ehsan
--- On Mon, 3/29/10, Yar Tykhiy <y...@barnet.com.au> wrote: From: Yar Tykhiy <y...@barnet.com.au> Subject: Re: [GENERAL] Moving data directory from one server to another To: "Ehsan Haq" <ehsan_ha...@yahoo.com> Date: Monday, March 29, 2010, 1:01 AM Hi Ehsan, On Fri, Mar 26, 2010 at 11:25:56AM -0700, Ehsan Haq wrote: > 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? Apart from my having no idea what ES4 or ES5 is, my experience with moving a pgsql data directory across machines has been very positive as long as the machine architecture and Postgresql version are the same. Of course, doing a test run before actually switching everything over will be a very good idea. Yar