From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: archive command in streaming replication in windows server |
Date: | 2020-10-29 19:16:38 |
Message-ID: | 1ed53e80-fe86-a8a9-b093-2bab166b2abc@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Am 29.10.20 um 20:12 schrieb Atul Kumar:
> hi,
>
> I am trying to configure streaming replication on windows server.
>
> i have postgres version 10
>
> after successful installation of postgres, I create a archive
> directory "C:\Program Files\PostgreSQL\10\archive_files" and here in
> archive_flies, I need to copy the wal files.
>
> in postgresql conf file I gave path in archive_command like this:
>
> 'copy %p C:\Program Files\PostgreSQL\10\archive_files\%f'
>
> After successfully restarting the postgres service, I could not find
> any file in the archive directory.
>
> and when I am giving command
> show archive_command
>
> I get this as an output
>
> "copy %p C:Program FilesPostgreSQL archive_files%f"
>
> So please help in setting me the correct path format.
from the fine documentation an example:
archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f' # Unix
archive_command = 'copy "%p" "C:\\server\\archivedir\\%f"' # Windows
https://www.postgresql.org/docs/current/continuous-archiving.html
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
From | Date | Subject | |
---|---|---|---|
Next Message | Atul Kumar | 2020-10-29 19:36:42 | Re: archive command in streaming replication in windows server |
Previous Message | Atul Kumar | 2020-10-29 19:12:10 | archive command in streaming replication in windows server |