On 2020-06-29 14:58, Mai Peng wrote:
I restored the production database to staging environment, then dropped the publication on old database, dropped the subscription on the slave. I have to rename the old database in order to keep an old version of data. When I re-add the subscription logical replication, pointing to the new database, the slave still want to synchronize to the old database ( renamed) and the accumulated WAL files are crashing the filesystem. How can I handle the problem ?
You need to be more specific what exactly you are doing, including specific commands. For example, "pointing to" is not a specific enough technical term.
-- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services