TODO - Revision history

Pengbo: /* Do not disturb sessions in failover of standby servers when load_balance_mode is off */

2025-02-27T11:47:03Z

Do not disturb sessions in failover of standby servers when load_balance_mode is off

← Older revision		Revision as of 11:47, 27 February 2025
Line 94:		Line 94:
	=== Do not disturb sessions in failover of standby servers when load_balance_mode is off ===		=== Do not disturb sessions in failover of standby servers when load_balance_mode is off ===
	: In streaming replication mode if load_balance_mode is off, it would be desirable to not disconnect sessions in failover of standby servers. Currently Pgpool-II connects to all backend even if load_balance_mode is off. But it is actually unnecessary to connect to standby servers if load_balance_mode is off. If pgpool only connects to primary server, it does not need to disconnect session in failover of standby servers.		: In streaming replication mode if load_balance_mode is off, it would be desirable to not disconnect sessions in failover of standby servers. Currently Pgpool-II connects to all backend even if load_balance_mode is off. But it is actually unnecessary to connect to standby servers if load_balance_mode is off. If pgpool only connects to primary server, it does not need to disconnect session in failover of standby servers.

			=== Pgpool-II leader node switchover===
			: Currently, we need to shutdown the leader pgpool services to change the leader. Also we dont have an option to change the leader to a desired node untill we shutdown the services. the leader node switch should we possible with simple command such as a PCP command, instead of requiring a service restart.

	== TODOs already done ==		== TODOs already done ==

Ishii: /* Pgpool-II TODO list */

2024-08-27T02:22:54Z

Pgpool-II TODO list

← Older revision		Revision as of 02:22, 27 August 2024
Line 23:		Line 23:
	: It would be nice if pgpool-II checks if the SELECT uses FOR UPDATE/FOR SHARE and if not, enable load balance (or only sends to the master node if load balance is disabled).		: It would be nice if pgpool-II checks if the SELECT uses FOR UPDATE/FOR SHARE and if not, enable load balance (or only sends to the master node if load balance is disabled).
	: Note that some applications including psql could use CURSOR for SELECT. For example, from PostgreSQL 8.2, if "\set FETCH_COUNT n" is executed, psql unconditionaly uses a curor named "_psql_cursor".		: Note that some applications including psql could use CURSOR for SELECT. For example, from PostgreSQL 8.2, if "\set FETCH_COUNT n" is executed, psql unconditionaly uses a curor named "_psql_cursor".

	~~=== Support IPv6 network ===~~
	~~: As of 4.5, it is allowed to use IPv6 address for PostgreSQL backend server, listening addresses of pgpool-II itself and listening addresses of pcp process.~~
	~~: However, watchdog process only listens to IPv4 and UNIX domain socket. Following modules need to be updated.~~
	* watchdog communication port (wd_port)
	** wd_create_recv_socket/wd_create_client_socket
	* heartbeat port (heartbeat_port)
	** wd_create_hb_recv_socket/wd_create_hb_send_socket

	=== Handle abnormal down of virtual IP interface when watchdog enabled ===		=== Handle abnormal down of virtual IP interface when watchdog enabled ===

Ishii: /* TODOs already done */

2024-08-27T02:22:21Z

TODOs already done

← Older revision		Revision as of 02:22, 27 August 2024
Line 104:		Line 104:

	== TODOs already done ==		== TODOs already done ==
			=== Support IPv6 network ===
			: As of 4.5, it is allowed to use IPv6 address for PostgreSQL backend server, listening addresses of pgpool-II itself and listening addresses of pcp process.
			: However, watchdog process only listens to IPv4 and UNIX domain socket. Following modules need to be updated.
			* watchdog communication port (wd_port)
			** wd_create_recv_socket/wd_create_client_socket
			* heartbeat port (heartbeat_port)
			** wd_create_hb_recv_socket/wd_create_hb_send_socket
			:
			: This has been implemented in 4.6.
	=== Support multiple pcp_socket_dir ===		=== Support multiple pcp_socket_dir ===
	: Pgpool-II has supported multiple unix_socket_directories in 4.4 release. I think pcp_socket_dir should also support multiple directories.		: Pgpool-II has supported multiple unix_socket_directories in 4.4 release. I think pcp_socket_dir should also support multiple directories.

Ishii: /* Pgpool-II TODO list */

2024-07-04T12:16:45Z

Pgpool-II TODO list

← Older revision		Revision as of 12:16, 4 July 2024
Line 102:		Line 102:
	=== Do not disturb sessions in failover of standby servers when load_balance_mode is off ===		=== Do not disturb sessions in failover of standby servers when load_balance_mode is off ===
	: In streaming replication mode if load_balance_mode is off, it would be desirable to not disconnect sessions in failover of standby servers. Currently Pgpool-II connects to all backend even if load_balance_mode is off. But it is actually unnecessary to connect to standby servers if load_balance_mode is off. If pgpool only connects to primary server, it does not need to disconnect session in failover of standby servers.		: In streaming replication mode if load_balance_mode is off, it would be desirable to not disconnect sessions in failover of standby servers. Currently Pgpool-II connects to all backend even if load_balance_mode is off. But it is actually unnecessary to connect to standby servers if load_balance_mode is off. If pgpool only connects to primary server, it does not need to disconnect session in failover of standby servers.

	~~=== Support multiple pcp_socket_dir ===~~
	~~: Pgpool-II has supported multiple unix_socket_directories in 4.4 release. I think pcp_socket_dir should also support multiple directories.~~

	== TODOs already done ==		== TODOs already done ==

