Re: win32: how to backup (dump does not work) - Mailing list pgsql-general

From Magnus Hagander
Subject Re: win32: how to backup (dump does not work)
Date
Msg-id 20080227090933.GB5916@svr2.hagander.net
Whole thread Raw
In response to Re: win32: how to backup (dump does not work)  ("Gevik Babakhani" <pgdev@xs4all.nl>)
List pgsql-general
On Tue, Feb 26, 2008 at 10:30:02PM +0100, Gevik Babakhani wrote:
> > 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.

You don't need to reassign owner normally - we don't care about that. And
if you extract into an existing directory, it should inherit it fine :-)
But true, if you extract into a nwe directory, you may need to change the
permissions.

//Magnus

pgsql-general by date:

Previous
From: Olmec Sinclair
Date:
Subject: Re: Trouble running PostgreSQL server / Server must be started under certain locale.
Next
From: Magnus Hagander
Date:
Subject: Re: win32: how to backup (dump does not work)