Re: Proposal: Implement failover on libpq connect level. - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Proposal: Implement failover on libpq connect level.
Date
Msg-id 20150819.124245.1322750734243127189.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Proposal: Implement failover on libpq connect level.  (Victor Wagner <vitus@wagner.pp.ru>)
Responses Re: Proposal: Implement failover on libpq connect level.
List pgsql-hackers
I wonder how extended protocol is handled by this proposal. Suppose
load balacing mode is enabled. PQprepare is executed on standby1. Then
PQexecPrepared gets called. This may be executed on standby2, which
will fail because there's no prepared statement created by the former
PQprepare call.

Even simple procotol is used, same thing can be said to SQL
PREPARE/EXECUTE/DEALLOCATE.

SQL BEGIN/COMMIT/ROLLBACK would be more interesting example in load
balancing mode.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [DESIGN] ParallelAppend
Next
From: Paul A Jungwirth
Date:
Subject: Re: GiST support for UUIDs