Also what file do you have primary_conninfo in?
primary_conninfo = 'host=${MASTER_PORT_5432_TCP_ADDR} port=5432 user=${REP_USER} password=${REP_PASS}'
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 Klaveradrian.klaver@aklaver.com
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.
-- *Volkan Unsal* /web and mobile development/volkanunsal.com <http://bit.ly/1h1ebjy>
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных