it seems as if in /pg_xlog/archive_status the respective file 0000000100000020000000D2.ready was not changed to 0000000100000020000000D2.done. Can this be done manually? About the persmission denied error i still have absolutely no clue! "Christian Rengstl" <Christian.Rengstl@xxxxxxxxxxxxxxxxxxxxxxxx> wrote on 08/02/06 9:27 am: > Hi everyone, > > can please somebody let me know what this error message is supposed to > mean: > ERROR: could not open relation 1663/16858/9469857: Permission denied > > Strange thing about it is that i do not have a relation with that name. > This somehow seems to go along with this other strange error message: > 2006-08-01 05:08:22 LOG: archived transaction log file > "0000000100000020000000D2" > 2006-08-01 05:11:47 LOG: archived transaction log file > "0000000100000020000000D3" > 2006-08-01 06:06:32 LOG: archive command "copy > pg_xlog\0000000100000020000000D2 > C:\Archiv\DBArchiv\0000000100000020000000D2" failed: return code 1 > 2006-08-01 06:06:33 LOG: archive command "copy > pg_xlog\0000000100000020000000D2 > C:\Archiv\DBArchiv\0000000100000020000000D2" failed: return code > 1 2006-08-01 06:06:34 LOG: archive command "copy > pg_xlog\0000000100000020000000D2 > C:\Archiv\DBArchiv\0000000100000020000000D2" failed: return code 1 > 2006-08-01 06:06:34 WARNING: transaction log file > "0000000100000020000000D2" could not be archived: too many failures > > Postgre copied the file 0000000100000020000000D2 to the specified > directory and now it says it can't be copied...I really, really don't > get it! > > -- > Christian Rengstl M.A. > Klinik und Poliklinik für Innere Medizin II > Kardiologie - Forschung > Universitätsklinikum Regensburg > B3 1.388 > Franz-Josef-Strauss-Allee 11 > 93053 Regensburg > Tel.: +49-941-944-7230 > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster -- Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230
