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 >>> On Wed, Dec 5, 2007 at 8:25 AM, in message <4756527B.6040609@xxxxxxxxxxxxxxx>, Paul Lambert <paul.lambert@xxxxxxxxxxxxxxx> wrote: > Christian Rengstl wrote: >> The archive_command is 'copy %p C:\\Archive\\DBArchive\\%f', >> nevertheless I changed it to your version, but without success. >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 5: don't forget to increase your free space map settings >> >> > > And what does pgsql show when you do a "show archive_command;" > > -- > Paul Lambert > Database Administrator > AutoLedgers - A Reynolds & Reynolds Company > > ---------------------------(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 It shows: "copy "%p" F:\TransaktionsLogArchiv\%f" -> I changed the directory to archive the files in to see if it would help, but it doesn't. ---------------------------(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