I'm following this doc https://www.postgresql.org/docs/current/pgupgrade.html to upgrade my cluster postgres an its replica, but when I run the rsync command, it duplicate the data folder, consuming all the disk space crashing the rsync. Here is the rsync command "rsync --archive --delete --hard-links --size-only --no-inc-recursive old_cluster new_cluster remote_dir". Any thoughts?
why rsync command to postgres upgrade replica are duplicating data folder size increasing disc space
265 Views Asked by argdenis At
1
There are 1 best solutions below
Related Questions in POSTGRESQL
- Only the first SQL script gets executed inside Docker Postgres container
- Compare fields in two tables
- Hibernate ClobJdbcType bindings: what are the diferences?
- Postgres && statement Error in Mybatis Mapper?
- Can this query be optimized? (Choosing a random row to insert, that excludes previously inserted Rows)
- Connection terminated unexpectedly while performing multi row insert using pg-promise
- Processing multiple forms in nodejs and postgresql
- How to copy data from SQLite to postgreSQL?
- PGAdmin4 configured behind a reverse proxy but unable to connect to Postgresql server
- Updates to pgsodium encrypted values don't use specified key_id
- Connecting to Postgres running in a Docker container using psql
- Can't connect to local postgresql server from my docker container
- Django Arrayfield migration to cloud sql (Postgresql) not creating the column
- Get list of matching keywords for each post
- docker-compose can't reset postgresql database
Related Questions in RSYNC
- Rsync fails with a network error when running via systemd as root
- How can creation times be preserved while copying on Mac?
- Rsync script to keep files at most recent state
- rsync omit times for symlinks
- How to exclude a specific directory from being copied by rsync?
- How to Append Large Files Efficiently Using Rsync
- duplicity and --rsync-options: exclude file is ignored
- Rsync -l flag is not working as expected for simlink
- Issues with rsync.synchronized in SaltStack Not Syncing Directory Content
- Run Laravel optimized and synched all the times
- Using Remote SSH in VS Code to develope while storing remote code live or timed automatically local?
- Rsync with multiple wildcards
- Lazarus + "rsync -a ... ..." copy is timing out. How to fix?
- Resuming rsync Causes Curious Network Traffic Flow
- Running rsync as root from bash script
Related Questions in PG-UPGRADE
- What to do if there are two tablespace directories after pg_upgrade using hard-links option
- 'System Catalog Modifications Disallowed' Error During PostgreSQL Upgrade
- Need some clarification on dropping database during pg_restore
- Postgres Segfault when trying to pg_upgrade
- "fe_sendauth: no password supplied" During pg_upgrade Process
- Issue with AWS Aurora DB PostgreSQL Database Upgrade using pg_upgrade v13 to v14 or 15v
- Upgrading PSQL from 15 to 16, can upgrade client but not server
- Upgrade a Postgres Database Using pg_ugrade Issues with pglogical
- pg_upgrade fails with errors upgrading from PostgreSQL 14 to 15
- pg_upgrade port 50432 failed: fe_sendauth: no password supplied
- why rsync command to postgres upgrade replica are duplicating data folder size increasing disc space
- Empty tables after pg_upgrade from v9.6 to v12
- What is the location for pg_upgrade_dump log file?
- How to pg_upgrade with an User-defined Data-Directory
- Error: Consult the last few lines of "pg_upgrade_dump_1.log"
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The problem was the alignment of directories, due to the difference between origin and destination it ended up getting lost and copying everything. well succeeded command: "rsync --exclude pg_wal --archive --delete --hard-links --size-only --no-inc-recursive /pgdata/homologacao/11 /pgdata/homologacao/14 hom-replica:/pgdata/homologacao"