Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Advice to configure pathman_ddl_trigger ENABLE ALWAYS on LR replica#106

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Merged
Merged
Changes fromall commits
Commits
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
19 changes: 19 additions & 0 deletionsREADME.md
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -251,6 +251,25 @@ drop_partitions(parent REGCLASS,
```
Drop partitions of the `parent` table (both foreign and local relations). If `delete_data` is `false`, the data is copied to the parent table first. Default is `false`.

To remove partitioned table along with all partitions fully, use conventional
`DROP TABLE relation CASCADE`. However, care should be taken in somewhat rare
case when you are running logical replication and `DROP` was executed by
replication apply worker, e.g. via trigger on replicated table. `pg_pathman`
uses `pathman_ddl_trigger` event trigger to remove the record about dropped
table from `pathman_config`, and this trigger by default won't fire on replica,
leading to inconsistent state when `pg_pathman` thinks that the table still
exists, but in fact it doesn't. If this is the case, configure this trigger to
fire on replica too:

```plpgsql
ALTER EVENT TRIGGER pathman_ddl_trigger ENABLE ALWAYS;
```

Physical replication doesn't have this problem since DDL as well as
`pathman_config` table is replicated too; master and slave PostgreSQL instances
are basically identical, and it is only harmful to keep this trigger in `ALWAYS`
mode.


### Additional parameters

Expand Down

[8]ページ先頭

©2009-2025 Movatter.jp