Re: [GENERAL] Get SQL dump from readonly FS

2007-01-18 Thread Frank Wittig
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.

[GENERAL] Get SQL dump from readonly FS

2007-01-18 Thread Hannes Dorbath
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 ---(en