Get SQL dump from readonly FS
Started by Hannes Dorbathabout 19 years ago2 messagesgeneral
Is there any way for PostgreSQL to start up on a read only file system
for the sole purpose of creating a dump?
Background is that I like to create a SQL dump from file system
snapshot. I guess the answer is a plain "No." ;)
Thanks.
--
Regards,
Hannes Dorbath
Re: Get SQL dump from readonly FS
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]:
Show quoted text
Background is that I like to create a SQL dump from file system
snapshot. I guess the answer is a plain "No." ;)