Search Postgresql Archives

Re: Archiving problem on Windows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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  2:47 AM, in message
<4756034B.8020208@xxxxxxxxxxxxxxx>,
Paul Lambert <paul.lambert@xxxxxxxxxxxxxxx> wrote: 
> Christian Rengstl wrote:
>> show config_file points to the right one. I restarted the server
after
>> every change. After including the quotation marks as in the docs,
the
>> quotation marks also appeared in the command, so at least it shows
that
>> the config file was read.
>> 
> 
> How about show archive_command;? Just to verify that it's reading in
the 
> right thing.
> 
> e.g.
> My postgresql.conf:
> archive_command = 'copy "%p" E:\\PostgreSQL\\WAL_Archive\\%f'
> 
>  From pgsql:
> postgres=# show archive_command;
>              archive_command
> ----------------------------------------
>   copy "%p" E:\PostgreSQL\WAL_Archive\%f
> 
> Cheers,
> Paul.
> 
> -- 
> Paul Lambert
> Database Administrator
> AutoLedgers - A Reynolds & Reynolds Company
> 
> 
> ---------------------------(end of
broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux