Question : This question already has an answer here: RDS Postgres oldest replication lag increases during inactivity even though Fivetran […]
Problems restoring backup from base backup + WAL with WAL-E
Question : I’m trying to do nightly restores of the main database on a separate node. I want to do […]
Is there a way to view WAL updates on a Hot Standby server?
Question : We are trying to debug some of the problems we are having on our production database server. One […]
Expecting Postgresql WAL to shrink in size but it’s not
Question : We set our max_wal_size to 24 GB recently (from the 1 GB default), did some testing, and then […]
Is it possible to prevent data loss with Postgres WAL archiving?
Question : As I understand from the docs, a WAL segment is archived when the segment file reaches some size […]
Postgres replication not cleaning up WAL files
Question : I’m not that great with postgres but i was able to setup replication following this tutorial: https://www.howtoforge.com/tutorial/how-to-set-up-master-slave-replication-for-postgresql-96-on-ubuntu-1604/ It […]
Postgresql: Streaming Replication – determining wal sender process client port
Question : My experience with asynchronous streaming replication has been great so far, both as a HA solution and as […]
WAL files are not copied
Question : I’m using postgres 9.3 on Ubuntu 14.04 and I’m currently setting up a WAL backup. These are my […]
postgres: archive_command can’t write to an nfs share
Question : I’ve enabled the archive_mode with wal_level = hot_standby on a master server. I intended to send the wal […]
How should I configure my postgresql.conf file to backup the database once per hour?
Question : My goal is to back up the PostgreSQL 10 database on a Ubuntu 18.04 VPS once per hour. […]