Comments on How to setup PostgreSQL Streaming Replication with Replication Slots on Debian 10
PostgreSQL is a powerful and feature-rich relational database management system (RDBMS). This tutorial shows you how to set up streaming replication with replication slots on two Debian 10 nodes.
3 Comment(s)
Comments
Step 5 is a mess. You tell us to start editing file 1 (postgresql.conf) and then immedietly create a file 2 (recovery.conf) and then everything after that is a gues son which file you're suggesting the parameters in. There's no organiziation or clarity. Please fix this to be more verbose!
Companion I am following the steps that you indicate but the replica is not working for me, I create the test database but I do not see it replicating in the slave node, I appreciate what you can help me with.
when created file recovery.conf on directory /var/lib/postgresql/11/main/recovery.conf, when type with user postgres psql -U postgres, show me error
psql: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
that is after created file recovery.conf, but delete file recovery.conf that the postgresql is running well.