On Thu, Mar 01, 2018 at 01:35:54AM -0800, Andres Freund wrote: > On 2017-11-25 19:05:54 +0900, Michael Paquier wrote: >> A Boolean value of <literal>true</literal> tells the backend >> + to go into walsender mode, wherein a small set of replication >> commands >> + can be issued instead of SQL statements. > > This actually is wrong now I think. Petr?
On more or less HEAD: $ psql -X -d "replication=1 dbname=postgres" postgres=# create table aa (a int); ERROR: cannot execute SQL commands in WAL sender for physical replication $ psql -X -d "replication=database dbname=postgres" postgres=# create table aa (a int); CREATE TABLE So one needs to use replication=database in order to be able to issue normal SQL statements, while replication=true enforces physical replication where this cannot happen (no connection to a specified database). -- Michael
signature.asc
Description: PGP signature
