Re: [HACKERS] Accessing Database files on a "read-only" medium...like

2001-10-12 Thread Bruce Momjian
I wonder if you shut down the postmaster and restart if that would make it work again. I can't imagine where it would store table size information if the area is read-only. Adding data, full vacuum, restart postmaster should allow read-only databases. --

Re: [HACKERS] Accessing Database files on a "read-only" medium...like a CD.

2001-10-08 Thread Tom Lane
"Serguei Mokhov" <[EMAIL PROTECTED]> writes: > Kelly Harmon <[EMAIL PROTECTED]> wrote in message >9pr7f7$k0j$[EMAIL PROTECTED]">news:9pr7f7$k0j$[EMAIL PROTECTED]... >> At that point, it seems that your screwed...in that even if you shut down >> postgres and restart it, somewhere it knows that tha

Re: [HACKERS] Accessing Database files on a "read-only" medium...like a CD.

2001-10-07 Thread Serguei Mokhov
Kelly Harmon <[EMAIL PROTECTED]> wrote in message 9pr7f7$k0j$[EMAIL PROTECTED]">news:9pr7f7$k0j$[EMAIL PROTECTED]... > SO...I dug around through the code a little and found where the error was > coming from and changed the code so that if the open attempt with O_RDWR > fails, the code tries again

[HACKERS] Accessing Database files on a "read-only" medium...like a CD.

2001-10-07 Thread Kelly Harmon
I'm curious as to whether anybody has gotten PostgreSQL to work with a database that lives on some sort of read-only medium...like a CD. I've looked around in the newsgroups and I've seen a comment by Bruce Momjian that it can't currently be done...and I've seen a different comment by Tom Lane th