Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- postgres=# create database test;
- ERROR: source database "template1" is being accessed by other users
- DETAIL: There is 1 other session using the database.
- wd_lifecheck_dbname = 'template1'
- wd_lifecheck_user = 'nobody'
- wd_lifecheck_password = ''
- wd_lifecheck_dbname = 'template1'
- wd_lifecheck_user = 'postgres'
- wd_lifecheck_password = ''
- wd_lifecheck_dbname = 'postgres'
- wd_lifecheck_user = 'postgres'
- wd_lifecheck_password = ''
- Mar 18 21:10:17 node-a pgpool[16583]: 2019-03-18 21:10:17: pid 16642: LOG: forked new pcp worker, pid=8534 socket=7
- Mar 18 21:10:17 node-a pgpool[16583]: 2019-03-18 21:10:17: pid 8534: LOG: starting recovering node 1
- Mar 18 21:10:17 node-a pgpool[16583]: 2019-03-18 21:10:17: pid 8534: LOG: executing recovery
- Mar 18 21:10:17 node-a pgpool[16583]: 2019-03-18 21:10:17: pid 8534: DETAIL: starting recovery command: "SELECT pgpool_recovery('recovery_1st_stage', 'node-a-ip', '/data/test/data', '5438', 1)"
- Mar 18 21:10:17 node-a pgpool[16583]: 2019-03-18 21:10:17: pid 8534: LOG: executing recovery
- Mar 18 21:10:17 node-a pgpool[16583]: 2019-03-18 21:10:17: pid 8534: DETAIL: disabling statement_timeout
- Mar 18 21:10:18 node-a pgpool[16583]: 2019-03-18 21:10:18: pid 8534: LOG: node recovery, 1st stage is done
- Mar 18 21:11:37 node-a pgpool[16583]: 2019-03-18 21:11:37: pid 8534: LOG: checking if postmaster is started
- Mar 18 21:11:37 node-a pgpool[16583]: 2019-03-18 21:11:37: pid 8534: DETAIL: trying to connect to postmaster on hostname:node-b-ip database:postgres user:postgres (retry 0 times)
- ...
- ...2 more times
- Mar 18 21:11:49 node-a pgpool[16583]: 2019-03-18 21:11:49: pid 8534: LOG: checking if postmaster is started
- Mar 18 21:11:49 node-a pgpool[16583]: 2019-03-18 21:11:49: pid 8534: DETAIL: trying to connect to postmaster on hostname:node-a-ip database:template1 user:postgres (retry 0 times)
- ...it keeps on trying till i press ctrl+c on pcp command windows . I have seen it going upto 30 or more.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement