On 04/09/2015 12:32 PM, Volkan Unsal wrote:
Hi Adrian,I can confirm that the REP_USER is a role with replication attribute in the master Role name | Attributes | Member of -------------+------------------------------------------------+----------- postgres | Superuser, Create role, Create DB, Replication | {} replication | Replication +| {} | 4 connections | Also what file do you have primary_conninfo in? This setting is in ${PGDATA}/recovery.conf and looks like this: primary_conninfo = 'host=${MASTER_PORT_5432_TCP_ADDR} port=5432 user=${REP_USER} password=${REP_PASS}'
Best guess is something is not working properly in turning the ${} variables into actual values.
What happens if you do not use the variable notation and use the actual values in the above string?
Also what do the standby server logs show while you are trying to connect?
On Thu, Apr 9, 2015 at 3:16 PM, Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote: 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 <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://volkanunsal.com> <http://bit.ly/1h1ebjy> -- Adrian Klaver adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> -- *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
