Re: Strange error message

The thing is that the very same file was copied to the specified directory.

Martijn van Oosterhout <kleptog@svana.org> 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@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
>>
>>
>> ---------------------------(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@svana.org>
> 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