Potential issue with alter system

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Potential issue with alter system
Date: 2017-05-04 18:44:30
Message-ID: e5cbacd6-527a-c350-ab42-7b24e82ff142@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Folks,

So I did this:

postgres=# alter system set archive_command to 'rsynv -av %p
postgres(at)52(dot)3(dot)141(dot)224:/data/archive/%f
';

Note the new line. It properly created in postgresql.auto.conf:

archive_command = 'rsynv -av %p postgres(at)52(dot)3(dot)141(dot)224:/data/archive/%f
'
(note the new line)

I noticed I spelled rsync wrong and now I get this:

postgres=# alter system set archive_command to 'rsync -av %p
postgres(at)52(dot)3(dot)141(dot)224:/data/archive/%f'
;
ERROR: could not parse contents of file "postgresql.auto.conf"

This is 9.5.2 (Yes, I know... I am in the process of setting up
replication to 9.5.6 for failover).

JD

--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nikita Glukhov 2017-05-04 18:46:09 Fix freeing of dangling IndexScanDesc.xs_hitup in GiST
Previous Message Tomas Vondra 2017-05-04 18:39:31 Re: CTE inlining