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@klinik.uni-regensburg.de> 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