RDS Proxyを使用してAurora PostgreSQLのフェイルオーバーを実行する

#! /bin/bash

while true
do
  #truncate table record;
  #create table record(id serial,create_at timestamp);
  DATETIME=$(date -u "+%Y-%m-%d %T.%N")
  echo $DATETIME
  psql -q -h a-pgsql.cluster-xxxxx.ap-northeast-1.rds.amazonaws.com -d postgres -U postgres -c "insert into record(create_at) VALUES (current_timestamp)" &
  sleep 1
done

2020-08-29 11:44:27.964959626
2020-08-29 11:44:28.966971425
2020-08-29 11:44:29.968957489
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
psql: SSL SYSCALL error: EOF detected
SSL SYSCALL error: EOF detected
connection to server was lost
2020-08-29 11:44:30.971007776
psql: could not connect to server: Connection refused
	Is the server running on host "a-pgsql.cluster-xxxxxx.ap-northeast-1.rds.amazonaws.com" (10.0.3.43) and accepting
	TCP/IP connections on port 5432?
2020-08-29 11:44:31.972952018
2020-08-29 11:44:32.974997039
2020-08-29 11:44:33.977032145
psql: FATAL:  the database system is starting up
FATAL:  the database system is starting up
psql: FATAL:  the database system is starting up
FATAL:  the database system is starting up
psql: FATAL:  the database system is starting up
FATAL:  the database system is starting up
2020-08-29 11:44:34.979111133
ERROR:  cannot execute INSERT in a read-only transaction
2020-08-29 11:44:35.981149831
ERROR:  cannot execute INSERT in a read-only transaction
2020-08-29 11:44:36.983173817
ERROR:  cannot execute INSERT in a read-only transaction
2020-08-29 11:44:37.985163358
ERROR:  cannot execute INSERT in a read-only transaction
2020-08-29 11:44:38.987178155
ERROR:  cannot execute INSERT in a read-only transaction
2020-08-29 11:44:39.989168920
2020-08-29 11:44:40.991212531
2020-08-29 11:44:41.993185159
2020-08-29 11:44:42.995173285
2020-08-29 11:44:43.997177503
2020-08-29 11:44:44.999206797
2020-08-29 11:44:46.001261962
2020-08-29 11:44:47.003287661
2020-08-29 11:44:48.005291195

#! /bin/bash

while true
do
  #truncate table record;
  #create table record(id serial,create_at timestamp);
  DATETIME=$(date -u "+%Y-%m-%d %T.%N")
  echo $DATETIME
  psql -q -h proxy-aurora.proxy-xxxxx.ap-northeast-1.rds.amazonaws.com -d postgres -U postgres -c "insert into record(create_at) VALUES (current_timestamp)" &
  sleep 0.5
done

2020-08-29 12:04:30.095671574
2020-08-29 12:04:31.097629856
2020-08-29 12:04:32.099684736
2020-08-29 12:04:33.101745645
2020-08-29 12:04:34.103755036
2020-08-29 12:04:35.105731120
2020-08-29 12:04:36.107736230
2020-08-29 12:04:37.109709993
2020-08-29 12:04:38.111698832
2020-08-29 12:04:39.113675005
2020-08-29 12:04:40.115698907
2020-08-29 12:04:41.117673464
2020-08-29 12:04:42.119682149
2020-08-29 12:04:43.121650566
2020-08-29 12:04:44.123618407
2020-08-29 12:04:45.125820156
2020-08-29 12:04:46.127808056
2020-08-29 12:04:47.129771043
2020-08-29 12:04:48.131772090
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
SSL connection has been closed unexpectedly
connection to server was lost
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
SSL connection has been closed unexpectedly
connection to server was lost
2020-08-29 12:04:49.133763120
2020-08-29 12:04:50.135776827
2020-08-29 12:04:51.137775212
2020-08-29 12:04:52.139811209
2020-08-29 12:04:53.141852628
2020-08-29 12:04:54.143861363
2020-08-29 12:04:55.145887875
2020-08-29 12:04:56.147877446
2020-08-29 12:04:57.149851817
2020-08-29 12:04:58.151858291
2020-08-29 12:04:59.153685252
2020-08-29 12:05:00.155651975
2020-08-29 12:05:01.157824634
2020-08-29 12:05:02.159847039
2020-08-29 12:05:03.161849475
2020-08-29 12:05:04.163848675
2020-08-29 12:05:05.165860863
2020-08-29 12:05:06.167913253
2020-08-29 12:05:07.169922306
2020-08-29 12:05:08.171957895
2020-08-29 12:05:09.173986169
2020-08-29 12:05:10.175984477
2020-08-29 12:05:11.177993763
2020-08-29 12:05:12.180028575
2020-08-29 12:05:13.182031977
2020-08-29 12:05:14.184081473