API tools faq
paste
chowychowy

pg_upgrade_server.log

chowychowy
Feb 16th, 2022 (edited)
759
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SystemVerilog 4.43 KB | None | 0 0
raw download clone embed print report
  1.  
  2. ## THIS FIRST ONE IS DRY RUN ##
  3. -----------------------------------------------------------------
  4.   pg_upgrade run on Wed Feb 16 10:52:29 2022
  5. -----------------------------------------------------------------
  6.  
  7. command: "/usr/lib/postgresql/12/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/bnas/pgdata/postgresql/12/main" -o "-p 50432 -b -c config_file=/etc/postgresql/12/main/postgresql.conf -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/var/lib/postgresql'" start >> "pg_upgrade_server.log" 2>&1
  8. waiting for server to start....2022-02-16 18:52:29 +08 [302079]: [1-1] session=620cd76d.49bff,user=,db=,app=,client= | LOG:  pgaudit extension initialized
  9. 2022-02-16 18:52:29 +08 [302079]: [2-1] session=620cd76d.49bff,user=,db=,app=,client= | LOG:  starting PostgreSQL 12.10 (Ubuntu 12.10-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit
  10. 2022-02-16 18:52:29 +08 [302079]: [3-1] session=620cd76d.49bff,user=,db=,app=,client= | LOG:  listening on Unix socket "/var/lib/postgresql/.s.PGSQL.50432"
  11. .2022-02-16 18:52:30 +08 [302079]: [4-1] session=620cd76d.49bff,user=,db=,app=,client= | LOG:  redirecting log output to logging collector process
  12. 2022-02-16 18:52:30 +08 [302079]: [5-1] session=620cd76d.49bff,user=,db=,app=,client= | HINT:  Future log output will appear in directory "/bnas/log/postgresql/12".
  13.  done
  14. server started
  15.  
  16.  
  17. command: "/usr/lib/postgresql/12/bin/pg_ctl" -w -D "/bnas/pgdata/postgresql/12/main" -o "-c config_file=/etc/postgresql/12/main/postgresql.conf" -m smart stop >> "pg_upgrade_server.log" 2>&1
  18. waiting for server to shut down.... done
  19. server stopped
  20.  
  21.  
  22. command: "/usr/lib/postgresql/13/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/bnas/pgdata/postgresql/13/main" -o "-p 50432 -b -c synchronous_commit=off -c fsync=off -c full_page_writes=off -c vacuum_defer_cleanup_age=0 -c config_file=/etc/postgresql/13/main/postgresql.conf -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/var/lib/postgresql'" start >> "pg_upgrade_server.log" 2>&1
  23. waiting for server to start....2022-02-16 18:52:47 +08 [302215]: [1-1] session=620cd77f.49c87,user=,db=,app=,client= |LOG:  pgaudit extension initialized
  24. .2022-02-16 18:52:48 +08 [302215]: [2-1] session=620cd77f.49c87,user=,db=,app=,client= |LOG:  redirecting log output to logging collector process
  25. 2022-02-16 18:52:48 +08 [302215]: [3-1] session=620cd77f.49c87,user=,db=,app=,client= |HINT:  Future log output will appear in directory "/bnas/log/postgresql/13".
  26.  done
  27. server started
  28.  
  29.  
  30. command: "/usr/lib/postgresql/13/bin/pg_ctl" -w -D "/bnas/pgdata/postgresql/13/main" -o "-c config_file=/etc/postgresql/13/main/postgresql.conf" -m smart stop >> "pg_upgrade_server.log" 2>&1
  31. waiting for server to shut down.... done
  32. server stopped
  33.  
  34.  
  35. ## THIS SECOND ONE IS ACTUAL RUN ##
  36. -----------------------------------------------------------------
  37.   pg_upgrade run on Wed Feb 16 11:03:43 2022
  38. -----------------------------------------------------------------
  39.  
  40. command: "/usr/lib/postgresql/12/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/bnas/pgdata/postgresql/12/main" -o "-p 50432 -b -c config_file=/etc/postgresql/12/main/postgresql.conf -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/var/lib/postgresql'" start >> "pg_upgrade_server.log" 2>&1
  41. waiting for server to start....2022-02-16 19:03:43 +08 [303791]: [1-1] session=620cda0f.4a2af,user=,db=,app=,client= | LOG:  pgaudit extension initialized
  42. 2022-02-16 19:03:43 +08 [303791]: [2-1] session=620cda0f.4a2af,user=,db=,app=,client= | LOG:  starting PostgreSQL 12.10 (Ubuntu 12.10-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit
  43. 2022-02-16 19:03:43 +08 [303791]: [3-1] session=620cda0f.4a2af,user=,db=,app=,client= | LOG:  listening on Unix socket "/var/lib/postgresql/.s.PGSQL.50432"
  44. .2022-02-16 19:03:44 +08 [303791]: [4-1] session=620cda0f.4a2af,user=,db=,app=,client= | LOG:  redirecting log output to logging collector process
  45. 2022-02-16 19:03:44 +08 [303791]: [5-1] session=620cda0f.4a2af,user=,db=,app=,client= | HINT:  Future log output will appear in directory "/bnas/log/postgresql/12".
  46.  done
  47. server started
  48.  
  49.  
  50. command: "/usr/lib/postgresql/12/bin/pg_ctl" -w -D "/bnas/pgdata/postgresql/12/main" -o "-c config_file=/etc/postgresql/12/main/postgresql.conf" -m fast stop >> "pg_upgrade_server.log" 2>&1
  51. waiting for server to shut down.... done
  52. server stopped
  53.  
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!