| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2008-02-27 09:10:40 | Re: win32: how to backup (dump does not work) |
| Previous Message | Stuart Brooks | 2008-02-27 07:18:50 | Re: autovacuum not freeing up unused space on 8.3.0 |