Ishii: /* TODOs already done */

2024-07-04T12:16:07Z

TODOs already done

← Older revision		Revision as of 12:16, 4 July 2024
Line 107:		Line 107:

	== TODOs already done ==		== TODOs already done ==

			=== Support multiple pcp_socket_dir ===
			: Pgpool-II has supported multiple unix_socket_directories in 4.4 release. I think pcp_socket_dir should also support multiple directories.
			: This has been implemented in 4.5.

	=== Allow load balance for PREPARE/EXECUTE/DEALLOCATE ===		=== Allow load balance for PREPARE/EXECUTE/DEALLOCATE ===

Ishii: /* Pgpool-II TODO list */

2024-07-04T12:13:34Z

Pgpool-II TODO list

← Older revision		Revision as of 12:13, 4 July 2024
Line 105:		Line 105:
	=== Support multiple pcp_socket_dir ===		=== Support multiple pcp_socket_dir ===
	: Pgpool-II has supported multiple unix_socket_directories in 4.4 release. I think pcp_socket_dir should also support multiple directories.		: Pgpool-II has supported multiple unix_socket_directories in 4.4 release. I think pcp_socket_dir should also support multiple directories.

	~~=== Allow load balance for PREPARE/EXECUTE/DEALLOCATE ===~~
	~~: Pgpool-II does not load balance these queries even if it's processing read only SELECT.~~

	== TODOs already done ==		== TODOs already done ==

Ishii: /* TODOs already done */

2024-07-04T12:12:57Z

TODOs already done

← Older revision		Revision as of 12:12, 4 July 2024
Line 110:		Line 110:

	== TODOs already done ==		== TODOs already done ==

			=== Allow load balance for PREPARE/EXECUTE/DEALLOCATE ===
			: Pgpool-II does not load balance these queries even if it's processing read only SELECT.
			: This has been implemented in 4.5.

	=== Recognize multi statemnet queries ===		=== Recognize multi statemnet queries ===

Ishii: /* Support IPv6 network */

2024-07-04T06:01:29Z

Support IPv6 network

← Older revision		Revision as of 06:01, 4 July 2024
Line 26:		Line 26:
	=== Support IPv6 network ===		=== Support IPv6 network ===
	: As of 4.5, it is allowed to use IPv6 address for PostgreSQL backend server, listening addresses of pgpool-II itself and listening addresses of pcp process.		: As of 4.5, it is allowed to use IPv6 address for PostgreSQL backend server, listening addresses of pgpool-II itself and listening addresses of pcp process.
	: However, watchdog process only listens to IPv4 and UNIX domain socket.		: However, watchdog process only listens to IPv4 and UNIX domain socket. Following modules need to be updated.
	* watchdog communication port (wd_port)		* watchdog communication port (wd_port)
	** wd_create_recv_socket/wd_create_client_socket		** wd_create_recv_socket/wd_create_client_socket

Ishii: /* Support IPv6 network */

2024-07-04T05:55:13Z

Support IPv6 network

← Older revision		Revision as of 05:55, 4 July 2024
Line 27:		Line 27:
	: As of 4.5, it is allowed to use IPv6 address for PostgreSQL backend server, listening addresses of pgpool-II itself and listening addresses of pcp process.		: As of 4.5, it is allowed to use IPv6 address for PostgreSQL backend server, listening addresses of pgpool-II itself and listening addresses of pcp process.
	: However, watchdog process only listens to IPv4 and UNIX domain socket.		: However, watchdog process only listens to IPv4 and UNIX domain socket.
			* watchdog communication port (wd_port)
			** wd_create_recv_socket/wd_create_client_socket
			* heartbeat port (heartbeat_port)
			** wd_create_hb_recv_socket/wd_create_hb_send_socket

	=== Handle abnormal down of virtual IP interface when watchdog enabled ===		=== Handle abnormal down of virtual IP interface when watchdog enabled ===

Ishii: /* Support IPv6 network */

2024-07-04T03:55:02Z

Support IPv6 network

← Older revision		Revision as of 03:55, 4 July 2024
Line 25:		Line 25:

	=== Support IPv6 network ===		=== Support IPv6 network ===
	: As of 3.4, it is allowed to use IPv6 address for PostgreSQL backend server ~~and bind address~~ of pgpool-II itself.		: As of 4.5, it is allowed to use IPv6 address for PostgreSQL backend server, listening addresses of pgpool-II itself and listening addresses of pcp process.
	: However, watchdog process only ~~binds~~ to IPv4 and UNIX domain socket.		: However, watchdog process only listens to IPv4 and UNIX domain socket.

	=== Handle abnormal down of virtual IP interface when watchdog enabled ===		=== Handle abnormal down of virtual IP interface when watchdog enabled ===