BUG #16199: pg_restore stuck on interrupts

PG Bug reporting form <[email protected]> Wed, 08 Jan 2020 16:17:57 +0000
Newsgroups gmane.comp.db.postgresql.bugs
Message-ID <[email protected]>
--===============4734046296350550033==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64

VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl
ZmVyZW5jZTogICAgICAxNjE5OQpMb2dnZWQgYnk6ICAgICAgICAgIFJhw7psIE1hcsOtbgpFbWFp
bCBhZGRyZXNzOiAgICAgIGdpdEBybXIubmluamEKUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMS41Ck9w
ZXJhdGluZyBzeXN0ZW06ICAgTGludXgKRGVzY3JpcHRpb246ICAgICAgICAKCldlIGFyZSBzZWVp
bmcgc3R1Y2sgcGdfcmVzdG9yZSBwcm9jZXNzZXMgaW4gc2V2ZXJhbCBvZiBvdXIgQ0kgc2VydmVy
cywgYm90aAp3aXRoIFBHMTAgKDEwLjIpIGFuZCBQRzExICgxMS41KS4NClRoZXNlIHNlcnZlcnMg
dGVzdCBhbiBleHRlcm5hbCBhcHBsaWNhdGlvbiB3aGljaCB1c2VzIHBnX3Jlc3RvcmUgcXVpdGUg
b2Z0ZW4KdG8gc2V0IHVwIHRlc3QgZW52aXJvbm1lbnRzLg0KDQpBIHNhbXBsZSBjYWxsIG1pZ2h0
IGxvb2sgbGlrZSB0aGlzOg0KYGBgDQovdXNyL2xpYi9wb3N0Z3Jlc3FsLzEwL2Jpbi9wZ19yZXN0
b3JlIC1lIC0tdmVyYm9zZSAtajQgLS1kaXNhYmxlLXRyaWdnZXJzCi1GYwovdG1wL3VzZXJfaW1w
b3J0cy8xMTEzZDEzOS0yMmM2LTRkZDktOGFlNi04MzYzNDNhZDY4NTQvZGF0YS9vcmdfY2QyYjJm
YjAtOTZmOS00NzZmLTk1ODktYjFkNWUwYjkzOTU3LmR1bXAKLVUgcG9zdGdyZXMgLWggbG9jYWxo
b3N0IC1wIDU0MzIgLWQKY2FydG9kYl90ZXN0X3VzZXJfNjg0YTA0OTctOTM1OC00OWFlLTg5Yjct
NWZlZWE1YTZiN2Q3X2RiCi0tc2VjdGlvbj1wb3N0LWRhdGEKLS11c2UtbGlzdD0vdG1wL3VzZXJf
aW1wb3J0cy8xMTEzZDEzOS0yMmM2LTRkZDktOGFlNi04MzYzNDNhZDY4NTQvZGF0YS91c2VyX29y
ZzQ0MDAwMDU0LWFkbWluLmxpc3QNCmBgYA0KDQpXaXRoIHRoZSBhcHByb3ByaWF0ZSBzeW1ib2xz
IEkgY2FuIGF0dGFjaCB0byB0aGUgcHJvY2VzcyBhbmQgZXh0cmFjdCB0aGUKY2FsbHN0YWNrIChu
b3QgYWx3YXlzIGZ1bGx5IGF2YWlsYWJsZSk6DQpgYGANCihnZGIpIGJ0DQojMCAgX19sbGxfbG9j
a193YWl0X3ByaXZhdGUgKCkgYXQKLi4vc3lzZGVwcy91bml4L3N5c3YvbGludXgveDg2XzY0L2xv
d2xldmVsbG9jay5TOjk1DQojMSAgMHgwMDAwN2Y0YjAzZTE1MmJkIGluIF9pbnRfZnJlZSAoYXY9
MHg3ZjRiMDQxNTliMjAgPG1haW5fYXJlbmE+LApwPTB4NTVkNDM1OTBlM2IwLCBoYXZlX2xvY2s9
MCkgYXQgbWFsbG9jLmM6Mzk2Mg0KIzIgIDB4MDAwMDdmNGIwM2UxOTUzYyBpbiBfX0dJX19fbGli
Y19mcmVlIChtZW09PG9wdGltaXplZCBvdXQ+KSBhdAptYWxsb2MuYzoyOTY4DQojMyAgMHgwMDAw
N2Y0YjAxYmJmNDY0IGluIF9nbnV0bHNfZXh0X2RlaW5pdCAoKSBhdCBnbnV0bHNfZXh0ZW5zaW9u
cy5jOjQwNQ0KIzQgIDB4MDAwMDdmNGIwMWJjNjcyMCBpbiBfZ251dGxzX2dsb2JhbF9kZWluaXQg
KGRlc3RydWN0b3I9MSkgYXQKZ251dGxzX2dsb2JhbC5jOjM4OQ0KIzUgIDB4MDAwMDdmNGIwNDdl
ZWRlNyBpbiBfZGxfZmluaSAoKSBhdCBkbC1maW5pLmM6MjM1DQojNiAgMHgwMDAwN2Y0YjAzZGNl
ZmY4IGluIF9fcnVuX2V4aXRfaGFuZGxlcnMgKHN0YXR1cz1zdGF0dXNAZW50cnk9MSwKbGlzdHA9
MHg3ZjRiMDQxNTk1ZjggPF9fZXhpdF9mdW5jcz4sCnJ1bl9saXN0X2F0ZXhpdD1ydW5fbGlzdF9h
dGV4aXRAZW50cnk9dHJ1ZSkNCiAgICBhdCBleGl0LmM6ODINCiM3ICAweDAwMDA3ZjRiMDNkY2Yw
NDUgaW4gX19HSV9leGl0IChzdGF0dXM9c3RhdHVzQGVudHJ5PTEpIGF0IGV4aXQuYzoxMDQNCiM4
ICAweDAwMDA1NWQ0MzM3ZGJiNWUgaW4gc2lnVGVybUhhbmRsZXIgKHBvc3RncmVzX3NpZ25hbF9h
cmc9PG9wdGltaXplZApvdXQ+KQ0KICAgIGF0Ci9idWlsZC9wb3N0Z3Jlc3FsLTEwLWJ4MUpBeC9w
b3N0Z3Jlc3FsLTEwLTEwLjEuMitjYXJ0by9idWlsZC8uLi9zcmMvYmluL3BnX2R1bXAvcGFyYWxs
ZWwuYzo2MTMNCiM5ICA8c2lnbmFsIGhhbmRsZXIgY2FsbGVkPg0KIzEwIF9pbnRfZnJlZSAoYXY9
MHg3ZjRiMDQxNTliMjAgPG1haW5fYXJlbmE+LCBwPTxvcHRpbWl6ZWQgb3V0PiwKaGF2ZV9sb2Nr
PTApIGF0IG1hbGxvYy5jOjQwMTcNCiMxMSAweDAwMDA3ZjRiMDNlMTk1M2MgaW4gX19HSV9fX2xp
YmNfZnJlZSAobWVtPTxvcHRpbWl6ZWQgb3V0PikgYXQKbWFsbG9jLmM6Mjk2OA0KIzEyIDB4MDAw
MDdmNGIwM2UxMDU0YiBpbiBfX0dJX19JT19zZXRiIChmPWZAZW50cnk9MHg1NWQ0MzU5MTQyNDAs
CmI9YkBlbnRyeT0weDAsIGViPWViQGVudHJ5PTB4MCwgYT1hQGVudHJ5PTApIGF0IGdlbm9wcy5j
OjM4Mg0KIzEzIDB4MDAwMDdmNGIwM2UwZThlZSBpbiBfSU9fbmV3X2ZpbGVfY2xvc2VfaXQgKGZw
PWZwQGVudHJ5PTB4NTVkNDM1OTE0MjQwKQphdCBmaWxlb3BzLmM6MTg1DQojMTQgMHgwMDAwN2Y0
YjAzZTAyM2VmIGluIF9JT19uZXdfZmNsb3NlIChmcD0weDU1ZDQzNTkxNDI0MCkgYXQKaW9mY2xv
c2UuYzo1OA0KIzE1IDB4MDAwMDU1ZDQzMzdkNzk4ZSBpbiBfUmVvcGVuQXJjaGl2ZSAoQUg9MHg1
NWQ0MzVhYTk0ZTApDQogICAgYXQKL2J1aWxkL3Bvc3RncmVzcWwtMTAtYngxSkF4L3Bvc3RncmVz
cWwtMTAtMTAuMS4yK2NhcnRvL2J1aWxkLy4uL3NyYy9iaW4vcGdfZHVtcC9wZ19iYWNrdXBfY3Vz
dG9tLmM6NzYzDQojMTYgMHgwMDAwNTVkNDMzN2RjM2FmIGluIFJ1bldvcmtlciAoc2xvdD0weDU1
ZDQzNWFkYTRiOCwKQUg9MHg1NWQ0MzVhYTk0ZTApDQogICAgYXQKL2J1aWxkL3Bvc3RncmVzcWwt
MTAtYngxSkF4L3Bvc3RncmVzcWwtMTAtMTAuMS4yK2NhcnRvL2J1aWxkLy4uL3NyYy9iaW4vcGdf
ZHVtcC9wYXJhbGxlbC5jOjg2Ng0KIzE3IFBhcmFsbGVsQmFja3VwU3RhcnQgKEFIPUFIQGVudHJ5
PTB4NTVkNDM1OTBmZTAwKSBhdAovYnVpbGQvcG9zdGdyZXNxbC0xMC1ieDFKQXgvcG9zdGdyZXNx
bC0xMC0xMC4xLjIrY2FydG8vYnVpbGQvLi4vc3JjL2Jpbi9wZ19kdW1wL3BhcmFsbGVsLmM6MTAy
Nw0KIzE4IDB4MDAwMDU1ZDQzMzdkNDQxOCBpbiBSZXN0b3JlQXJjaGl2ZSAoQUhYPTB4NTVkNDM1
OTBmZTAwKQ0KICAgIGF0Ci9idWlsZC9wb3N0Z3Jlc3FsLTEwLWJ4MUpBeC9wb3N0Z3Jlc3FsLTEw
LTEwLjEuMitjYXJ0by9idWlsZC8uLi9zcmMvYmluL3BnX2R1bXAvcGdfYmFja3VwX2FyY2hpdmVy
LmM6NjQ5DQojMTkgMHgwMDAwNTVkNDMzN2NlOWNhIGluIG1haW4gKGFyZ2M9MTcsIGFyZ3Y9PG9w
dGltaXplZCBvdXQ+KQ0KICAgIGF0Ci9idWlsZC9wb3N0Z3Jlc3FsLTEwLWJ4MUpBeC9wb3N0Z3Jl
c3FsLTEwLTEwLjEuMitjYXJ0by9idWlsZC8uLi9zcmMvYmluL3BnX2R1bXAvcGdfcmVzdG9yZS5j
OjQyOQ0KYGBgDQoNCkkgaGF2ZSBhIHNvbWUgZXh0cmEgcHJvY2Vzc2VzIHdpdGggdGhlIHNhbWUg
aXNzdWUgICg3IGZ1bGwgc3RhY2tzIG91dCBvZiAyMCwKdGhlIG90aGVycyBhcmUgZ2FyYmFnZSkg
YW5kLCBmcm9tIHdoYXQgSSBzZWUsIHRoZXkgYWxsIGhhdmUgaW4gY29tbW9uIHRoYXQKdGhlIHBy
b2Nlc3MgaGFzIHJlY2VpdmVkIGEgc2lnbmFsIHdoaWxlIGl0IHdhcyBkb2luZyBhIG1lbW9yeSBv
cGVyYXRpb24sCmVpdGhlciBhIG1hbGxvYyBvciBhIGZyZWU6DQoNCiogTWFsbG9jIGV4YW1wbGU6
DQpgYGANCiM4ICAweDAwMDA1NjM0YThlYmViNWUgaW4gc2lnVGVybUhhbmRsZXIgKHBvc3RncmVz
X3NpZ25hbF9hcmc9PG9wdGltaXplZApvdXQ+KQ0KICAgIGF0Ci9idWlsZC9wb3N0Z3Jlc3FsLTEw
LWJ4MUpBeC9wb3N0Z3Jlc3FsLTEwLTEwLjEuMitjYXJ0by9idWlsZC8uLi9zcmMvYmluL3BnX2R1
bXAvcGFyYWxsZWwuYzo2MTMNCiM5ICA8c2lnbmFsIGhhbmRsZXIgY2FsbGVkPg0KIzEwIF9pbnRf
bWFsbG9jIChhdj1hdkBlbnRyeT0weDdmY2UxNTE0MmIyMCA8bWFpbl9hcmVuYT4sCmJ5dGVzPWJ5
dGVzQGVudHJ5PTE3NTg0KSBhdCBtYWxsb2MuYzozNjQ0DQojMTEgMHgwMDAwN2ZjZTE0ZTAyMTg0
IGluIF9fR0lfX19saWJjX21hbGxvYyAoYnl0ZXM9MTc1ODQpIGF0Cm1hbGxvYy5jOjI5MTMNCiMx
MiAweDAwMDA3ZmNlMTQ3MzJlNzggaW4gQ1JZUFRPX21hbGxvYyAoKSBmcm9tCi9saWIveDg2XzY0
LWxpbnV4LWdudS9saWJjcnlwdG8uc28uMS4wLjANCiMxMyAweDAwMDA3ZmNlMTRiM2RhZmQgaW4g
Pz8gKCkgZnJvbSAvbGliL3g4Nl82NC1saW51eC1nbnUvbGlic3NsLnNvLjEuMC4wDQojMTQgMHgw
MDAwN2ZjZTE0YjNkYjY4IGluID8/ICgpIGZyb20gL2xpYi94ODZfNjQtbGludXgtZ251L2xpYnNz
bC5zby4xLjAuMA0KIzE1IDB4MDAwMDdmY2UxNGIzZmI2YyBpbiA/PyAoKSBmcm9tIC9saWIveDg2
XzY0LWxpbnV4LWdudS9saWJzc2wuc28uMS4wLjANCiMxNiAweDAwMDA3ZmNlMTU1YTRmYjUgaW4g
b3Blbl9jbGllbnRfU1NMIChjb25uPTB4NTYzNGE5YTFhMzcwKQ0KYGBgDQoNCiogRnJlZSBleGFt
cGxlOg0KYGBgDQojOCAgMHgwMDAwNTYzNDU1YjYwZTdlIGluIHNpZ1Rlcm1IYW5kbGVyIChwb3N0
Z3Jlc19zaWduYWxfYXJnPTxvcHRpbWl6ZWQKb3V0PikNCiAgICBhdAovYnVpbGQvcG9zdGdyZXNx
bC0xMS0zb3JwbHMvcG9zdGdyZXNxbC0xMS0xMS41LjIrY2FydG8vYnVpbGQvLi4vc3JjL2Jpbi9w
Z19kdW1wL3BhcmFsbGVsLmM6NjE1DQojOSAgPHNpZ25hbCBoYW5kbGVyIGNhbGxlZD4NCiMxMCAw
eDAwMDA3ZmJiYTIxYmI4ZTQgaW4gX2ludF9mcmVlIChhdj0weDdmYmJhMjRmZmIyMCA8bWFpbl9h
cmVuYT4sCnA9MHg1NjM0NTc5OTkzYjAsIGhhdmVfbG9jaz0wKSBhdCBtYWxsb2MuYzozOTc2DQoj
MTEgMHgwMDAwN2ZiYmEyMWJmNTNjIGluIF9fR0lfX19saWJjX2ZyZWUgKG1lbT08b3B0aW1pemVk
IG91dD4pIGF0Cm1hbGxvYy5jOjI5NjgNCiMxMiAweDAwMDA1NjM0NTViNjE0MGUgaW4gc2V0X2Fy
Y2hpdmVfY2FuY2VsX2luZm8KKEFIPUFIQGVudHJ5PTB4NTYzNDU3OWFkMzUwLCBjb25uPWNvbm5A
ZW50cnk9MHgwKQ0KYGBgDQoNCkFmdGVyIHRoYXQsIHRoZSBwcm9jZXNzIGdpdmVzIGNvbnRyb2wg
dG8gYHNpZ1Rlcm1IYW5kbGVyYCB3aGljaCBjYWxscwpgZXhpdCgxKWAgdG8gZGllLCBidXQgdGhh
dCBnaXZlcyBjb250cm9sIHRvIHdob2V2ZXIgaGFzIHNldHVwIGF0ZXhpdApmdW5jdGlvbnMsIGlu
IG91ciBjYXNlIGBnbnV0bHNgLiBPbmNlIGdudXRscyB0cmllcyB0byBjYWxsIGBmcmVlYCBhcyBw
YXJ0IG9mCml0cyBjbGVhbnVwIHByb2Nlc3MsIGl0IHdpbGwgdHJ5IHRvIGFjcXVpcmUgdGhlIGxv
Y2sgYW5kIGJsb2NrLCBidXQgc2luY2UKdGhlIGxvY2sgaXMgYmVpbmcgaGVsZCBieSB0aGUgZnVu
Y3Rpb24gaW50ZXJydXB0ZWQgYnkgdGhlIHNpZ25hbCB0aGUgcHJvY2VzcwpzZWxmIGxvY2tzIGFu
ZCBoYW5ncyBmb3JldmVyLg0KDQpJIHRoaW5rIGlmIHdvdWxkIGJlIHNhZmVyIHRvIHVzZSBhIHNp
bWlsYXIgYXBwcm9hY2ggdG8gb3RoZXIgcHJvY2Vzc2VzLCB0aGF0CmlzIHVzZSB0aGUgaGFuZGxl
ciB0byBvbmx5IGVuYWJsZSBhIGdsb2JhbCBmbGFnIGFuZCBjaGVjayB0aGF0IGluIHRoZSBtYWlu
Cmxvb3AsIGJ1dCBJJ20gaGF2aW5nIGEgaGFyZCB0aW1lIGxvY2F0aW5nIHdoYXQgdGhlIHByb3Bl
ciBwbGFjZSB0byBjaGVjayB0aGUKZmxhZyB3b3VsZCBiZS4NCg0KUmVnYXJkcywNClJhw7psIE1h
csOtbi4KCg==

--===============4734046296350550033==--