Comments (2)
Hi Team,
Could you please help check? Thanks
from citus.
- Is pgBackRest supported in Citus backup please?
Backup tools including pgBackRest should work for individual Citus nodes. Note that each node needs to be handled as an independent Postgres instance. Those tools are not aware of Citus metadata/topology etc.
- Do we need to backup coordinator node and worker nodes separately? For example 1 coordinator node and 4 worker nodes, 5 separate backups?
Yes, the coordinator and worker nodes needs to be handled seperately as if they are seperate Postgres instances.
- Can we restore Citus all nodes to point in time (PITR) by the separate backup of each node(coordinator node and worker node)?
Yes, you can restore all the nodes to PITR, provided that you have the wal archives for all of them in addition to the backup.
One thing to be aware of during all this process is that, since the backup/restore is not Citus cluster aware, it is on you to make sure that the Citus metadata is correct after restore. For example, pg_dist_node should have the right node information.
from citus.
Related Issues (20)
- Having error while using checkout v4 action in check-sql-snapshots
- Debezium support HOT 2
- [Feature request] Worker nodes read only mode
- looks like Issue with MERGE Command. HOT 1
- [doc] wrong code comments for function PopUnassignedPlacementExecution HOT 1
- [Feature question] CDC support in Citus
- `alter_table_set_access_method` AccessExclusiveLock HOT 2
- ERROR: no binary output function available for type theta_sketch HOT 5
- Distributed transactions under a concurrency scenario HOT 2
- Assert when executing SELECT citus_set_coordinator_host('localhost');
- postgresql is crashing when selecting from citus columnar table HOT 2
- PG17Beta2 Support - Regression tests sanity
- Query on Best Practices for Handling High Bandwidth on the Coordinator in Large Citus Clusters
- Pg_basebackup error: COPY stream ended before last file was finished14 on Citus worker
- [Performance, Columnar] window function in subquery greatly slows down query, even when unreferenced
- limit null is implementation is broken when offset is used
- Test database is failing on release-12.1 + REL_16_STABLE
- FATAL: could not load server certificate file "server.crt": ee key too small HOT 3
- The citus cluster has collapsed HOT 9
- Flaky single_node_enterprise test
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 citus.