Re: Get SQL dump from readonly FS - Mailing list pgsql-general

From Frank Wittig
Subject Re: Get SQL dump from readonly FS
Date
Msg-id 20070118114717.GA3202@weisshuhn.de
Whole thread Raw
In response to Get SQL dump from readonly FS  (Hannes Dorbath <light@theendofthetunnel.de>)
List pgsql-general
Hi Hannes,

what type of snapshot are you referring to?
If you use LVM2, you can create writeable snapshots. You simply have
to spend some free space of your volume group (as much as the
expeted amount of data to be written).
Writes to that snapshot are deleted along with deletion of the
snapshot.

Greetings,
Frank

Hannes Dorbath <light@theendofthetunnel.de> [18.01.2007 09:29]:
> Background is that I like to create a SQL dump from file system
> snapshot. I guess the answer is a plain "No." ;)

Attachment

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: [1/2 OFF] Varlena.com inaccessible from .br (Blocked?)
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Controlling memory of session