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
