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.
--
"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
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
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