Postgres Pro
Downloads
Home   >   mailing lists

Re: replication connection and multi-command queries - Mailing list pgsql-novice

From David G. Johnston
Subject Re: replication connection and multi-command queries
Date
Msg-id CAKFQuwasupXG-4FNdge0wvDDxdJbH=kJia7Pi=6rZdgGMRyVmA@mail.gmail.com
Whole thread Raw
In response to replication connection and multi-command queries  (Greg Rychlewski <greg.rychlewski@gmail.com>)
Responses Re: replication connection and multi-command queries
List pgsql-novice
Tree view
On Sun, Jan 23, 2022 at 4:47 PM Greg Rychlewski <greg.rychlewski@gmail.com> wrote:
I have a situation where I've set up a replication connection and tried to issue a query with the simple protocol that has multiple commands "SELECT 1; SELECT 2;".

What do you mean by "I've set up a replication connection"?  IIUC they are not intended for interactive usage, they are intended for system-to-system data replication.  If you want to issue queries just connect with a "normal connection".

David J.

pgsql-novice by date:

Previous
From: Greg Rychlewski
Date:
Subject: replication connection and multi-command queries
Next
From: Greg Rychlewski
Date:
Subject: Re: replication connection and multi-command queries