Skip site navigation (1) Skip section navigation (2)

Re: win32: how to backup (dump does not work)

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Gevik Babakhani <pgdev(at)xs4all(dot)nl>
Cc: fkater(at)googlemail(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: win32: how to backup (dump does not work)
Date: 2008-02-27 09:09:33
Message-ID: 20080227090933.GB5916@svr2.hagander.net (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-general by date

Next:From: Magnus HaganderDate: 2008-02-27 09:10:40
Subject: Re: win32: how to backup (dump does not work)
Previous:From: Stuart BrooksDate: 2008-02-27 07:18:50
Subject: Re: autovacuum not freeing up unused space on 8.3.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group