<div dir="ltr">Hi,<div><br></div><div>I have found this error in the postgresql log. I have looked over it on Google, but the only thing I have found, that the health_check_user should be set up.</div><div><br></div><div>My health_check parameters are:</div>
<div><div> /etc/pgpool2/pgpool.conf:health_check_period = 15</div><div> /etc/pgpool2/pgpool.conf:health_check_timeout = 5</div><div> /etc/pgpool2/pgpool.conf:health_check_user = 'postgres'</div><div> /etc/pgpool2/pgpool.conf:health_check_password = 'validpassword'</div>
<div> /etc/pgpool2/pgpool.conf:health_check_max_retries = 2</div><div> /etc/pgpool2/pgpool.conf:health_check_retry_delay = 1</div></div><div><br></div><div>I can check the database connection by hand:</div><div><br>
</div><div><div>root@swe-openfire-1:~# psql -h swe-postgres-1 -p 5433 -U postgres -W postgres -c "select 1"</div><div>Password for user postgres:</div><div> ?column?</div><div>----------</div><div> 1</div>
<div>(1 row)</div></div><div><br></div><div>All pool members generate the error several times after I add the backend to the pool:</div><div><br></div><div><div>2014-07-09 07:05:24 UTC:10.100.2.5(39907):nobody@postgres:[5969]: FATAL: role "nobody" does not exist</div>
<div>2014-07-09 07:05:24 UTC:10.100.2.4(48155):nobody@postgres:[5970]: FATAL: role "nobody" does not exist</div><div>2014-07-09 07:05:24 UTC:10.100.2.6(43736):nobody@postgres:[5971]: FATAL: role "nobody" does not exist</div>
<div>2014-07-09 07:05:24 UTC:10.100.2.10(41561):nobody@postgres:[5972]: FATAL: role "nobody" does not exist</div><div>2014-07-09 07:05:24 UTC:10.100.2.11(37456):nobody@postgres:[5973]: FATAL: role "nobody" does not exist</div>
<div>2014-07-09 07:05:25 UTC:10.100.2.5(39909):nobody@postgres:[5974]: FATAL: role "nobody" does not exist</div><div>2014-07-09 07:05:25 UTC:10.100.2.4(48157):nobody@postgres:[5975]: FATAL: role "nobody" does not exist</div>
<div>2014-07-09 07:05:25 UTC:10.100.2.6(43738):nobody@postgres:[5976]: FATAL: role "nobody" does not exist</div><div>2014-07-09 07:05:25 UTC:10.100.2.10(41563):nobody@postgres:[5977]: FATAL: role "nobody" does not exist</div>
<div>2014-07-09 07:05:25 UTC:10.100.2.11(37458):nobody@postgres:[5978]: FATAL: role "nobody" does not exist</div></div><div><br></div><div>Messages appeares only when I attach the node.</div><div><br></div><div>
And the other.... I can do online recovery by hand:</div><div><br></div><div><div>su postgres -c "/var/lib/pgsql/scripts/pgpool_remote_stop swe-postgres-2 /var/lib/postgresql/9.3/main/"</div><div>su postgres -c "/var/lib/pgsql/scripts/basebackup.sh swe-postgres-2 /var/lib/postgresql/9.3/main/"</div>
<div>su postgres -c "/var/lib/pgsql/scripts/pgpool_remote_start swe-postgres-2 /var/lib/postgresql/9.3/main/"</div></div><div><br></div><div>streaming replication starts fine, I can use the database in readonly mode, pgpool can loadbalance read queries after I attache the new node.</div>
<div><br></div><div>But when I try pcp to do the recovery, I got this messages:</div><div><br></div><div>pcp returns Backend Error, and in the log there are the following lines:</div><div><br></div><div><br></div><div><div>
Jul 9 07:02:35 swe-postgres-1 pgpool: 2014-07-09 07:02:35 LOG: pid 13221: starting recovering node 1</div><div>Jul 9 07:02:35 swe-postgres-1 pgpool: 2014-07-09 07:02:35 LOG: pid 13221: starting recovery command: "SELECT pgpool_recovery('/var/lib/pgsql/scripts/basebackup.sh', 'swe-postgres-2', '/var/lib/postgresql/9.3/main')"</div>
<div>Jul 9 07:02:35 swe-postgres-1 pgpool: 2014-07-09 07:02:35 ERROR: pid 13221: exec_recovery: /var/lib/pgsql/scripts/basebackup.sh command failed at 1st stage</div></div><div><br></div><div>my recovery setup is </div>
<div>
<div> /etc/pgpool2/pgpool.conf:recovery_user = 'postgres'</div><div> /etc/pgpool2/pgpool.conf:recovery_password = ''<br></div><div> /etc/pgpool2/pgpool.conf:recovery_1st_stage_command = '/var/lib/pgsql/scripts/basebackup.sh'</div>
<div> /etc/pgpool2/pgpool.conf:recovery_2nd_stage_command = ''</div><div> /etc/pgpool2/pgpool.conf:recovery_timeout = 90</div><div> /etc/pgpool2/pgpool.conf:client_idle_limit_in_recovery = 0</div><div> /etc/pgpool2/pgpool.conf: # of online recovery</div>
</div><div><br></div><div><br></div><div>Best regards,</div><div><br></div><div>Attila</div><div><br></div></div>