> AFAIK stopping the server, zipping data dir, and restarting
> the server creates a zip file which is not easily portable to
> other computers due to some ntfs file system permission problems.
IIRC you have to re-assign owner and change permissions after you copy your
data dir to the new server.
In response to
pgsql-general by date
|Next:||From: Rodrigo E. De León Plicet||Date: 2008-02-26 21:37:08|
|Subject: Re: win32: how to backup (dump does not work)|
|Previous:||From: Ralph Smith||Date: 2008-02-26 21:26:58|
|Subject: Re: v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8|