How to shorten a chain of logically replicated servers

Hi, I'm trying to figure out how to shorten a chain of logically replicating servers. Right now we have three servers replicating like so: A --> B --> C And I'd like to remove B from the chain of replication so that I only have: A --> C Of course, doing this without losing data is the goal. If

Re: How to reset a server error '25P02 in_failed_sql_transaction'

On 12/31/19 11:29 AM, David G. Johnston wrote: On Tuesday, December 31, 2019, Ron > wrote: But how do you issue a ROLLBACK to a different pid? You cannot.  At that point you need to start from scratch. pg_terminate_backend(/pid int/) And let the problemati

Re: How to reset a server error '25P02 in_failed_sql_transaction'

On Tuesday, December 31, 2019, Ron wrote: > > But how do you issue a ROLLBACK to a different pid? > You cannot. At that point you need to start from scratch. pg_terminate_backend(*pid int*) And let the problematic app deal with losing its database connection however it will. David J.

Re: How to reset a server error '25P02 in_failed_sql_transaction'

On 12/31/19 3:40 AM, Guillaume Lelarge wrote: Le mar. 31 déc. 2019 à 06:55, Matthias Apitz > a écrit : Hello, Due to a wrong human input in the GUI of our application our application server, from the point of view of the PostgreSQL server it is the Post

Re: Need auto fail over cluster solution for PostGres

If it's on Windows, does Windows Fail over cluster supports Postgres auto failover? I need a solution where secondary node becomes primary when primary fails and vice versa automatically without any manual intervention ( this is exactly how AAG works with SQL server on Windows) Regards, Girish

Re: Pg import access

On 12/31/19 4:41 AM, Sonam Sharma wrote: How to grant table import access in postgres ? Define import. -- Adrian Klaver adrian.kla...@aklaver.com

Pg import access

How to grant table import access in postgres ?

RE: How to reset a server error '25P02 in_failed_sql_transaction'

Hi, Which behavior are you looking for ? If you want the following statements to succeed, I guess that you don't want to be in a transaction context. In this case, you should have a look at the following link : https://www.postgresql.org/docs/11/ecpg-commands.html By default, the AUTOCOMMIT is O

Re: How to reset a server error '25P02 in_failed_sql_transaction'

Le mar. 31 déc. 2019 à 06:55, Matthias Apitz a écrit : > > Hello, > > Due to a wrong human input in the GUI of our application our > application server, from the point of view of the PostgreSQL server it > is the PostgreSQL client, issues a broken ESQL/C command to the PostgreSQL > server, here f