Re: [BUGS] BUG #14457: Using hyphens/dashes insynchronous_standby_names fails with "invalid value" - Mailing list pgsql-bugs

On 2016-12-09 04:18, Tom Lane wrote:
> daff@ptmx.at writes:
>> It seems that hyphens or dashes in the value of synchronous_standby_names
>> are not accepted.
>
> You would need to use double quotes, same as the rules for a SQL
> identifier.  Per the fine manual:
>
>     Each standby_name should have the form of a valid SQL identifier,
>     unless it is *. You can use double-quoting if necessary. But note
>     that standby_names are compared to standby application names
>     case-insensitively, whether double-quoted or not.

Thank you, I seem to have missed that note or was too dense to register
its relevance.

Now onto fixing the pgsql Pacemaker resource agent to properly quote
standby names when generating the values for the
synchronous_standby_names setting :)

Thanks again,

Andreas