Re: Get SQL dump from readonly FS

From: Frank Wittig <fw(at)weisshuhn(dot)de>
To: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Get SQL dump from readonly FS
Date: 2007-01-18 11:47:18
Message-ID: 20070118114717.GA3202@weisshuhn.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)theendofthetunnel(dot)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." ;)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-01-18 12:37:34 Re: Controlling memory of session
Previous Message Jorge Godoy 2007-01-18 11:29:02 Re: [1/2 OFF] Varlena.com inaccessible from .br (Blocked?)