PGPOOL Load Balancing: Create Sequence is going to replica
0
votes
1
answer
102
views
I created a pgpool instance which can connect to one master database(primary for write) and one read replica.
I have enabled below parameter:
disable_load_balance_on_write='dml_adaptive';
Now my below command fails when connect to pgpool :
create sequence if not exists public.xyz;
ERROR: cannot execute CREATE SEQUENCE in a read-only transaction
I am surprised "CREATE" statement is getting load balanced to replica. Anybody can throw some light here please?
Asked by Sajith P Shetty
(312 rep)
Aug 4, 2023, 11:37 AM
Last activity: Aug 4, 2023, 03:58 PM
Last activity: Aug 4, 2023, 03:58 PM