Continuing the discussion from PostgreSQL Replication: i need some help, i was doing a replication of my databases and the base backup completed successfully and restarting the replica. but when i run the query for checking the status of the replication its still blank instead of streaming. what’s stopping it from replicating now?
1 Like
(1) What PG version are you using?
(2) Share the file listing in the root folder of the data directory.
(3) What command, including arguments, did you use to create the replica?
1 Like
im using version 11
and i used this command sudo -u postgres pg_basebackup -h -p -U -D /data/pgsql/11/data -Fp -Xs -R
i used this tutorial, How To Set Up Physical Streaming Replication with PostgreSQL 12 on Ubuntu 20.04 | DigitalOcean
1 Like