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 with O_RDONLY. This was in md.c...in the mdopen > function. > > This did work....I was then able to open the database and do queries and > whatnot. Trying to insert into the table didn't give any errors...until I > tried to select the record back out, at which time it started giving me > errors such as: > > ERROR: cannot write block 7548 of pole: Permission denied > > At that point, it seems that your screwed...in that even if you shut down > postgres and restart it, somewhere it knows that that database has data that > needs to be written to disk, and it refuses to continue until it does so.
Isn't it the WAL who 'remembers' this info? -- Serguei A. Mokhov ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
