On 04/09/2015 12:05 PM, Volkan Unsal wrote:
HI Adrian,Can you connect remotely from the standby using psql? Yes, I can connect directly from the standby using psql and DB_USER and DB_PASS.
And you are sure the REP_USER is being correctly substituted in and that it has the REPLICATION attribute.
Have you tried the primary_conninfo with the values directly entered? http://www.postgresql.org/docs/9.4/interactive/sql-createrole.html postgres@test=# create role rep_user with login replication; CREATE ROLE postgres@test=# \du rep_user List of roles Role name | Attributes | Member of -----------+-------------+----------- rep_user | Replication | {} Also what file do you have primary_conninfo in?
-- *Volkan Unsal* /web and mobile development/ volkanunsal.com <http://bit.ly/1h1ebjy>
-- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
