Advertisement
Guest User

Untitled

a guest
Mar 19th, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.96 KB | None | 0 0
  1. postgres=# create database test;
  2. ERROR: source database "template1" is being accessed by other users
  3. DETAIL: There is 1 other session using the database.
  4.  
  5. wd_lifecheck_dbname = 'template1'
  6. wd_lifecheck_user = 'nobody'
  7. wd_lifecheck_password = ''
  8.  
  9. wd_lifecheck_dbname = 'template1'
  10. wd_lifecheck_user = 'postgres'
  11. wd_lifecheck_password = ''
  12.  
  13. wd_lifecheck_dbname = 'postgres'
  14. wd_lifecheck_user = 'postgres'
  15. wd_lifecheck_password = ''
  16.  
  17. 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
  18. Mar 18 21:10:17 node-a pgpool[16583]: 2019-03-18 21:10:17: pid 8534: LOG: starting recovering node 1
  19. Mar 18 21:10:17 node-a pgpool[16583]: 2019-03-18 21:10:17: pid 8534: LOG: executing recovery
  20. 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)"
  21. Mar 18 21:10:17 node-a pgpool[16583]: 2019-03-18 21:10:17: pid 8534: LOG: executing recovery
  22. Mar 18 21:10:17 node-a pgpool[16583]: 2019-03-18 21:10:17: pid 8534: DETAIL: disabling statement_timeout
  23. Mar 18 21:10:18 node-a pgpool[16583]: 2019-03-18 21:10:18: pid 8534: LOG: node recovery, 1st stage is done
  24. Mar 18 21:11:37 node-a pgpool[16583]: 2019-03-18 21:11:37: pid 8534: LOG: checking if postmaster is started
  25. 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)
  26. ...
  27. ...2 more times
  28. Mar 18 21:11:49 node-a pgpool[16583]: 2019-03-18 21:11:49: pid 8534: LOG: checking if postmaster is started
  29. 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)
  30. ...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