archive command in streaming replication in windows server

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: archive command in streaming replication in windows server
Date: 2020-10-29 19:12:10
Message-ID: CA+ONtZ6O1ECKOPg5CNA1KO6i6Upmj2TgeiaePGqSHzDy-MUvbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2020-10-29 19:16:38 Re: archive command in streaming replication in windows server
Previous Message Ganesh Korde 2020-10-29 19:07:57 Re: psql asks for password despite configuring trust authentication