The thing is that the very same file was copied to the specified directory. Martijn van Oosterhout <kleptog@xxxxxxxxx> wrote on 08/02/06 9:43 am: > On Wed, Aug 02, 2006 at 09:34:25AM +0200, Christian Rengstl wrote: >> 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! > > It's not done, so why should it be marked done? It says quite clearly > in the logs that it failed (error 1). > > As for the permission denied, that file has to exist, just look more > carefully. This is usually caused by broken anti-virus software, but it > could really be a permission problem... Don't forget that /'s are path > seperators too, so it's under the 1663 subdirectory. > > Hope this helps, > >> >> "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 >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 9: In versions below 8.0, the planner will ignore your desire to >> choose an index scan if your joining column's datatypes do not >> match > > -- > Martijn van Oosterhout <kleptog@xxxxxxxxx> > http://svana.org/kleptog/ >> From each according to his ability. To each according to his ability to litigate. -- 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
