search

ooni / sysadmin

System administration tools
https://ooni.org
59 stars 26 forks source link

psql: FATAL: database "metadb" does not exist #428

Closed lukaskawerau closed 4 years ago

lukaskawerau commented 4 years ago

After following the instructions here: https://github.com/ooni/sysadmin/blob/master/docs/metadb-sharing.md

I've successfully downloaded and extracted the data from the metadb on a local machine (Ubuntu 16.04). I've gone through the steps described and everything seems to work, but when I run

sudo -u postgres psql -U postgres metadb -c 'SELECT MAX(bucket_date) FROM autoclaved'

I get the error psql: FATAL: database "metadb" does not exist

Why could this be - what should I try to fix this? Any help much appreciated :)

hellais commented 4 years ago

Can you share the psql logs on this host?

The log file should be somewhere like: /var/log/postgresql/postgresql-9.6-main.log. It will probably have a line speaking about the authentication or access failure.

lukaskawerau commented 4 years ago

Sure, here's the full log:

Expand log

``` 2020-02-25 13:41:45 CET [24850-1] LOG: database system was shut down at 2020-02-25 13:41:44 CET 2020-02-25 13:41:45 CET [24850-2] LOG: MultiXact member wraparound protections are now enabled 2020-02-25 13:41:45 CET [24849-1] LOG: database system is ready to accept connections 2020-02-25 13:41:45 CET [24854-1] LOG: autovacuum launcher started 2020-02-25 13:41:45 CET [24856-1] [unknown]@[unknown] LOG: incomplete startup packet 2020-02-25 13:41:53 CET [24849-2] LOG: received fast shutdown request 2020-02-25 13:41:53 CET [24849-3] LOG: aborting any active transactions 2020-02-25 13:41:53 CET [24854-2] LOG: autovacuum launcher shutting down 2020-02-25 13:41:53 CET [24851-1] LOG: shutting down 2020-02-25 13:41:53 CET [24849-4] LOG: database system is shut down 2020-02-28 10:48:42 CET [6366-1] LOG: database system was interrupted; last known up at 2019-04-17 18:27:27 CEST 2020-02-28 10:48:42 CET [6366-2] LOG: creating missing WAL directory "pg_xlog/archive_status" 2020-02-28 10:48:42 CET [6367-1] [unknown]@[unknown] LOG: incomplete startup packet 2020-02-28 10:48:42 CET [6366-3] LOG: entering standby mode 2020-02-28 10:48:43 CET [6374-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 10:48:43 CET [6377-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 10:48:44 CET [6380-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 10:48:44 CET [6366-4] LOG: restored log file "000000010000037E00000012" from archive 2020-02-28 10:48:44 CET [6383-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 10:48:44 CET [6366-5] LOG: redo starts at 37E/12000028 2020-02-28 10:48:45 CET [6392-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 10:48:45 CET [6395-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 10:48:46 CET [6398-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 10:48:46 CET [6366-6] LOG: restored log file "000000010000037E00000013" from archive 2020-02-28 10:48:46 CET [6405-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 10:48:47 CET [6408-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 10:48:47 CET [6411-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 10:48:47 CET [6366-7] LOG: restored log file "000000010000037E00000014" from archive 2020-02-28 10:48:48 CET [6414-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 10:48:48 CET [6415-1] [unknown]@[unknown] LOG: incomplete startup packet 2020-02-28 10:48:49 CET [6366-8] LOG: restored log file "000000010000037E00000015" from archive 2020-02-28 10:48:51 CET [6366-9] LOG: restored log file "000000010000037E00000016" from archive 2020-02-28 10:48:52 CET [6366-10] LOG: restored log file "000000010000037E00000017" from archive 2020-02-28 10:48:54 CET [6366-11] LOG: restored log file "000000010000037E00000018" from archive 2020-02-28 10:48:55 CET [6366-12] LOG: restored log file "000000010000037E00000019" from archive 2020-02-28 10:48:57 CET [6366-13] LOG: restored log file "000000010000037E0000001A" from archive 2020-02-28 10:48:58 CET [6366-14] LOG: restored log file "000000010000037E0000001B" from archive 2020-02-28 10:49:00 CET [6366-15] LOG: restored log file "000000010000037E0000001C" from archive 2020-02-28 10:49:01 CET [6366-16] LOG: restored log file "000000010000037E0000001D" from archive 2020-02-28 10:49:03 CET [6366-17] LOG: restored log file "000000010000037E0000001E" from archive 2020-02-28 10:49:05 CET [6366-18] LOG: restored log file "000000010000037E0000001F" from archive 2020-02-28 10:49:06 CET [6366-19] LOG: restored log file "000000010000037E00000020" from archive 2020-02-28 10:49:08 CET [6366-20] LOG: restored log file "000000010000037E00000021" from archive 2020-02-28 10:49:10 CET [6366-21] LOG: restored log file "000000010000037E00000022" from archive 2020-02-28 10:49:12 CET [6366-22] LOG: restored log file "000000010000037E00000023" from archive 2020-02-28 10:49:13 CET [6366-23] LOG: restored log file "000000010000037E00000024" from archive 2020-02-28 10:49:15 CET [6366-24] LOG: restored log file "000000010000037E00000025" from archive 2020-02-28 10:49:16 CET [6366-25] LOG: restored log file "000000010000037E00000026" from archive 2020-02-28 10:49:18 CET [6366-26] LOG: restored log file "000000010000037E00000027" from archive 2020-02-28 10:49:20 CET [6366-27] LOG: restored log file "000000010000037E00000028" from archive 2020-02-28 10:49:22 CET [6366-28] LOG: restored log file "000000010000037E00000029" from archive 2020-02-28 10:49:24 CET [6366-29] LOG: restored log file "000000010000037E0000002A" from archive 2020-02-28 10:49:25 CET [6366-30] LOG: restored log file "000000010000037E0000002B" from archive 2020-02-28 10:49:27 CET [6366-31] LOG: restored log file "000000010000037E0000002C" from archive 2020-02-28 10:49:29 CET [6366-32] LOG: restored log file "000000010000037E0000002D" from archive 2020-02-28 10:49:30 CET [6366-33] LOG: restored log file "000000010000037E0000002E" from archive 2020-02-28 10:49:32 CET [6366-34] LOG: restored log file "000000010000037E0000002F" from archive 2020-02-28 10:49:33 CET [6366-35] LOG: restored log file "000000010000037E00000030" from archive 2020-02-28 10:49:35 CET [6366-36] LOG: restored log file "000000010000037E00000031" from archive 2020-02-28 10:49:37 CET [6366-37] LOG: restored log file "000000010000037E00000032" from archive 2020-02-28 10:49:39 CET [6366-38] LOG: restored log file "000000010000037E00000033" from archive 2020-02-28 10:49:40 CET [6366-39] LOG: restored log file "000000010000037E00000034" from archive 2020-02-28 10:49:42 CET [6366-40] LOG: restored log file "000000010000037E00000035" from archive 2020-02-28 10:49:43 CET [6366-41] LOG: restored log file "000000010000037E00000036" from archive 2020-02-28 10:49:45 CET [6366-42] LOG: restored log file "000000010000037E00000037" from archive 2020-02-28 10:49:47 CET [6366-43] LOG: restored log file "000000010000037E00000038" from archive 2020-02-28 10:49:48 CET [6366-44] LOG: restored log file "000000010000037E00000039" from archive 2020-02-28 10:49:50 CET [6366-45] LOG: restored log file "000000010000037E0000003A" from archive 2020-02-28 10:49:51 CET [6366-46] LOG: restored log file "000000010000037E0000003B" from archive 2020-02-28 10:49:53 CET [6366-47] LOG: restored log file "000000010000037E0000003C" from archive 2020-02-28 10:49:55 CET [6366-48] LOG: restored log file "000000010000037E0000003D" from archive 2020-02-28 10:49:57 CET [6366-49] LOG: restored log file "000000010000037E0000003E" from archive 2020-02-28 10:49:58 CET [6366-50] LOG: restored log file "000000010000037E0000003F" from archive 2020-02-28 10:50:00 CET [6366-51] LOG: restored log file "000000010000037E00000040" from archive 2020-02-28 10:50:01 CET [6366-52] LOG: restored log file "000000010000037E00000041" from archive 2020-02-28 10:50:03 CET [6366-53] LOG: restored log file "000000010000037E00000042" from archive 2020-02-28 10:50:05 CET [6366-54] LOG: restored log file "000000010000037E00000043" from archive 2020-02-28 10:50:06 CET [6366-55] LOG: restored log file "000000010000037E00000044" from archive 2020-02-28 10:50:08 CET [6366-56] LOG: restored log file "000000010000037E00000045" from archive 2020-02-28 10:50:09 CET [6366-57] LOG: restored log file "000000010000037E00000046" from archive 2020-02-28 10:50:11 CET [6366-58] LOG: restored log file "000000010000037E00000047" from archive 2020-02-28 10:50:13 CET [6366-59] LOG: restored log file "000000010000037E00000048" from archive 2020-02-28 10:50:15 CET [6366-60] LOG: restored log file "000000010000037E00000049" from archive 2020-02-28 10:50:16 CET [6366-61] LOG: restored log file "000000010000037E0000004A" from archive 2020-02-28 10:50:18 CET [6366-62] LOG: restored log file "000000010000037E0000004B" from archive 2020-02-28 10:50:19 CET [6366-63] LOG: restored log file "000000010000037E0000004C" from archive 2020-02-28 10:50:21 CET [6366-64] LOG: restored log file "000000010000037E0000004D" from archive 2020-02-28 10:50:23 CET [6366-65] LOG: restored log file "000000010000037E0000004E" from archive 2020-02-28 10:50:25 CET [6366-66] LOG: restored log file "000000010000037E0000004F" from archive 2020-02-28 10:50:26 CET [6366-67] LOG: restored log file "000000010000037E00000050" from archive 2020-02-28 10:50:28 CET [6366-68] LOG: restored log file "000000010000037E00000051" from archive 2020-02-28 10:50:29 CET [6366-69] LOG: restored log file "000000010000037E00000052" from archive 2020-02-28 10:50:31 CET [6366-70] LOG: restored log file "000000010000037E00000053" from archive 2020-02-28 10:50:32 CET [6366-71] LOG: restored log file "000000010000037E00000054" from archive 2020-02-28 10:50:34 CET [6366-72] LOG: restored log file "000000010000037E00000055" from archive 2020-02-28 10:50:35 CET [6366-73] LOG: restored log file "000000010000037E00000056" from archive 2020-02-28 10:50:37 CET [6366-74] LOG: restored log file "000000010000037E00000057" from archive 2020-02-28 10:50:39 CET [6366-75] LOG: restored log file "000000010000037E00000058" from archive 2020-02-28 10:50:40 CET [6366-76] LOG: restored log file "000000010000037E00000059" from archive 2020-02-28 10:50:42 CET [6366-77] LOG: restored log file "000000010000037E0000005A" from archive 2020-02-28 10:50:44 CET [6366-78] LOG: restored log file "000000010000037E0000005B" from archive 2020-02-28 10:50:45 CET [6366-79] LOG: restored log file "000000010000037E0000005C" from archive 2020-02-28 10:50:47 CET [6366-80] LOG: restored log file "000000010000037E0000005D" from archive 2020-02-28 10:50:48 CET [6366-81] LOG: restored log file "000000010000037E0000005E" from archive 2020-02-28 10:50:50 CET [6366-82] LOG: restored log file "000000010000037E0000005F" from archive 2020-02-28 10:50:52 CET [6366-83] LOG: restored log file "000000010000037E00000060" from archive 2020-02-28 10:50:53 CET [6366-84] LOG: restored log file "000000010000037E00000061" from archive 2020-02-28 10:50:55 CET [6366-85] LOG: restored log file "000000010000037E00000062" from archive 2020-02-28 10:50:57 CET [6366-86] LOG: restored log file "000000010000037E00000063" from archive 2020-02-28 10:50:59 CET [6366-87] LOG: restored log file "000000010000037E00000064" from archive 2020-02-28 10:51:00 CET [6366-88] LOG: restored log file "000000010000037E00000065" from archive 2020-02-28 10:51:02 CET [6366-89] LOG: restored log file "000000010000037E00000066" from archive 2020-02-28 10:51:04 CET [6366-90] LOG: restored log file "000000010000037E00000067" from archive 2020-02-28 10:51:05 CET [6366-91] LOG: restored log file "000000010000037E00000068" from archive 2020-02-28 10:51:07 CET [6366-92] LOG: restored log file "000000010000037E00000069" from archive 2020-02-28 10:51:09 CET [6366-93] LOG: restored log file "000000010000037E0000006A" from archive 2020-02-28 10:51:10 CET [6366-94] LOG: restored log file "000000010000037E0000006B" from archive 2020-02-28 10:51:12 CET [6366-95] LOG: restored log file "000000010000037E0000006C" from archive 2020-02-28 10:51:13 CET [6366-96] LOG: restored log file "000000010000037E0000006D" from archive 2020-02-28 10:51:15 CET [6366-97] LOG: restored log file "000000010000037E0000006E" from archive 2020-02-28 10:51:17 CET [6366-98] LOG: restored log file "000000010000037E0000006F" from archive 2020-02-28 10:51:18 CET [6366-99] LOG: restored log file "000000010000037E00000070" from archive 2020-02-28 10:51:20 CET [6366-100] LOG: restored log file "000000010000037E00000071" from archive 2020-02-28 10:51:22 CET [6366-101] LOG: restored log file "000000010000037E00000072" from archive 2020-02-28 10:51:24 CET [6366-102] LOG: restored log file "000000010000037E00000073" from archive 2020-02-28 10:51:25 CET [6366-103] LOG: restored log file "000000010000037E00000074" from archive 2020-02-28 10:51:27 CET [6366-104] LOG: restored log file "000000010000037E00000075" from archive 2020-02-28 10:51:28 CET [6366-105] LOG: restored log file "000000010000037E00000076" from archive 2020-02-28 10:51:30 CET [6366-106] LOG: restored log file "000000010000037E00000077" from archive 2020-02-28 10:51:31 CET [6366-107] LOG: restored log file "000000010000037E00000078" from archive 2020-02-28 10:51:33 CET [6366-108] LOG: restored log file "000000010000037E00000079" from archive 2020-02-28 10:51:35 CET [6366-109] LOG: restored log file "000000010000037E0000007A" from archive 2020-02-28 10:51:36 CET [6366-110] LOG: restored log file "000000010000037E0000007B" from archive 2020-02-28 10:51:38 CET [6366-111] LOG: restored log file "000000010000037E0000007C" from archive 2020-02-28 10:51:40 CET [6366-112] LOG: restored log file "000000010000037E0000007D" from archive 2020-02-28 10:51:42 CET [6366-113] LOG: restored log file "000000010000037E0000007E" from archive 2020-02-28 10:51:44 CET [6366-114] LOG: restored log file "000000010000037E0000007F" from archive 2020-02-28 10:51:46 CET [6366-115] LOG: restored log file "000000010000037E00000080" from archive 2020-02-28 10:51:48 CET [6366-116] LOG: restored log file "000000010000037E00000081" from archive 2020-02-28 10:51:49 CET [6366-117] LOG: restored log file "000000010000037E00000082" from archive 2020-02-28 10:51:51 CET [6366-118] LOG: restored log file "000000010000037E00000083" from archive 2020-02-28 10:51:53 CET [6366-119] LOG: restored log file "000000010000037E00000084" from archive 2020-02-28 10:51:54 CET [6366-120] LOG: restored log file "000000010000037E00000085" from archive 2020-02-28 10:51:56 CET [6366-121] LOG: restored log file "000000010000037E00000086" from archive 2020-02-28 10:51:57 CET [6366-122] LOG: restored log file "000000010000037E00000087" from archive 2020-02-28 10:51:59 CET [6366-123] LOG: restored log file "000000010000037E00000088" from archive 2020-02-28 10:52:01 CET [6366-124] LOG: restored log file "000000010000037E00000089" from archive 2020-02-28 10:52:02 CET [6366-125] LOG: restored log file "000000010000037E0000008A" from archive 2020-02-28 10:52:04 CET [6366-126] LOG: restored log file "000000010000037E0000008B" from archive 2020-02-28 10:52:06 CET [6366-127] LOG: restored log file "000000010000037E0000008C" from archive 2020-02-28 10:52:08 CET [6366-128] LOG: restored log file "000000010000037E0000008D" from archive 2020-02-28 10:52:09 CET [6366-129] LOG: restored log file "000000010000037E0000008E" from archive 2020-02-28 10:52:11 CET [6366-130] LOG: restored log file "000000010000037E0000008F" from archive 2020-02-28 10:52:12 CET [6366-131] LOG: restored log file "000000010000037E00000090" from archive 2020-02-28 10:52:14 CET [6366-132] LOG: restored log file "000000010000037E00000091" from archive 2020-02-28 10:52:16 CET [6366-133] LOG: restored log file "000000010000037E00000092" from archive 2020-02-28 10:52:17 CET [6366-134] LOG: restored log file "000000010000037E00000093" from archive 2020-02-28 10:52:19 CET [6366-135] LOG: restored log file "000000010000037E00000094" from archive 2020-02-28 10:52:21 CET [6366-136] LOG: restored log file "000000010000037E00000095" from archive 2020-02-28 10:52:22 CET [6366-137] LOG: restored log file "000000010000037E00000096" from archive 2020-02-28 10:52:24 CET [6366-138] LOG: restored log file "000000010000037E00000097" from archive 2020-02-28 10:52:26 CET [6366-139] LOG: restored log file "000000010000037E00000098" from archive 2020-02-28 10:52:27 CET [6366-140] LOG: restored log file "000000010000037E00000099" from archive 2020-02-28 10:52:29 CET [6366-141] LOG: restored log file "000000010000037E0000009A" from archive 2020-02-28 10:52:31 CET [6366-142] LOG: restored log file "000000010000037E0000009B" from archive 2020-02-28 10:52:32 CET [6366-143] LOG: restored log file "000000010000037E0000009C" from archive 2020-02-28 10:52:34 CET [6366-144] LOG: restored log file "000000010000037E0000009D" from archive 2020-02-28 10:52:36 CET [6366-145] LOG: restored log file "000000010000037E0000009E" from archive 2020-02-28 10:52:37 CET [6366-146] LOG: restored log file "000000010000037E0000009F" from archive 2020-02-28 10:52:39 CET [6366-147] LOG: restored log file "000000010000037E000000A0" from archive 2020-02-28 10:52:41 CET [6366-148] LOG: restored log file "000000010000037E000000A1" from archive 2020-02-28 10:52:42 CET [6366-149] LOG: restored log file "000000010000037E000000A2" from archive 2020-02-28 10:52:44 CET [6366-150] LOG: restored log file "000000010000037E000000A3" from archive 2020-02-28 10:52:46 CET [6366-151] LOG: restored log file "000000010000037E000000A4" from archive 2020-02-28 10:52:47 CET [6366-152] LOG: restored log file "000000010000037E000000A5" from archive 2020-02-28 10:52:49 CET [6366-153] LOG: restored log file "000000010000037E000000A6" from archive 2020-02-28 10:52:51 CET [6366-154] LOG: restored log file "000000010000037E000000A7" from archive 2020-02-28 10:52:52 CET [6366-155] LOG: restored log file "000000010000037E000000A8" from archive 2020-02-28 10:52:54 CET [6366-156] LOG: restored log file "000000010000037E000000A9" from archive 2020-02-28 10:52:55 CET [6366-157] LOG: restored log file "000000010000037E000000AA" from archive 2020-02-28 10:52:57 CET [6366-158] LOG: restored log file "000000010000037E000000AB" from archive 2020-02-28 10:52:59 CET [6366-159] LOG: restored log file "000000010000037E000000AC" from archive 2020-02-28 10:53:00 CET [6366-160] LOG: restored log file "000000010000037E000000AD" from archive 2020-02-28 10:53:02 CET [6366-161] LOG: restored log file "000000010000037E000000AE" from archive 2020-02-28 10:53:04 CET [6366-162] LOG: restored log file "000000010000037E000000AF" from archive 2020-02-28 10:53:05 CET [6366-163] LOG: restored log file "000000010000037E000000B0" from archive 2020-02-28 10:53:07 CET [6366-164] LOG: restored log file "000000010000037E000000B1" from archive 2020-02-28 10:53:09 CET [6366-165] LOG: restored log file "000000010000037E000000B2" from archive 2020-02-28 10:53:10 CET [6366-166] LOG: restored log file "000000010000037E000000B3" from archive 2020-02-28 10:53:12 CET [6366-167] LOG: restored log file "000000010000037E000000B4" from archive 2020-02-28 10:53:14 CET [6366-168] LOG: restored log file "000000010000037E000000B5" from archive 2020-02-28 10:53:15 CET [6366-169] LOG: restored log file "000000010000037E000000B6" from archive 2020-02-28 10:53:17 CET [6366-170] LOG: restored log file "000000010000037E000000B7" from archive 2020-02-28 10:53:18 CET [6366-171] LOG: restored log file "000000010000037E000000B8" from archive 2020-02-28 10:53:20 CET [6366-172] LOG: restored log file "000000010000037E000000B9" from archive 2020-02-28 10:53:22 CET [6366-173] LOG: restored log file "000000010000037E000000BA" from archive 2020-02-28 10:53:24 CET [6366-174] LOG: restored log file "000000010000037E000000BB" from archive 2020-02-28 10:53:26 CET [6366-175] LOG: restored log file "000000010000037E000000BC" from archive 2020-02-28 10:53:27 CET [6366-176] LOG: restored log file "000000010000037E000000BD" from archive 2020-02-28 10:53:29 CET [6366-177] LOG: restored log file "000000010000037E000000BE" from archive 2020-02-28 10:53:30 CET [6366-178] LOG: restored log file "000000010000037E000000BF" from archive 2020-02-28 10:53:32 CET [6366-179] LOG: restored log file "000000010000037E000000C0" from archive 2020-02-28 10:53:34 CET [6366-180] LOG: restored log file "000000010000037E000000C1" from archive 2020-02-28 10:53:35 CET [6366-181] LOG: restored log file "000000010000037E000000C2" from archive 2020-02-28 10:53:37 CET [6366-182] LOG: restored log file "000000010000037E000000C3" from archive 2020-02-28 10:53:38 CET [6366-183] LOG: restored log file "000000010000037E000000C4" from archive 2020-02-28 10:53:40 CET [6366-184] LOG: restored log file "000000010000037E000000C5" from archive 2020-02-28 10:53:41 CET [6366-185] LOG: restored log file "000000010000037E000000C6" from archive 2020-02-28 10:53:43 CET [6366-186] LOG: restored log file "000000010000037E000000C7" from archive 2020-02-28 10:53:44 CET [6366-187] LOG: restored log file "000000010000037E000000C8" from archive 2020-02-28 10:53:46 CET [6366-188] LOG: restored log file "000000010000037E000000C9" from archive 2020-02-28 10:53:48 CET [6366-189] LOG: restored log file "000000010000037E000000CA" from archive 2020-02-28 10:53:49 CET [6366-190] LOG: restored log file "000000010000037E000000CB" from archive 2020-02-28 10:53:51 CET [6366-191] LOG: restored log file "000000010000037E000000CC" from archive 2020-02-28 10:53:52 CET [6366-192] LOG: restored log file "000000010000037E000000CD" from archive 2020-02-28 10:53:54 CET [6366-193] LOG: restored log file "000000010000037E000000CE" from archive 2020-02-28 10:53:56 CET [6366-194] LOG: restored log file "000000010000037E000000CF" from archive 2020-02-28 10:53:58 CET [6366-195] LOG: restored log file "000000010000037E000000D0" from archive 2020-02-28 10:54:00 CET [6366-196] LOG: restored log file "000000010000037E000000D1" from archive 2020-02-28 10:54:01 CET [6366-197] LOG: restored log file "000000010000037E000000D2" from archive 2020-02-28 10:54:03 CET [6366-198] LOG: restored log file "000000010000037E000000D3" from archive 2020-02-28 10:54:05 CET [6366-199] LOG: restored log file "000000010000037E000000D4" from archive 2020-02-28 10:54:06 CET [6366-200] LOG: restored log file "000000010000037E000000D5" from archive 2020-02-28 10:54:08 CET [6366-201] LOG: restored log file "000000010000037E000000D6" from archive 2020-02-28 10:54:09 CET [6366-202] LOG: restored log file "000000010000037E000000D7" from archive 2020-02-28 10:54:11 CET [6366-203] LOG: restored log file "000000010000037E000000D8" from archive 2020-02-28 10:54:13 CET [6366-204] LOG: restored log file "000000010000037E000000D9" from archive 2020-02-28 10:54:14 CET [6366-205] LOG: restored log file "000000010000037E000000DA" from archive 2020-02-28 10:54:16 CET [6366-206] LOG: restored log file "000000010000037E000000DB" from archive 2020-02-28 10:54:17 CET [6366-207] LOG: restored log file "000000010000037E000000DC" from archive 2020-02-28 10:54:19 CET [6366-208] LOG: restored log file "000000010000037E000000DD" from archive 2020-02-28 10:54:21 CET [6366-209] LOG: restored log file "000000010000037E000000DE" from archive 2020-02-28 10:54:23 CET [6366-210] LOG: restored log file "000000010000037E000000DF" from archive 2020-02-28 10:54:24 CET [6366-211] LOG: restored log file "000000010000037E000000E0" from archive 2020-02-28 10:54:26 CET [6366-212] LOG: restored log file "000000010000037E000000E1" from archive 2020-02-28 10:54:28 CET [6366-213] LOG: restored log file "000000010000037E000000E2" from archive 2020-02-28 10:54:29 CET [6366-214] LOG: restored log file "000000010000037E000000E3" from archive 2020-02-28 10:54:31 CET [6366-215] LOG: restored log file "000000010000037E000000E4" from archive 2020-02-28 10:54:33 CET [6366-216] LOG: restored log file "000000010000037E000000E5" from archive 2020-02-28 10:54:34 CET [6366-217] LOG: restored log file "000000010000037E000000E6" from archive 2020-02-28 10:54:36 CET [6366-218] LOG: restored log file "000000010000037E000000E7" from archive 2020-02-28 10:54:38 CET [6366-219] LOG: restored log file "000000010000037E000000E8" from archive 2020-02-28 10:54:39 CET [6366-220] LOG: restored log file "000000010000037E000000E9" from archive 2020-02-28 10:54:41 CET [6366-221] LOG: restored log file "000000010000037E000000EA" from archive 2020-02-28 10:54:42 CET [6366-222] LOG: restored log file "000000010000037E000000EB" from archive 2020-02-28 10:54:44 CET [6366-223] LOG: restored log file "000000010000037E000000EC" from archive 2020-02-28 10:54:46 CET [6366-224] LOG: restored log file "000000010000037E000000ED" from archive 2020-02-28 10:54:47 CET [6366-225] LOG: restored log file "000000010000037E000000EE" from archive 2020-02-28 10:54:49 CET [6366-226] LOG: restored log file "000000010000037E000000EF" from archive 2020-02-28 10:54:51 CET [6366-227] LOG: restored log file "000000010000037E000000F0" from archive 2020-02-28 10:54:52 CET [6366-228] LOG: restored log file "000000010000037E000000F1" from archive 2020-02-28 10:54:54 CET [6366-229] LOG: restored log file "000000010000037E000000F2" from archive 2020-02-28 10:54:56 CET [6366-230] LOG: restored log file "000000010000037E000000F3" from archive 2020-02-28 10:54:59 CET [6366-231] LOG: restored log file "000000010000037E000000F4" from archive 2020-02-28 10:55:00 CET [6366-232] LOG: restored log file "000000010000037E000000F5" from archive 2020-02-28 10:55:02 CET [6366-233] LOG: restored log file "000000010000037E000000F6" from archive 2020-02-28 10:55:04 CET [6366-234] LOG: restored log file "000000010000037E000000F7" from archive 2020-02-28 10:55:06 CET [6366-235] LOG: restored log file "000000010000037E000000F8" from archive 2020-02-28 10:55:07 CET [6366-236] LOG: restored log file "000000010000037E000000F9" from archive 2020-02-28 10:55:09 CET [6366-237] LOG: restored log file "000000010000037E000000FA" from archive 2020-02-28 10:55:11 CET [6366-238] LOG: restored log file "000000010000037E000000FB" from archive 2020-02-28 10:55:12 CET [6366-239] LOG: restored log file "000000010000037E000000FC" from archive 2020-02-28 10:55:14 CET [6366-240] LOG: restored log file "000000010000037E000000FD" from archive 2020-02-28 10:55:15 CET [6366-241] LOG: restored log file "000000010000037E000000FE" from archive 2020-02-28 10:55:17 CET [6366-242] LOG: restored log file "000000010000037E000000FF" from archive 2020-02-28 10:55:18 CET [6366-243] LOG: restored log file "000000010000037F00000000" from archive 2020-02-28 10:55:20 CET [6366-244] LOG: restored log file "000000010000037F00000001" from archive 2020-02-28 10:55:22 CET [6366-245] LOG: restored log file "000000010000037F00000002" from archive 2020-02-28 10:55:23 CET [6366-246] LOG: restored log file "000000010000037F00000003" from archive 2020-02-28 10:55:25 CET [6366-247] LOG: restored log file "000000010000037F00000004" from archive 2020-02-28 10:55:26 CET [6366-248] LOG: restored log file "000000010000037F00000005" from archive 2020-02-28 10:55:28 CET [6366-249] LOG: restored log file "000000010000037F00000006" from archive 2020-02-28 10:55:30 CET [6366-250] LOG: restored log file "000000010000037F00000007" from archive 2020-02-28 10:55:31 CET [6366-251] LOG: restored log file "000000010000037F00000008" from archive 2020-02-28 10:55:33 CET [6366-252] LOG: restored log file "000000010000037F00000009" from archive 2020-02-28 10:55:35 CET [6366-253] LOG: restored log file "000000010000037F0000000A" from archive 2020-02-28 10:55:36 CET [6366-254] LOG: restored log file "000000010000037F0000000B" from archive 2020-02-28 10:55:38 CET [6366-255] LOG: restored log file "000000010000037F0000000C" from archive 2020-02-28 10:55:39 CET [6366-256] LOG: restored log file "000000010000037F0000000D" from archive 2020-02-28 10:55:41 CET [6366-257] LOG: restored log file "000000010000037F0000000E" from archive 2020-02-28 10:55:43 CET [6366-258] LOG: restored log file "000000010000037F0000000F" from archive 2020-02-28 10:55:45 CET [6366-259] LOG: restored log file "000000010000037F00000010" from archive 2020-02-28 10:55:46 CET [6366-260] LOG: restored log file "000000010000037F00000011" from archive 2020-02-28 10:55:48 CET [6366-261] LOG: restored log file "000000010000037F00000012" from archive 2020-02-28 10:55:49 CET [6366-262] LOG: restored log file "000000010000037F00000013" from archive 2020-02-28 10:55:51 CET [6366-263] LOG: restored log file "000000010000037F00000014" from archive 2020-02-28 10:55:53 CET [6366-264] LOG: restored log file "000000010000037F00000015" from archive 2020-02-28 10:55:54 CET [6366-265] LOG: restored log file "000000010000037F00000016" from archive 2020-02-28 10:55:56 CET [6366-266] LOG: restored log file "000000010000037F00000017" from archive 2020-02-28 10:55:58 CET [6366-267] LOG: restored log file "000000010000037F00000018" from archive 2020-02-28 10:55:59 CET [6366-268] LOG: restored log file "000000010000037F00000019" from archive 2020-02-28 10:56:01 CET [6366-269] LOG: restored log file "000000010000037F0000001A" from archive 2020-02-28 10:56:03 CET [6366-270] LOG: restored log file "000000010000037F0000001B" from archive 2020-02-28 10:56:04 CET [6366-271] LOG: restored log file "000000010000037F0000001C" from archive 2020-02-28 10:56:06 CET [6366-272] LOG: restored log file "000000010000037F0000001D" from archive 2020-02-28 10:56:07 CET [6366-273] LOG: restored log file "000000010000037F0000001E" from archive 2020-02-28 10:56:09 CET [6366-274] LOG: restored log file "000000010000037F0000001F" from archive 2020-02-28 10:56:11 CET [6366-275] LOG: restored log file "000000010000037F00000020" from archive 2020-02-28 10:56:13 CET [6366-276] LOG: restored log file "000000010000037F00000021" from archive 2020-02-28 10:56:14 CET [6366-277] LOG: restored log file "000000010000037F00000022" from archive 2020-02-28 10:56:16 CET [6366-278] LOG: restored log file "000000010000037F00000023" from archive 2020-02-28 10:56:17 CET [6366-279] LOG: restored log file "000000010000037F00000024" from archive 2020-02-28 10:56:19 CET [6366-280] LOG: restored log file "000000010000037F00000025" from archive 2020-02-28 10:56:20 CET [6366-281] LOG: restored log file "000000010000037F00000026" from archive 2020-02-28 10:56:22 CET [6366-282] LOG: restored log file "000000010000037F00000027" from archive 2020-02-28 10:56:24 CET [6366-283] LOG: restored log file "000000010000037F00000028" from archive 2020-02-28 10:56:25 CET [6366-284] LOG: restored log file "000000010000037F00000029" from archive 2020-02-28 10:56:27 CET [6366-285] LOG: restored log file "000000010000037F0000002A" from archive 2020-02-28 10:56:29 CET [6366-286] LOG: restored log file "000000010000037F0000002B" from archive 2020-02-28 10:56:30 CET [6366-287] LOG: restored log file "000000010000037F0000002C" from archive 2020-02-28 10:56:32 CET [6366-288] LOG: restored log file "000000010000037F0000002D" from archive 2020-02-28 10:56:34 CET [6366-289] LOG: restored log file "000000010000037F0000002E" from archive 2020-02-28 10:56:35 CET [6366-290] LOG: restored log file "000000010000037F0000002F" from archive 2020-02-28 10:56:37 CET [6366-291] LOG: restored log file "000000010000037F00000030" from archive 2020-02-28 10:56:38 CET [6366-292] LOG: restored log file "000000010000037F00000031" from archive 2020-02-28 10:56:39 CET [6366-293] LOG: consistent recovery state reached at 37F/3115BAB8 2020-02-28 10:56:41 CET [6366-294] LOG: restored log file "000000010000037F00000032" from archive 2020-02-28 10:56:44 CET [6366-295] LOG: restored log file "000000010000037F00000033" from archive 2020-02-28 10:56:46 CET [6366-296] LOG: restored log file "000000010000037F00000034" from archive 2020-02-28 10:56:48 CET [6366-297] LOG: restored log file "000000010000037F00000035" from archive 2020-02-28 10:56:50 CET [6366-298] LOG: restored log file "000000010000037F00000036" from archive 2020-02-28 10:56:52 CET [6366-299] LOG: restored log file "000000010000037F00000037" from archive 2020-02-28 10:56:54 CET [6366-300] LOG: restored log file "000000010000037F00000038" from archive 2020-02-28 10:56:56 CET [6366-301] LOG: restored log file "000000010000037F00000039" from archive 2020-02-28 10:56:58 CET [6366-302] LOG: restored log file "000000010000037F0000003A" from archive 2020-02-28 10:57:00 CET [6366-303] LOG: restored log file "000000010000037F0000003B" from archive 2020-02-28 10:57:03 CET [6366-304] LOG: restored log file "000000010000037F0000003C" from archive 2020-02-28 10:57:05 CET [6366-305] LOG: restored log file "000000010000037F0000003D" from archive 2020-02-28 10:57:08 CET [6366-306] LOG: restored log file "000000010000037F0000003E" from archive 2020-02-28 10:57:11 CET [6366-307] LOG: restored log file "000000010000037F0000003F" from archive 2020-02-28 10:57:13 CET [6366-308] LOG: restored log file "000000010000037F00000040" from archive 2020-02-28 10:57:15 CET [6366-309] LOG: restored log file "000000010000037F00000041" from archive 2020-02-28 10:57:17 CET [6366-310] LOG: restored log file "000000010000037F00000042" from archive 2020-02-28 10:57:20 CET [6366-311] LOG: restored log file "000000010000037F00000043" from archive 2020-02-28 10:57:22 CET [6366-312] LOG: restored log file "000000010000037F00000044" from archive 2020-02-28 10:57:24 CET [6366-313] LOG: restored log file "000000010000037F00000045" from archive 2020-02-28 10:57:26 CET [6366-314] LOG: restored log file "000000010000037F00000046" from archive 2020-02-28 10:57:28 CET [6366-315] LOG: restored log file "000000010000037F00000047" from archive 2020-02-28 10:57:30 CET [6366-316] LOG: restored log file "000000010000037F00000048" from archive 2020-02-28 10:57:33 CET [6366-317] LOG: restored log file "000000010000037F00000049" from archive 2020-02-28 10:57:35 CET [6366-318] LOG: restored log file "000000010000037F0000004A" from archive 2020-02-28 10:57:37 CET [6366-319] LOG: restored log file "000000010000037F0000004B" from archive 2020-02-28 10:57:40 CET [6366-320] LOG: restored log file "000000010000037F0000004C" from archive 2020-02-28 10:57:42 CET [6366-321] LOG: restored log file "000000010000037F0000004D" from archive 2020-02-28 10:57:44 CET [6366-322] LOG: restored log file "000000010000037F0000004E" from archive 2020-02-28 10:57:48 CET [6366-323] LOG: restored log file "000000010000037F0000004F" from archive 2020-02-28 10:57:50 CET [6366-324] LOG: restored log file "000000010000037F00000050" from archive 2020-02-28 10:57:55 CET [6366-325] LOG: restored log file "000000010000037F00000051" from archive 2020-02-28 10:57:57 CET [6366-326] LOG: restored log file "000000010000037F00000052" from archive 2020-02-28 10:57:59 CET [6366-327] LOG: restored log file "000000010000037F00000053" from archive 2020-02-28 10:58:01 CET [6366-328] LOG: restored log file "000000010000037F00000054" from archive 2020-02-28 10:58:03 CET [6366-329] LOG: restored log file "000000010000037F00000055" from archive 2020-02-28 10:58:09 CET [6366-330] LOG: restored log file "000000010000037F00000056" from archive 2020-02-28 10:58:12 CET [6366-331] LOG: restored log file "000000010000037F00000057" from archive 2020-02-28 10:58:16 CET [6366-332] LOG: restored log file "000000010000037F00000058" from archive 2020-02-28 10:58:19 CET [6366-333] LOG: restored log file "000000010000037F00000059" from archive 2020-02-28 10:58:22 CET [6366-334] LOG: restored log file "000000010000037F0000005A" from archive 2020-02-28 10:58:29 CET [6366-335] LOG: restored log file "000000010000037F0000005B" from archive 2020-02-28 10:58:32 CET [6366-336] LOG: restored log file "000000010000037F0000005C" from archive 2020-02-28 10:58:38 CET [6366-337] LOG: restored log file "000000010000037F0000005D" from archive 2020-02-28 10:58:43 CET [6366-338] LOG: restored log file "000000010000037F0000005E" from archive 2020-02-28 10:58:48 CET [6366-339] LOG: restored log file "000000010000037F0000005F" from archive 2020-02-28 10:58:52 CET [6366-340] LOG: restored log file "000000010000037F00000060" from archive 2020-02-28 10:59:08 CET [6366-341] LOG: restored log file "000000010000037F00000061" from archive 2020-02-28 10:59:14 CET [6366-342] LOG: restored log file "000000010000037F00000062" from archive 2020-02-28 10:59:19 CET [6366-343] LOG: restored log file "000000010000037F00000063" from archive 2020-02-28 10:59:27 CET [6366-344] LOG: restored log file "000000010000037F00000064" from archive 2020-02-28 10:59:31 CET [6366-345] LOG: restored log file "000000010000037F00000065" from archive 2020-02-28 10:59:38 CET [6366-346] LOG: restored log file "000000010000037F00000066" from archive 2020-02-28 10:59:42 CET [6366-347] LOG: restored log file "000000010000037F00000067" from archive 2020-02-28 10:59:48 CET [6366-348] LOG: restored log file "000000010000037F00000068" from archive 2020-02-28 10:59:55 CET [6366-349] LOG: restored log file "000000010000037F00000069" from archive 2020-02-28 11:00:06 CET [6366-350] LOG: restored log file "000000010000037F0000006A" from archive 2020-02-28 11:00:14 CET [6366-351] LOG: restored log file "000000010000037F0000006B" from archive 2020-02-28 11:00:22 CET [6366-352] LOG: restored log file "000000010000037F0000006C" from archive 2020-02-28 11:00:29 CET [6366-353] LOG: restored log file "000000010000037F0000006D" from archive 2020-02-28 11:00:35 CET [6366-354] LOG: restored log file "000000010000037F0000006E" from archive 2020-02-28 11:00:42 CET [6366-355] LOG: restored log file "000000010000037F0000006F" from archive 2020-02-28 11:00:48 CET [6366-356] LOG: restored log file "000000010000037F00000070" from archive 2020-02-28 11:00:54 CET [6366-357] LOG: restored log file "000000010000037F00000071" from archive 2020-02-28 11:00:59 CET [6366-358] LOG: restored log file "000000010000037F00000072" from archive 2020-02-28 11:01:06 CET [6366-359] LOG: restored log file "000000010000037F00000073" from archive 2020-02-28 11:01:23 CET [6366-360] LOG: restored log file "000000010000037F00000074" from archive 2020-02-28 11:01:27 CET [6366-361] LOG: restored log file "000000010000037F00000075" from archive 2020-02-28 11:01:35 CET [6366-362] LOG: restored log file "000000010000037F00000076" from archive 2020-02-28 11:01:41 CET [6366-363] LOG: restored log file "000000010000037F00000077" from archive 2020-02-28 11:01:49 CET [6366-364] LOG: restored log file "000000010000037F00000078" from archive 2020-02-28 11:01:57 CET [6366-365] LOG: restored log file "000000010000037F00000079" from archive 2020-02-28 11:02:07 CET [6366-366] LOG: restored log file "000000010000037F0000007A" from archive 2020-02-28 11:02:12 CET [6366-367] LOG: restored log file "000000010000037F0000007B" from archive 2020-02-28 11:02:27 CET [6366-368] LOG: restored log file "000000010000037F0000007C" from archive 2020-02-28 11:02:35 CET [6366-369] LOG: restored log file "000000010000037F0000007D" from archive 2020-02-28 11:02:42 CET [6366-370] LOG: restored log file "000000010000037F0000007E" from archive 2020-02-28 11:02:50 CET [6366-371] LOG: restored log file "000000010000037F0000007F" from archive 2020-02-28 11:02:54 CET [6366-372] LOG: restored log file "000000010000037F00000080" from archive 2020-02-28 11:03:03 CET [6366-373] LOG: restored log file "000000010000037F00000081" from archive 2020-02-28 11:03:13 CET [6366-374] LOG: restored log file "000000010000037F00000082" from archive 2020-02-28 11:03:18 CET [6366-375] LOG: restored log file "000000010000037F00000083" from archive 2020-02-28 11:03:23 CET [6366-376] LOG: restored log file "000000010000037F00000084" from archive 2020-02-28 11:03:32 CET [6366-377] LOG: restored log file "000000010000037F00000085" from archive 2020-02-28 11:03:38 CET [6366-378] LOG: restored log file "000000010000037F00000086" from archive 2020-02-28 11:03:43 CET [6366-379] LOG: restored log file "000000010000037F00000087" from archive 2020-02-28 11:03:50 CET [6366-380] LOG: restored log file "000000010000037F00000088" from archive 2020-02-28 11:03:57 CET [6366-381] LOG: restored log file "000000010000037F00000089" from archive 2020-02-28 11:04:08 CET [6366-382] LOG: restored log file "000000010000037F0000008A" from archive 2020-02-28 11:04:18 CET [6366-383] LOG: restored log file "000000010000037F0000008B" from archive 2020-02-28 11:04:24 CET [6366-384] LOG: restored log file "000000010000037F0000008C" from archive 2020-02-28 11:04:34 CET [6366-385] LOG: restored log file "000000010000037F0000008D" from archive 2020-02-28 11:04:41 CET [6366-386] LOG: restored log file "000000010000037F0000008E" from archive 2020-02-28 11:04:48 CET [6366-387] LOG: restored log file "000000010000037F0000008F" from archive 2020-02-28 11:04:58 CET [6366-388] LOG: restored log file "000000010000037F00000090" from archive 2020-02-28 11:05:05 CET [6366-389] LOG: restored log file "000000010000037F00000091" from archive 2020-02-28 11:05:15 CET [6366-390] LOG: restored log file "000000010000037F00000092" from archive 2020-02-28 11:05:23 CET [6366-391] LOG: restored log file "000000010000037F00000093" from archive 2020-02-28 11:05:27 CET [6366-392] LOG: restored log file "000000010000037F00000094" from archive 2020-02-28 11:05:34 CET [6366-393] LOG: restored log file "000000010000037F00000095" from archive 2020-02-28 11:05:39 CET [6366-394] LOG: restored log file "000000010000037F00000096" from archive 2020-02-28 11:05:45 CET [6366-395] LOG: restored log file "000000010000037F00000097" from archive 2020-02-28 11:05:54 CET [6366-396] LOG: restored log file "000000010000037F00000098" from archive 2020-02-28 11:06:04 CET [6366-397] LOG: restored log file "000000010000037F00000099" from archive 2020-02-28 11:06:09 CET [6366-398] LOG: restored log file "000000010000037F0000009A" from archive 2020-02-28 11:06:16 CET [6366-399] LOG: restored log file "000000010000037F0000009B" from archive 2020-02-28 11:06:26 CET [6366-400] LOG: restored log file "000000010000037F0000009C" from archive 2020-02-28 11:06:36 CET [6366-401] LOG: restored log file "000000010000037F0000009D" from archive 2020-02-28 11:06:45 CET [6366-402] LOG: restored log file "000000010000037F0000009E" from archive 2020-02-28 11:06:54 CET [6366-403] LOG: restored log file "000000010000037F0000009F" from archive 2020-02-28 11:07:04 CET [6366-404] LOG: restored log file "000000010000037F000000A0" from archive 2020-02-28 11:07:09 CET [6366-405] LOG: restored log file "000000010000037F000000A1" from archive 2020-02-28 11:07:19 CET [6366-406] LOG: restored log file "000000010000037F000000A2" from archive 2020-02-28 11:07:26 CET [6366-407] LOG: restored log file "000000010000037F000000A3" from archive 2020-02-28 11:07:42 CET [6366-408] LOG: restored log file "000000010000037F000000A4" from archive 2020-02-28 11:07:46 CET [6366-409] LOG: restored log file "000000010000037F000000A5" from archive 2020-02-28 11:07:51 CET [6366-410] LOG: restored log file "000000010000037F000000A6" from archive 2020-02-28 11:07:56 CET [6366-411] LOG: restored log file "000000010000037F000000A7" from archive 2020-02-28 11:08:00 CET [6366-412] LOG: restored log file "000000010000037F000000A8" from archive 2020-02-28 11:08:09 CET [6366-413] LOG: restored log file "000000010000037F000000A9" from archive 2020-02-28 11:08:15 CET [6366-414] LOG: restored log file "000000010000037F000000AA" from archive 2020-02-28 11:08:31 CET [6366-415] LOG: restored log file "000000010000037F000000AB" from archive 2020-02-28 11:08:36 CET [6366-416] LOG: restored log file "000000010000037F000000AC" from archive 2020-02-28 11:08:46 CET [6366-417] LOG: restored log file "000000010000037F000000AD" from archive 2020-02-28 11:08:55 CET [6366-418] LOG: restored log file "000000010000037F000000AE" from archive 2020-02-28 11:09:01 CET [6366-419] LOG: restored log file "000000010000037F000000AF" from archive 2020-02-28 11:09:09 CET [6366-420] LOG: restored log file "000000010000037F000000B0" from archive 2020-02-28 11:09:17 CET [6366-421] LOG: restored log file "000000010000037F000000B1" from archive 2020-02-28 11:09:27 CET [6366-422] LOG: restored log file "000000010000037F000000B2" from archive 2020-02-28 11:09:44 CET [6366-423] LOG: restored log file "000000010000037F000000B3" from archive 2020-02-28 11:09:51 CET [6366-424] LOG: restored log file "000000010000037F000000B4" from archive 2020-02-28 11:09:56 CET [6366-425] LOG: restored log file "000000010000037F000000B5" from archive 2020-02-28 11:10:04 CET [6366-426] LOG: restored log file "000000010000037F000000B6" from archive 2020-02-28 11:10:13 CET [6366-427] LOG: restored log file "000000010000037F000000B7" from archive 2020-02-28 11:10:17 CET [6366-428] LOG: restored log file "000000010000037F000000B8" from archive 2020-02-28 11:10:21 CET [6366-429] LOG: restored log file "000000010000037F000000B9" from archive 2020-02-28 11:10:28 CET [6366-430] LOG: restored log file "000000010000037F000000BA" from archive 2020-02-28 11:10:33 CET [6366-431] LOG: restored log file "000000010000037F000000BB" from archive 2020-02-28 11:10:40 CET [6366-432] LOG: restored log file "000000010000037F000000BC" from archive 2020-02-28 11:10:47 CET [6366-433] LOG: restored log file "000000010000037F000000BD" from archive 2020-02-28 11:11:01 CET [6366-434] LOG: restored log file "000000010000037F000000BE" from archive 2020-02-28 11:11:11 CET [6366-435] LOG: restored log file "000000010000037F000000BF" from archive 2020-02-28 11:11:19 CET [6366-436] LOG: restored log file "000000010000037F000000C0" from archive 2020-02-28 11:11:29 CET [6366-437] LOG: restored log file "000000010000037F000000C1" from archive 2020-02-28 11:11:37 CET [6366-438] LOG: restored log file "000000010000037F000000C2" from archive 2020-02-28 11:11:44 CET [6366-439] LOG: restored log file "000000010000037F000000C3" from archive 2020-02-28 11:11:49 CET [6366-440] LOG: restored log file "000000010000037F000000C4" from archive 2020-02-28 11:12:01 CET [6366-441] LOG: restored log file "000000010000037F000000C5" from archive 2020-02-28 11:12:04 CET [6366-442] LOG: restored log file "000000010000037F000000C6" from archive 2020-02-28 11:12:12 CET [6366-443] LOG: restored log file "000000010000037F000000C7" from archive 2020-02-28 11:12:20 CET [6366-444] LOG: restored log file "000000010000037F000000C8" from archive 2020-02-28 11:12:25 CET [6366-445] LOG: restored log file "000000010000037F000000C9" from archive 2020-02-28 11:12:34 CET [6366-446] LOG: restored log file "000000010000037F000000CA" from archive 2020-02-28 11:12:39 CET [6366-447] LOG: restored log file "000000010000037F000000CB" from archive 2020-02-28 11:12:46 CET [6366-448] LOG: restored log file "000000010000037F000000CC" from archive 2020-02-28 11:12:58 CET [6366-449] LOG: restored log file "000000010000037F000000CD" from archive 2020-02-28 11:13:02 CET [6366-450] LOG: restored log file "000000010000037F000000CE" from archive 2020-02-28 11:13:11 CET [6366-451] LOG: restored log file "000000010000037F000000CF" from archive 2020-02-28 11:13:24 CET [6366-452] LOG: restored log file "000000010000037F000000D0" from archive 2020-02-28 11:13:30 CET [6366-453] LOG: restored log file "000000010000037F000000D1" from archive 2020-02-28 11:13:39 CET [6366-454] LOG: restored log file "000000010000037F000000D2" from archive 2020-02-28 11:13:50 CET [6366-455] LOG: restored log file "000000010000037F000000D3" from archive 2020-02-28 11:14:01 CET [6366-456] LOG: restored log file "000000010000037F000000D4" from archive 2020-02-28 11:14:11 CET [6366-457] LOG: restored log file "000000010000037F000000D5" from archive 2020-02-28 11:14:17 CET [6366-458] LOG: restored log file "000000010000037F000000D6" from archive 2020-02-28 11:14:25 CET [6366-459] LOG: restored log file "000000010000037F000000D7" from archive 2020-02-28 11:14:32 CET [6366-460] LOG: restored log file "000000010000037F000000D8" from archive 2020-02-28 11:14:41 CET [6366-461] LOG: restored log file "000000010000037F000000D9" from archive 2020-02-28 11:14:47 CET [6366-462] LOG: restored log file "000000010000037F000000DA" from archive 2020-02-28 11:14:56 CET [6366-463] LOG: restored log file "000000010000037F000000DB" from archive 2020-02-28 11:15:02 CET [6366-464] LOG: restored log file "000000010000037F000000DC" from archive 2020-02-28 11:15:09 CET [6366-465] LOG: restored log file "000000010000037F000000DD" from archive 2020-02-28 11:15:15 CET [6366-466] LOG: restored log file "000000010000037F000000DE" from archive 2020-02-28 11:15:22 CET [6366-467] LOG: restored log file "000000010000037F000000DF" from archive 2020-02-28 11:15:30 CET [6366-468] LOG: restored log file "000000010000037F000000E0" from archive 2020-02-28 11:15:49 CET [6366-469] LOG: restored log file "000000010000037F000000E1" from archive 2020-02-28 11:15:53 CET [6366-470] LOG: restored log file "000000010000037F000000E2" from archive 2020-02-28 11:16:07 CET [6366-471] LOG: restored log file "000000010000037F000000E3" from archive 2020-02-28 11:16:17 CET [6366-472] LOG: restored log file "000000010000037F000000E4" from archive 2020-02-28 11:16:24 CET [6366-473] LOG: restored log file "000000010000037F000000E5" from archive 2020-02-28 11:16:30 CET [6366-474] LOG: restored log file "000000010000037F000000E6" from archive 2020-02-28 11:16:37 CET [6366-475] LOG: restored log file "000000010000037F000000E7" from archive 2020-02-28 11:16:48 CET [6366-476] LOG: restored log file "000000010000037F000000E8" from archive 2020-02-28 11:16:55 CET [6366-477] LOG: restored log file "000000010000037F000000E9" from archive 2020-02-28 11:17:01 CET [6366-478] LOG: restored log file "000000010000037F000000EA" from archive 2020-02-28 11:17:04 CET [6366-479] LOG: restored log file "000000010000037F000000EB" from archive 2020-02-28 11:17:16 CET [6366-480] LOG: restored log file "000000010000037F000000EC" from archive 2020-02-28 11:17:21 CET [6366-481] LOG: restored log file "000000010000037F000000ED" from archive 2020-02-28 11:17:27 CET [6366-482] LOG: restored log file "000000010000037F000000EE" from archive 2020-02-28 11:17:34 CET [6366-483] LOG: restored log file "000000010000037F000000EF" from archive 2020-02-28 11:17:41 CET [6366-484] LOG: restored log file "000000010000037F000000F0" from archive 2020-02-28 11:17:48 CET [6366-485] LOG: restored log file "000000010000037F000000F1" from archive 2020-02-28 11:17:54 CET [6366-486] LOG: restored log file "000000010000037F000000F2" from archive 2020-02-28 11:18:02 CET [6366-487] LOG: restored log file "000000010000037F000000F3" from archive 2020-02-28 11:18:07 CET [6366-488] LOG: restored log file "000000010000037F000000F4" from archive 2020-02-28 11:18:15 CET [6366-489] LOG: restored log file "000000010000037F000000F5" from archive 2020-02-28 11:18:26 CET [6366-490] LOG: restored log file "000000010000037F000000F6" from archive 2020-02-28 11:18:33 CET [6366-491] LOG: restored log file "000000010000037F000000F7" from archive 2020-02-28 11:18:39 CET [6366-492] LOG: restored log file "000000010000037F000000F8" from archive 2020-02-28 11:18:45 CET [6366-493] LOG: restored log file "000000010000037F000000F9" from archive 2020-02-28 11:19:01 CET [6366-494] LOG: restored log file "000000010000037F000000FA" from archive 2020-02-28 11:19:12 CET [6366-495] LOG: restored log file "000000010000037F000000FB" from archive 2020-02-28 11:19:18 CET [6366-496] LOG: restored log file "000000010000037F000000FC" from archive 2020-02-28 11:19:19 CET [6365-1] LOG: received fast shutdown request 2020-02-28 11:19:35 CET [6384-1] LOG: shutting down 2020-02-28 11:19:35 CET [6365-2] LOG: database system is shut down 2020-02-28 11:19:38 CET [8679-1] LOG: database system was shut down in recovery at 2020-02-28 11:19:35 CET 2020-02-28 11:19:38 CET [8679-2] LOG: entering standby mode 2020-02-28 11:19:38 CET [8684-1] [unknown]@[unknown] LOG: incomplete startup packet 2020-02-28 11:19:38 CET [8687-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 11:19:39 CET [8690-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 11:19:39 CET [8693-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 11:19:40 CET [8696-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 11:19:40 CET [8699-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 11:19:41 CET [8702-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 11:19:41 CET [8705-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 11:19:42 CET [8708-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 11:19:42 CET [8679-3] LOG: restored log file "000000010000037F000000F5" from archive 2020-02-28 11:19:42 CET [8717-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 11:19:43 CET [8720-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 11:19:43 CET [8723-1] postgres@postgres FATAL: the database system is starting up 2020-02-28 11:19:43 CET [8724-1] [unknown]@[unknown] LOG: incomplete startup packet 2020-02-28 11:19:46 CET [8679-4] LOG: restored log file "000000010000037F000000F1" from archive 2020-02-28 11:19:46 CET [8679-5] LOG: redo starts at 37F/F11F2C30 2020-02-28 11:19:49 CET [8679-6] LOG: restored log file "000000010000037F000000F2" from archive 2020-02-28 11:19:52 CET [8679-7] LOG: restored log file "000000010000037F000000F3" from archive 2020-02-28 11:19:55 CET [8679-8] LOG: restored log file "000000010000037F000000F4" from archive 2020-02-28 11:19:59 CET [8679-9] LOG: restored log file "000000010000037F000000F5" from archive 2020-02-28 11:20:02 CET [8679-10] LOG: restored log file "000000010000037F000000F6" from archive 2020-02-28 11:20:06 CET [8679-11] LOG: restored log file "000000010000037F000000F7" from archive 2020-02-28 11:20:10 CET [8679-12] LOG: restored log file "000000010000037F000000F8" from archive 2020-02-28 11:20:16 CET [8679-13] LOG: restored log file "000000010000037F000000F9" from archive 2020-02-28 11:20:26 CET [8679-14] LOG: restored log file "000000010000037F000000FA" from archive 2020-02-28 11:20:31 CET [8679-15] LOG: restored log file "000000010000037F000000FB" from archive 2020-02-28 11:20:34 CET [8679-16] LOG: consistent recovery state reached at 37F/FBFFF4D0 2020-02-28 11:20:37 CET [8679-17] LOG: restored log file "000000010000037F000000FC" from archive 2020-02-28 11:20:43 CET [8679-18] LOG: restored log file "000000010000037F000000FD" from archive 2020-02-28 11:20:55 CET [8679-19] LOG: restored log file "000000010000037F000000FE" from archive 2020-02-28 11:21:00 CET [8679-20] LOG: restored log file "000000010000037F000000FF" from archive 2020-02-28 11:21:04 CET [8679-21] LOG: restored log file "000000010000038000000000" from archive 2020-02-28 11:21:12 CET [8679-22] LOG: restored log file "000000010000038000000001" from archive 2020-02-28 11:21:18 CET [8679-23] LOG: restored log file "000000010000038000000002" from archive 2020-02-28 11:21:30 CET [8679-24] LOG: restored log file "000000010000038000000003" from archive 2020-02-28 11:21:37 CET [8679-25] LOG: restored log file "000000010000038000000004" from archive 2020-02-28 11:21:43 CET [8679-26] LOG: restored log file "000000010000038000000005" from archive 2020-02-28 11:21:51 CET [8679-27] LOG: restored log file "000000010000038000000006" from archive 2020-02-28 11:21:58 CET [8679-28] LOG: restored log file "000000010000038000000007" from archive 2020-02-28 11:22:09 CET [8679-29] LOG: restored log file "000000010000038000000008" from archive 2020-02-28 11:22:15 CET [8679-30] LOG: restored log file "000000010000038000000009" from archive 2020-02-28 11:22:21 CET [8679-31] LOG: restored log file "00000001000003800000000A" from archive 2020-02-28 11:22:32 CET [8679-32] LOG: restored log file "00000001000003800000000B" from archive 2020-02-28 11:22:47 CET [8679-33] LOG: restored log file "00000001000003800000000C" from archive 2020-02-28 11:22:52 CET [8679-34] LOG: restored log file "00000001000003800000000D" from archive 2020-02-28 11:23:00 CET [8679-35] LOG: restored log file "00000001000003800000000E" from archive 2020-02-28 11:23:06 CET [8679-36] LOG: restored log file "00000001000003800000000F" from archive 2020-02-28 11:23:14 CET [8679-37] LOG: restored log file "000000010000038000000010" from archive 2020-02-28 11:23:20 CET [8679-38] LOG: restored log file "000000010000038000000011" from archive 2020-02-28 11:23:28 CET [8679-39] LOG: restored log file "000000010000038000000012" from archive 2020-02-28 11:23:35 CET [8679-40] LOG: restored log file "000000010000038000000013" from archive 2020-02-28 11:23:41 CET [8679-41] LOG: restored log file "000000010000038000000014" from archive 2020-02-28 11:23:51 CET [8679-42] LOG: restored log file "000000010000038000000015" from archive 2020-02-28 11:23:55 CET [8679-43] LOG: restored log file "000000010000038000000016" from archive 2020-02-28 11:24:03 CET [8679-44] LOG: restored log file "000000010000038000000017" from archive 2020-02-28 11:24:16 CET [8679-45] LOG: restored log file "000000010000038000000018" from archive 2020-02-28 11:24:23 CET [8679-46] LOG: restored log file "000000010000038000000019" from archive 2020-02-28 11:24:25 CET [8710-1] LOG: could not link file "pg_xlog/xlogtemp.8710" to "pg_xlog/000000010000038000000019": File exists 2020-02-28 11:24:32 CET [8679-47] LOG: restored log file "00000001000003800000001A" from archive 2020-02-28 11:24:40 CET [8679-48] LOG: restored log file "00000001000003800000001B" from archive 2020-02-28 11:24:46 CET [8679-49] LOG: restored log file "00000001000003800000001C" from archive 2020-02-28 11:24:51 CET [8679-50] LOG: restored log file "00000001000003800000001D" from archive 2020-02-28 11:25:03 CET [8679-51] LOG: restored log file "00000001000003800000001E" from archive 2020-02-28 11:25:09 CET [8679-52] LOG: restored log file "00000001000003800000001F" from archive 2020-02-28 11:25:18 CET [8679-53] LOG: restored log file "000000010000038000000020" from archive 2020-02-28 11:25:26 CET [8679-54] LOG: restored log file "000000010000038000000021" from archive 2020-02-28 11:25:31 CET [8679-55] LOG: restored log file "000000010000038000000022" from archive 2020-02-28 11:25:41 CET [8679-56] LOG: restored log file "000000010000038000000023" from archive 2020-02-28 11:25:46 CET [8679-57] LOG: restored log file "000000010000038000000024" from archive 2020-02-28 11:25:53 CET [8679-58] LOG: restored log file "000000010000038000000025" from archive 2020-02-28 11:25:59 CET [8679-59] LOG: restored log file "000000010000038000000026" from archive 2020-02-28 11:26:13 CET [8679-60] LOG: restored log file "000000010000038000000027" from archive 2020-02-28 11:26:13 CET [8710-2] ERROR: could not open file "pg_xlog/000000010000038000000027": No such file or directory 2020-02-28 11:26:17 CET [8679-61] LOG: restored log file "000000010000038000000028" from archive 2020-02-28 11:26:24 CET [8679-62] LOG: restored log file "000000010000038000000029" from archive 2020-02-28 11:26:35 CET [8679-63] LOG: restored log file "00000001000003800000002A" from archive 2020-02-28 11:26:48 CET [8679-64] LOG: restored log file "00000001000003800000002B" from archive 2020-02-28 11:26:58 CET [8679-65] LOG: restored log file "00000001000003800000002C" from archive 2020-02-28 11:27:05 CET [8679-66] LOG: restored log file "00000001000003800000002D" from archive 2020-02-28 11:27:10 CET [8679-67] LOG: restored log file "00000001000003800000002E" from archive 2020-02-28 11:27:14 CET [8679-68] LOG: restored log file "00000001000003800000002F" from archive 2020-02-28 11:27:22 CET [8679-69] LOG: restored log file "000000010000038000000030" from archive 2020-02-28 11:27:28 CET [8679-70] LOG: restored log file "000000010000038000000031" from archive 2020-02-28 11:27:38 CET [8679-71] LOG: restored log file "000000010000038000000032" from archive 2020-02-28 11:27:54 CET [8679-72] LOG: restored log file "000000010000038000000033" from archive 2020-02-28 11:28:00 CET [8679-73] LOG: restored log file "000000010000038000000034" from archive 2020-02-28 11:28:16 CET [8679-74] LOG: restored log file "000000010000038000000035" from archive 2020-02-28 11:28:33 CET [8679-75] LOG: restored log file "000000010000038000000036" from archive 2020-02-28 11:28:43 CET [8679-76] LOG: restored log file "000000010000038000000037" from archive 2020-02-28 11:28:51 CET [8679-77] LOG: restored log file "000000010000038000000038" from archive 2020-02-28 11:29:03 CET [8679-78] LOG: restored log file "000000010000038000000039" from archive 2020-02-28 11:29:17 CET [8679-79] LOG: restored log file "00000001000003800000003A" from archive 2020-02-28 11:29:22 CET [8679-80] LOG: restored log file "00000001000003800000003B" from archive 2020-02-28 11:29:28 CET [8679-81] LOG: restored log file "00000001000003800000003C" from archive 2020-02-28 11:29:34 CET [8679-82] LOG: restored log file "00000001000003800000003D" from archive 2020-02-28 11:29:43 CET [8679-83] LOG: restored log file "00000001000003800000003E" from archive 2020-02-28 11:29:58 CET [8679-84] LOG: restored log file "00000001000003800000003F" from archive 2020-02-28 11:30:14 CET [8679-85] LOG: restored log file "000000010000038000000040" from archive 2020-02-28 11:30:24 CET [8679-86] LOG: restored log file "000000010000038000000041" from archive ```

hellais commented 4 years ago

@lukaskawerau ok, from the looks of it it's not recording your login attempts in that file, maybe that is not the correct place to look at.

From the logs I can see, however, that the replication is working as expected, so you probably just have to understand how to authenticate to the correct postgresql instance.

The file pg_hba.conf should have in it all details about which accounts are allowed to login to which database, but if it's telling you that it cannot find the database called metadb, it may be that you are trying to login to the wrong pg instance.

Do you maybe have more than one postgres instance running on that host?

lukaskawerau commented 4 years ago

Ah, this seems to have been it - I had another instance running on the host. Now I get the FATAL: the database system is starting up as expected. Thanks for the help!