Comments (2)
Hi @Pluggi! Thanks for reaching out.
By default, PGO leverages pgBackRest for the management of WAL archives (meaning pgBackRest ensures WAL is properly archived and available to the various replicas within the PostgresCluster - while also providing a ton of great features to ensure WAL is effectively and efficiently archived & available). So because of this, PGO simply sets use_slots
to false
by default.
That being said, PGO does allow this setting to be turned on. In fact, certain functionality provided by the HA system (Patroni) requires use_slots
to be enabled:
https://patroni.readthedocs.io/en/latest/dynamic_configuration.html#dynamic-configuration-settings
slots: define permanent replication slots.
...
Enabling permanent replication slots requires postgresql.use_slots to be set to true.
So use of the setting really depends on your use. And I'll note that if you are seeing any issues with WAL that has you reaching this setting, I would definitely be curious to hear any further details/specifics.
Hope this helps!
from postgres-operator.
Hello !
It's not clear to me what pgbackrest has to do with patroni using replication slots? I thought the writing of WAL files to disk was enabled using archive_mode
.
My use case is, we have two PGO clusters A and B. I want to replicate data from table T in cluster A to cluster B.
The most simple way to do that seemed to be to just use replication slots.
However, I think if I just deploy replication slots using pg_create_physical_replication_slot()
on the leader of cluster A and then a failover happens on cluster A, the replication slot will not be automatically recreated on the new leader? So I wanted to use Patroni for that.
from postgres-operator.
Related Issues (20)
- closed HOT 3
- Adding extension mysql_fdw to postgres-gis HOT 3
- How to limit or prevent the impact HOT 3
- pgbackrest backup fails with ERROR: [082]: WAL segment 000001B000000AF80000009B was not archived before the 60000ms timeout HOT 3
- Issue with the makefile HOT 1
- Default requests/limits for containers in PostgresCluster CR HOT 3
- Postgres Major Version Upgrade connection to server on socket "/pgdata/.s.PGSQL.50432" failed: FATAL: could not access file "zombodb.so": No such file or directory HOT 3
- UnableToCreateStanzas warning with wrong address for backup repo pod HOT 2
- Add the postgrescluster helm chart to the OCI developer registry HOT 1
- Pgadmin URL is not working post adding userInterface in the PGO CRD. HOT 1
- `no pg_hba.conf entry for host` when cluster is being connected to from another namespace
- Install Decoderbufs Extension
- Unable to disable TLS effectively
- new pgadmin 7.8 in namespace scoped mode gives error ERROR\tpgadmin:\t'pinged' HOT 5
- Configuration for multi-master write and replication HOT 2
- Is TLS Rotation Supported? HOT 3
- Replica data file corrupted after restoring database from pg dump file (on primary pod) HOT 1
- PGO/PGBackrest reports "ServiceError: TLS error [1:337260938] dh key too small" when backing up to S3-compatible object storage HOT 2
- Not All Postgrescluster Resources Deleted on Helm Uninstall HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from postgres-operator.