View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000642 | Pgpool-II | General | public | 2020-08-25 22:20 | 2020-08-27 20:21 |
| Reporter | Ken | Assigned To | pengbo | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 4.1.3 | ||||
| Summary | 0000642: Replication slot | ||||
| Description | Hello I notice that replication slot disappear after shutdown server. This is normal behavior? If yes that, where do i find parameter from this setting in configuration or script? I ask because when standby server will closed and later server up that I will must make whole backup which will last long time. | ||||
| Tags | No tags attached. | ||||
|
|
Are you using the failover.sh script included in RPM packages? In that script pgpool drops replication slot when standby goes down. https://www.pgpool.net/docs/latest/en/html/example-cluster.html https://git.postgresql.org/gitweb/?p=pgpool2.git;a=blob_plain;f=src/sample/scripts/failover.sh.sample;hb=refs/heads/V4_1_STABLE ================================== ## If Standby node is down, skip failover. if [ $FAILED_NODE_ID -ne $OLD_PRIMARY_NODE_ID ]; then logger -i -p local1.info failover.sh: Standby node is down. Skipping failover. ssh -T -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null postgres@$OLD_PRIMARY_NODE_HOST -i ~/.ssh/id_rsa_pgpool " ${PGHOME}/bin/psql -p $OLD_PRIMARY_NODE_PORT -c \"SELECT pg_drop_replication_slot('${FAILED_NODE_HOST}')\" " if [ $? -ne 0 ]; then logger -i -p local1.error failover.sh: drop replication slot "${FAILED_NODE_HOST}" failed exit 1 fi exit 0 fi ================================== |
|
|
thanks for you answer, information above explained all things. Topic is to closing. |
|
|
I am going to close this issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-08-25 22:20 | Ken | New Issue | |
| 2020-08-26 13:33 | pengbo | Note Added: 0003517 | |
| 2020-08-26 13:33 | pengbo | Assigned To | => pengbo |
| 2020-08-26 13:33 | pengbo | Status | new => feedback |
| 2020-08-27 16:30 | Ken | Note Added: 0003524 | |
| 2020-08-27 16:30 | Ken | Status | feedback => assigned |
| 2020-08-27 20:21 | pengbo | Note Added: 0003525 | |
| 2020-08-27 20:21 | pengbo | Status | assigned => closed |
