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

win32: how to backup (dump does not work)

From: "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: win32: how to backup (dump does not work)
Date: 2008-02-26 20:51:57
Message-ID: 20080226205157.GA5602@comppasch2 (view raw or flat)
Thread:
Lists: pgsql-general
Hi,

I urgently need a way to simply backup the database's data on win32
(e.g. the 'data' directory).

As discussed earlier I can't use dump/dumpall since my data needs
persistent tableoids which, however, are not the same after a restore.

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.

Does anyone have another idea how to backup (besides disk images)?

Thank You
Felix



Responses

pgsql-general by date

Next:From: Scott MarloweDate: 2008-02-26 21:00:26
Subject: Re: How to copy tables between databases?
Previous:From: Richard HuxtonDate: 2008-02-26 20:43:54
Subject: Re: How to copy tables between databases?

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