I would try.. Read the server log
Try copying to another simpler path like C:\wal_archives Maybe blankspaces give problems Have you forgotten to configure any other parameter like max_wal_senders? I hope some of this hemos you Loles El jue., 29 oct. 2020 20:36, Atul Kumar <akumar14...@gmail.com> escribió: > hi, > > Still it is not getting copied in the archive directory > > show archive_command > "copy "%p" "C:\Program Files\PostgreSQL\10\archive_files\%f"" > > in postgresql.conf > archive_command = 'copy "%p" "C:\\Program > Files\\PostgreSQL\\10\\archive_files\\%f"' > > > and when I restarted the postgres service using command prompt I am > getting the below > alert in cmd > C:\Program Files\PostgreSQL\10\bin> 0 file(s) copied. > 0 file(s) copied. > 0 file(s) copied. > 0 file(s) copied. > 0 file(s) copied. > 0 file(s) copied. > 0 file(s) copied. > 0 file(s) copied. > 0 file(s) copied. > 0 file(s) copied. > 0 file(s) copied. > 0 file(s) copied. > 0 file(s) copied. > 0 file(s) copied. > > > > > Please help. > > > > Regards, > Atul > > > > > > > > > > > > > > > > On 10/30/20, Andreas Kretschmer <andr...@a-kretschmer.de> wrote: > > > > > > 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 > > > > > > > > > > >
