From: | "Christian Rengstl" <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Strange error message |
Date: | 2006-08-02 07:34:25 |
Message-ID: | 44D0719F.0AD0.0080.0@klinik.uni-regensburg.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-08-02 07:38:50 | Re: prepare, execute & oids |
Previous Message | Christian Rengstl | 2006-08-02 07:27:22 | Strange error message |