Does this look like a lot? Most of the work is actually optional, but we wanted to show how a specific user can be secured to operate the pglogical replication stream. This is necessary because whichever user we choose, it must currently be a superuser, and have access to the postgres replication stream to decode the logical instructions it contains.
Otherwise, this is no different from several other recipes in this chapter. In this case, we begin with the standard extract, make, and make install. We also added a common export for the PATH just in case, because the pglogical build needs some binaries that may otherwise be unavailable.
Next we change several configuration settings. The two lines in pg_hba.conf ensure that the ...
