Thread: archive command in streaming replication in windows server

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.

My target is to configure streaming replication on same windows
machine using 2 differnet instances having different ports.(like
example master will be on 5432 and slave will be 5433).



Regards,
Atul

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

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 <andreas@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
>
>
>
>