syntax error

From: Noor Mulla <noor(dot)mulla(at)teranet(dot)ca>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: syntax error
Date: 2017-11-02 16:54:49
Message-ID: BN6PR04MB11898193FB1119E7E12E5D45E05C0@BN6PR04MB1189.namprd04.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I am setting up PostgreSQL standby on windows for the first time on version 9.4.14:

Is the below syntax correct in the recovery.conf file

restore_command = 'copy "D:\\apps\postgres\\pg_archivelog\\%f" "%p"'

archive_cleanup_command = 'pg_archivecleanup "D:\\apps\postgres\pg_archivelog\\" %r'

And below command is correct in syntax in portgresql.conf file

archive_command = 'copy "%p" "D:\\apps\\postgres\\pg_archivelog\\%f"'

I am archiving to local server

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2017-11-02 16:59:56 Re: Logical decoding error
Previous Message nmmulla 2017-11-02 16:38:25 Hot Standby syntax error