On Wed, Feb 27, 2008 at 03:59:24PM +0100, [EMAIL PROTECTED] wrote:
> On 22:37 Tue 26 Feb , Magnus Hagander wrote:
> > [EMAIL PROTECTED] wrote:
>
> >> AFAIK stopping the server, zipping data dir, and restarting the server
> >> creates a zip file which is not easily portable to other computers d
On Tue, Feb 26, 2008 at 11:51:34PM -, Joris Dobbelsteen 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 h
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-assig
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of Gevik
>Babakhani
>Sent: Tuesday, 26 February 2008 22:30
>To: [EMAIL PROTECTED]; pgsql-general@postgresql.org
>Subject: Re: [GENERAL] win32: how to backup (dump does not work)
&g
On Tue, Feb 26, 2008 at 3:51 PM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> As discussed earlier I can't use dump/dumpall since my data needs
> persistent tableoids which, however, are not the same after a restore.
What about the workarounds / refactoring tips proposed in previous discussion
[EMAIL PROTECTED] wrote:
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, zipp
> 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 serv
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 restartin
