gistfile1.txt

2020-11-12 08:02:16.150 UTC [21740] LOG:  abnormal database system shutdown
2020-11-12 08:02:16.175 UTC [21740] LOG:  database system is shut down
2020-11-12 08:02:20.219 UTC [6151] LOG:  starting PostgreSQL 13.0 (Ubuntu 13.0-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
2020-11-12 08:02:20.220 UTC [6151] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2020-11-12 08:02:20.223 UTC [6151] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2020-11-12 08:02:20.229 UTC [6152] LOG:  database system was interrupted; last known up at 2020-11-12 06:00:05 UTC
cp: cannot stat '/tmp/pg-restore-933946999/wal/00000005.history': No such file or directory
2020-11-12 08:02:20.424 UTC [6152] LOG:  starting archive recovery
cp: cannot stat '/tmp/pg-restore-933946999/wal/00000004.history': No such file or directory
2020-11-12 08:02:20.450 UTC [6152] LOG:  restored log file "0000000400000000000000C7" from archive
2020-11-12 08:02:20.590 UTC [6152] LOG:  redo starts at 0/C7000028
2020-11-12 08:02:20.592 UTC [6152] LOG:  consistent recovery state reached at 0/C7000138
2020-11-12 08:02:20.592 UTC [6151] LOG:  database system is ready to accept read only connections
cp: cannot stat '/tmp/pg-restore-933946999/wal/0000000400000000000000C8': No such file or directory
2020-11-12 08:02:20.597 UTC [6152] LOG:  redo done at 0/C7000138
2020-11-12 08:02:20.616 UTC [6152] LOG:  restored log file "0000000400000000000000C7" from archive
cp: cannot stat '/tmp/pg-restore-933946999/wal/00000005.history': No such file or directory
2020-11-12 08:02:20.658 UTC [6152] LOG:  selected new timeline ID: 5
2020-11-12 08:02:20.743 UTC [6152] LOG:  archive recovery complete
cp: cannot stat '/tmp/pg-restore-933946999/wal/00000004.history': No such file or directory
2020-11-12 08:02:20.813 UTC [6151] LOG:  database system is ready to accept connections
2020-11-12 10:36:27.434 UTC [6151] LOG:  received fast shutdown request
2020-11-12 10:36:27.440 UTC [6151] LOG:  aborting any active transactions
2020-11-12 10:36:27.443 UTC [6151] LOG:  background worker "logical replication launcher" (PID 6173) exited with exit code 1
2020-11-12 10:36:27.445 UTC [6159] LOG:  shutting down
2020-11-12 10:36:27.492 UTC [6151] LOG:  database system is shut down
2020-11-12 10:36:32.609 UTC [14274] LOG:  starting PostgreSQL 13.0 (Ubuntu 13.0-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
2020-11-12 10:36:32.609 UTC [14274] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2020-11-12 10:36:32.613 UTC [14274] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2020-11-12 10:36:32.620 UTC [14275] LOG:  database system was interrupted; last known up at 2020-11-12 06:00:05 UTC
2020-11-12 10:36:35.552 UTC [14275] LOG:  restored log file "00000005.history" from archive
cp: cannot stat '/tmp/pg-restore-360316285/wal/00000006.history': No such file or directory
cp: cannot stat '/tmp/pg-restore-360316285/base/00000006.history': No such file or directory
2020-11-12 10:36:35.557 UTC [14275] LOG:  starting archive recovery
2020-11-12 10:36:35.560 UTC [14275] LOG:  restored log file "00000005.history" from archive
2020-11-12 10:36:35.596 UTC [14275] LOG:  restored log file "0000000400000000000000C7" from archive
cp: cannot stat '/tmp/pg-restore-360316285/wal/00000004.history': No such file or directory
cp: cannot stat '/tmp/pg-restore-360316285/base/00000004.history': No such file or directory
2020-11-12 10:36:35.657 UTC [14275] LOG:  redo starts at 0/C7000028
2020-11-12 10:36:35.659 UTC [14275] LOG:  consistent recovery state reached at 0/C7000138
2020-11-12 10:36:35.659 UTC [14274] LOG:  database system is ready to accept read only connections
2020-11-12 10:36:35.685 UTC [14275] LOG:  restored log file "0000000500000000000000C8" from archive
cp: cannot stat '/tmp/pg-restore-360316285/wal/0000000500000000000000C9': No such file or directory
cp: cannot stat '/tmp/pg-restore-360316285/base/0000000500000000000000C9': No such file or directory
2020-11-12 10:36:35.850 UTC [14275] LOG:  invalid record length at 0/C90000A0: wanted 24, got 0
2020-11-12 10:36:35.850 UTC [14275] LOG:  redo done at 0/C9000028
cp: cannot stat '/tmp/pg-restore-360316285/wal/0000000500000000000000C9': No such file or directory
cp: cannot stat '/tmp/pg-restore-360316285/base/0000000500000000000000C9': No such file or directory
cp: cannot stat '/tmp/pg-restore-360316285/wal/00000006.history': No such file or directory
cp: cannot stat '/tmp/pg-restore-360316285/base/00000006.history': No such file or directory
2020-11-12 10:36:35.860 UTC [14275] LOG:  selected new timeline ID: 6
2020-11-12 10:36:35.919 UTC [14275] LOG:  archive recovery complete
2020-11-12 10:36:35.922 UTC [14275] LOG:  restored log file "00000005.history" from archive
2020-11-12 10:36:35.980 UTC [14274] LOG:  database system is ready to accept connections
2020-11-12 10:36:50.686 UTC [14305] PANIC:  could not create file "pg_wal/xlogtemp.14305": No such file or directory
2020-11-12 10:36:51.260 UTC [14274] LOG:  WAL writer process (PID 14305) was terminated by signal 6: Aborted
2020-11-12 10:36:51.260 UTC [14274] LOG:  terminating any other active server processes
2020-11-12 10:36:51.260 UTC [14292] LOG:  could not open temporary statistics file "pg_stat/global.tmp": No such file or directory
2020-11-12 10:36:51.260 UTC [14306] WARNING:  terminating connection because of crash of another server process
2020-11-12 10:36:51.260 UTC [14306] DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2020-11-12 10:36:51.260 UTC [14306] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-11-12 10:36:51.262 UTC [14274] LOG:  archiver process (PID 14307) exited with exit code 2
2020-11-12 10:36:51.262 UTC [14274] LOG:  all server processes terminated; reinitializing
2020-11-12 10:36:51.264 UTC [14274] PANIC:  could not open file "global/pg_control": No such file or directory