summaryrefslogtreecommitdiff
path: root/src/sample/scripts
AgeCommit message (Collapse)Author
2025-09-10Fix safer directory deletion in Bash in recovery_1st_stage.sample.Taiki Koshino
Quote variables in rm commands to avoid accidental deletion: rm -rf "${DEST_NODE_PGDATA}" If the variable is empty, rm could delete unexpected files or directories.
2025-02-27Update sample script comment.Bo Peng
2025-02-26Remove pg_basebackup from the sample follow primary script.Bo Peng
If pg_rewind fails, the safest way for users is to recover manually.
2025-02-10Update sample scripts.Bo Peng
This commit includes: - update sample scripts to PostgreSQL 17 - remove archive settings to disable archive mode
2024-08-01Use "psql -V" instead of "initdb -V" in sample scripts.Bo Peng
Use "psql -V" instead of "initdb -V" in the sample scripts bacause in some cases postgresqlxx-server may not be installed.
2024-02-27Remove restore_command from sample scripts.Bo Peng
Restore_command is not required because replication slot is enabled. It causes occasional failover failure.
2023-11-17Modify the replication slot name conversion in sample scripts to add support ↵Bo Peng
for uppercase hostname. Patch in created by Sheikh Wasiu Al Hasib and modified by Be Peng.
2023-11-13Update PostgreSQL version to PostgreSQL 16 in sample scripts.Bo Peng
2023-11-13Doc: update English Configuration Example "8.2. Pgpool-II + Watchdog Setup ↵Bo Peng
Example" to Pgpool-II 4.5 and PostgreSQL 16. Several enhancements are also added.
2023-10-06Enhance error messages in escalation.sh.sample.Bo Peng
2023-10-06Add SSH timeout in escalation.sh.sample.Bo Peng
2023-05-30Fix the wrong variable names in replication_mode_recovery_2nd_stage.sample ↵Bo Peng
sample script.
2022-11-29Update PostgreSQL version of sample scriptsBo Peng
2022-11-07Improve follow_primary.sh.sample script:Bo Peng
- run checkpoint command on primary to update control file before running pg_rewind - check if a directory exists before removing it
2022-10-27Doc: Update documentation of AWS configuration example and add sample ↵Bo Peng
scripts used for AWS.
2022-07-01Add ssh options to restore_command in sample scripts.Bo Peng
Patch is created by Jon SCHEWE and updated by Bo Peng.
2022-06-05Remove spaces in sample scripts.Bo Peng
2022-06-05Allow to rewrite archive_command in sample scripts.Bo Peng
2022-06-05Update PSQL connection information in sample scripts.Bo Peng
2022-05-30Updated the sample scripts to allow ssh login user and ssh key file to be ↵Bo Peng
set using variables.
2022-02-25Fixed follow_primary.sh.sample script to check the status of PostgreSQL ↵Bo Peng
using pg_isready.
2022-02-07Fixed mistakes introduced in the previous commit.Bo Peng
2022-02-07Fixed sample failover script.Bo Peng
This script did not consider the case when the old primary node id is "-1".
2022-01-12Fix bug of pgpool_remote_start.sample.Bo Peng
2021-12-05Rename recovery_2nd_stage.sample to replication_mode_recovery_2nd_stage.sampleBo Peng
2021-12-05Doc: add new configuration example for replication mode and si mode.Bo Peng
2021-10-21Doc: update Japanese "Pgpool-II + Watchdog Setup Example" and sample scripts.Masaya Kawamoto
Updating Japanese document and script to Pgpool-II 4.3 and Postgresql 14. English document will updated later. Pgpool-II 4.3 yum repository url is blank and sample script link is set master branch because there are still not existed. We will update those when Pgpool-II 4.3 release.
2021-10-04Fix typos in documentation and sample scripts.Bo Peng
Patch is created by Kazufumi Noto.
2021-05-19Improve sample scripts.Bo Peng
2021-05-18Improve sample scripts.Bo Peng
Replcace dots or hyphens in replication slot name to underscore.
2021-04-05Improve sample scripts.Bo Peng
- Empty pg_replslot directory of the standby node after running pg_rewind, because pg_replslot directory may be copied from the primary node in old PostgreSQL versions. - While creating/dropping replication slot, access remote database using psql instead of uing ssh.
2021-02-17Update follow_primary.sh.sample due to the previous commit ↵Bo Peng
7bd103a6a33a2a675bd37f996ab46b7819a731d7.
2021-02-13Fix follow_primary.sh.sample to avoid removing recovery.conf.Bo Peng
2021-01-21Doc: fix indent.Bo Peng
2021-01-21Fix some variable names in follow_primary.sh.sample.Bo Peng
Fix some variable names of "main" to "primary" which should be used in streaming replication mode.
2020-10-27Doc: add escalation.sh sample script that is executed by wd_escalation_command.Bo Peng
Patch is created by Kawamoto Masaya.
2020-09-25Logging sample scripts to pgpool stdoutBo Peng
2020-09-22Doc: update "Pgpool-II + Watchdog Setup Example" and sample scripts.Bo Peng
2020-09-17Apply language cleanup mega patch.Tatsuo Ishii
black/white_function_list -> write_function_list, read_only_function_list black_query_pattern -> primay_routing_query_pattern black/white_memqcache_table_list -> cache_unsafe/cache_safe_table_list Watchdog: replace master to 'leader' for 'master' watchdog nodes ALWAYS_MASTER flag is changed to ALWAYS_PRIMARY. Replace relcache_query_target option 'master' to 'primary'. Replace Master Node with Main node ( node id with 0 or youngest live ). Replace follow_master with follow_primary with parameters. Replace some remaining occurrences of master with primary/main/leader Patch contributed by: Umar Hayat Reviewed by me:
2020-01-28Change the sample follow_master.sh scipt %M %H paramater's order.Bo Peng
2019-10-15Doc: add failover_command descriptionTakuma Hoshiai
Add more exaplain about a case that failover_command execute when it does not have a new master node. In this case, special characters in failover_command are specified fixed values. And update failover.sh.sample too.
2019-10-10Fix sample scripts typo.Bo Peng
2019-09-05Allow failover.sh, follow_master.sh, recovery_1st_stage, recovery_2nd_stage,Bo Peng
pgpool_remote_start scripts to be included in distributions.
2019-09-04Add various sample scripts:Bo Peng
- failover.sh - follow_master.sh - recovery_1st_stage - recovery_2nd_stage - pgpool_remote_start
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-31 15:48:31 +0000