BUG #14221: using postgresql 9.1.22 to 9.3.13 failed using pg_upgrade

Поиск
Список
Период
Сортировка
От lishengxian123@163.com
Тема BUG #14221: using postgresql 9.1.22 to 9.3.13 failed using pg_upgrade
Дата
Msg-id 20160701033018.1397.88367@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14221: using postgresql 9.1.22 to 9.3.13 failed using pg_upgrade  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-bugs
Дерево обсуждения 
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDIyMQpMb2dnZWQgYnk6ICAg
ICAgICAgIGxpIHNoZW5neGlhbgpFbWFpbCBhZGRyZXNzOiAgICAgIGxpc2hl
bmd4aWFuMTIzQDE2My5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjEuMjIK
T3BlcmF0aW5nIHN5c3RlbTogICBDZW50T1MgcmVsZWFzZSA2LjcgKEZpbmFs
KQpEZXNjcmlwdGlvbjogICAgICAgIAoKW3Bvc3RncmVzQHRtMDRhYyB+XSQg
L3Vzci9sb2NhbC9wZ3NxbC9iaW4vcGdfdXBncmFkZSAtYyAtLWxpbmsgLWIK
L3Vzci9sb2NhbC9wZ3NxbF85LjEvYmluIC1CIC91c3IvbG9jYWwvcGdzcWwv
YmluLyAtZAovZGlzay1EQVRBL3Bnc3FsLWRhdGE5LjEgLUQgIC9kaXNrLURB
VEEvcGctZGF0YQ0KDQpzdWNjZXNzZnVsDQoNCmJ1dCBbcG9zdGdyZXNAdG0w
NGFjIH5dJCAvdXNyL2xvY2FsL3Bnc3FsL2Jpbi9wZ191cGdyYWRlICAtLWxp
bmsgLWIKL3Vzci9sb2NhbC9wZ3NxbF85LjEvYmluIC1CIC91c3IvbG9jYWwv
cGdzcWwvYmluLyAtZAovZGlzay1EQVRBL3Bnc3FsLWRhdGE5LjEgLUQgIC9k
aXNrLURBVEEvcGctZGF0YSANCg0KZmFpbGVkDQoNCg0KW3Bvc3RncmVzQHRt
MDRhYyB+XSQgL3Vzci9sb2NhbC9wZ3NxbC9iaW4vcGdfdXBncmFkZSAgLS1s
aW5rIC1iCi91c3IvbG9jYWwvcGdzcWxfOS4xL2JpbiAtQiAvdXNyL2xvY2Fs
L3Bnc3FsL2Jpbi8gLWQKL2Rpc2stREFUQS9wZ3NxbC1kYXRhOS4xIC1EICAv
ZGlzay1EQVRBL3Bnc3FsLWRhdGENClBlcmZvcm1pbmcgQ29uc2lzdGVuY3kg
Q2hlY2tzDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KQ2hlY2tp
bmcgY2x1c3RlciB2ZXJzaW9ucyAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgb2sNCkNoZWNraW5nIGRhdGFiYXNlIHVzZXIgaXMgYSBzdXBl
cnVzZXIgICAgICAgICAgICAgICAgICAgICAgIG9rDQpDaGVja2luZyBkYXRh
YmFzZSBjb25uZWN0aW9uIHNldHRpbmdzICAgICAgICAgICAgICAgICAgICAg
ICBvaw0KQ2hlY2tpbmcgZm9yIHByZXBhcmVkIHRyYW5zYWN0aW9ucyAgICAg
ICAgICAgICAgICAgICAgICAgICAgb2sNCkNoZWNraW5nIGZvciByZWcqIHN5
c3RlbSBPSUQgdXNlciBkYXRhIHR5cGVzICAgICAgICAgICAgICAgIG9rDQpD
aGVja2luZyBmb3IgY29udHJpYi9pc24gd2l0aCBiaWdpbnQtcGFzc2luZyBt
aXNtYXRjaCAgICAgICBvaw0KQ3JlYXRpbmcgZHVtcCBvZiBnbG9iYWwgb2Jq
ZWN0cyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgb2sNCkNyZWF0aW5n
IGR1bXAgb2YgZGF0YWJhc2Ugc2NoZW1hcw0KICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgb2sN
CkNoZWNraW5nIGZvciBwcmVzZW5jZSBvZiByZXF1aXJlZCBsaWJyYXJpZXMg
ICAgICAgICAgICAgICAgIG9rDQpDaGVja2luZyBkYXRhYmFzZSB1c2VyIGlz
IGEgc3VwZXJ1c2VyICAgICAgICAgICAgICAgICAgICAgICBvaw0KQ2hlY2tp
bmcgZm9yIHByZXBhcmVkIHRyYW5zYWN0aW9ucyAgICAgICAgICAgICAgICAg
ICAgICAgICAgb2sNCg0KSWYgcGdfdXBncmFkZSBmYWlscyBhZnRlciB0aGlz
IHBvaW50LCB5b3UgbXVzdCByZS1pbml0ZGIgdGhlDQpuZXcgY2x1c3RlciBi
ZWZvcmUgY29udGludWluZy4NCg0KUGVyZm9ybWluZyBVcGdyYWRlDQotLS0t
LS0tLS0tLS0tLS0tLS0NCkFuYWx5emluZyBhbGwgcm93cyBpbiB0aGUgbmV3
IGNsdXN0ZXIgICAgICAgICAgICAgICAgICAgICAgIG9rDQpGcmVlemluZyBh
bGwgcm93cyBvbiB0aGUgbmV3IGNsdXN0ZXIgICAgICAgICAgICAgICAgICAg
ICAgICBvaw0KRGVsZXRpbmcgZmlsZXMgZnJvbSBuZXcgcGdfY2xvZyAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgb2sNCkNvcHlpbmcgb2xkIHBnX2Ns
b2cgdG8gbmV3IHNlcnZlciAgICAgICAgICAgICAgICAgICAgICAgICAgIG9r
DQpTZXR0aW5nIG5leHQgdHJhbnNhY3Rpb24gSUQgYW5kIGVwb2NoIGZvciBu
ZXcgY2x1c3RlciAgICAgICBvaw0KRGVsZXRpbmcgZmlsZXMgZnJvbSBuZXcg
cGdfbXVsdGl4YWN0L29mZnNldHMgICAgICAgICAgICAgICAgb2sNClNldHRp
bmcgb2xkZXN0IG11bHRpeGFjdCBJRCBvbiBuZXcgY2x1c3RlciAgICAgICAg
ICAgICAgICAgIG9rDQpSZXNldHRpbmcgV0FMIGFyY2hpdmVzICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBvaw0KU2V0dGluZyBmcm96
ZW54aWQgYW5kIG1pbm14aWQgY291bnRlcnMgaW4gbmV3IGNsdXN0ZXIgICAg
ICAgb2sNClJlc3RvcmluZyBnbG9iYWwgb2JqZWN0cyBpbiB0aGUgbmV3IGNs
dXN0ZXIgICAgICAgICAgICAgICAgIG9rDQpBZGRpbmcgc3VwcG9ydCBmdW5j
dGlvbnMgdG8gbmV3IGNsdXN0ZXIgICAgICAgICAgICAgICAgICAgICBvaw0K
UmVzdG9yaW5nIGRhdGFiYXNlIHNjaGVtYXMgaW4gdGhlIG5ldyBjbHVzdGVy
DQogIHBvc3RncmVzDQoqZmFpbHVyZSoNCg0KQ29uc3VsdCB0aGUgbGFzdCBm
ZXcgbGluZXMgb2YgInBnX3VwZ3JhZGVfZHVtcF8xMjY5OS5sb2ciIGZvcg0K
dGhlIHByb2JhYmxlIGNhdXNlIG9mIHRoZSBmYWlsdXJlLg0KRmFpbHVyZSwg
ZXhpdGluZw0KDQoNCnBvc3RncmVzQHRtMDRhYyB+XSQgY2F0IHBnX3VwZ3Jh
ZGVfZHVtcF8xMjY5OS5sb2cNCmNvbW1hbmQ6ICIvdXNyL2xvY2FsL3Bnc3Fs
L2Jpbi9wZ19kdW1wIiAtLWhvc3QgIi9ob21lL3Bvc3RncmVzIiAtLXBvcnQg
NTA0MzIKLS11c2VybmFtZSAicG9zdGdyZXMiIC0tc2NoZW1hLW9ubHkgLS1x
dW90ZS1hbGwtaWRlbnRpZmllcnMgLS1iaW5hcnktdXBncmFkZQotLWZvcm1h
dD1jdXN0b20gIC0tZmlsZT0icGdfdXBncmFkZV9kdW1wXzEyNjk5LmN1c3Rv
bSIgInBvc3RncmVzIiA+PgoicGdfdXBncmFkZV9kdW1wXzEyNjk5LmxvZyIg
Mj4mMQ0KDQoNCmNvbW1hbmQ6ICIvdXNyL2xvY2FsL3Bnc3FsL2Jpbi9wZ19y
ZXN0b3JlIiAtLWhvc3QgIi9ob21lL3Bvc3RncmVzIiAtLXBvcnQKNTA0MzIg
LS11c2VybmFtZSAicG9zdGdyZXMiIC0tZXhpdC1vbi1lcnJvciAtLXZlcmJv
c2UgLS1kYm5hbWUgInBvc3RncmVzIgoicGdfdXBncmFkZV9kdW1wXzEyNjk5
LmN1c3RvbSIgPj4gInBnX3VwZ3JhZGVfZHVtcF8xMjY5OS5sb2ciIDI+JjEN
CnBnX3Jlc3RvcmU6IGNvbm5lY3RpbmcgdG8gZGF0YWJhc2UgZm9yIHJlc3Rv
cmUNCnBnX3Jlc3RvcmU6IGNyZWF0aW5nIHBnX2xhcmdlb2JqZWN0IHBnX2xh
cmdlb2JqZWN0DQpwZ19yZXN0b3JlOiBjcmVhdGluZyBwZ19sYXJnZW9iamVj
dF9tZXRhZGF0YSBwZ19sYXJnZW9iamVjdF9tZXRhZGF0YQ0KcGdfcmVzdG9y
ZTogY3JlYXRpbmcgQ09NTUVOVCBwb3N0Z3Jlcw0KcGdfcmVzdG9yZTogY3Jl
YXRpbmcgU0NIRU1BIHB1YmxpYw0KcGdfcmVzdG9yZTogY3JlYXRpbmcgQ09N
TUVOVCBTQ0hFTUEgInB1YmxpYyINCnBnX3Jlc3RvcmU6IGNyZWF0aW5nIEVY
VEVOU0lPTiBkYmxpbmsNCnBnX3Jlc3RvcmU6IGNyZWF0aW5nIENPTU1FTlQg
RVhURU5TSU9OICJkYmxpbmsiDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBFWFRF
TlNJT04gcGdfYnVmZmVyY2FjaGUNCnBnX3Jlc3RvcmU6IGNyZWF0aW5nIENP
TU1FTlQgRVhURU5TSU9OICJwZ19idWZmZXJjYWNoZSINCnBnX3Jlc3RvcmU6
IGNyZWF0aW5nIEVYVEVOU0lPTiBwZ19zdGF0X3N0YXRlbWVudHMNCnBnX3Jl
c3RvcmU6IGNyZWF0aW5nIENPTU1FTlQgRVhURU5TSU9OICJwZ19zdGF0X3N0
YXRlbWVudHMiDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBUWVBFIGRibGlua19w
a2V5X3Jlc3VsdHMNCnBnX3Jlc3RvcmU6IGNyZWF0aW5nIEZVTkNUSU9OIGRi
bGluaygidGV4dCIpDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBk
YmxpbmsoInRleHQiLCBib29sZWFuKQ0KcGdfcmVzdG9yZTogY3JlYXRpbmcg
RlVOQ1RJT04gZGJsaW5rKCJ0ZXh0IiwgInRleHQiKQ0KcGdfcmVzdG9yZTog
Y3JlYXRpbmcgRlVOQ1RJT04gZGJsaW5rKCJ0ZXh0IiwgInRleHQiLCBib29s
ZWFuKQ0KcGdfcmVzdG9yZTogY3JlYXRpbmcgRlVOQ1RJT04gZGJsaW5rX2J1
aWxkX3NxbF9kZWxldGUoInRleHQiLCAiaW50MnZlY3RvciIsCmludGVnZXIs
ICJ0ZXh0IltdKQ0KcGdfcmVzdG9yZTogY3JlYXRpbmcgRlVOQ1RJT04gZGJs
aW5rX2J1aWxkX3NxbF9pbnNlcnQoInRleHQiLCAiaW50MnZlY3RvciIsCmlu
dGVnZXIsICJ0ZXh0IltdLCAidGV4dCJbXSkNCnBnX3Jlc3RvcmU6IGNyZWF0
aW5nIEZVTkNUSU9OIGRibGlua19idWlsZF9zcWxfdXBkYXRlKCJ0ZXh0Iiwg
ImludDJ2ZWN0b3IiLAppbnRlZ2VyLCAidGV4dCJbXSwgInRleHQiW10pDQpw
Z19yZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBkYmxpbmtfY2FuY2VsX3F1
ZXJ5KCJ0ZXh0IikNCnBnX3Jlc3RvcmU6IGNyZWF0aW5nIEZVTkNUSU9OIGRi
bGlua19jbG9zZSgidGV4dCIpDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBGVU5D
VElPTiBkYmxpbmtfY2xvc2UoInRleHQiLCBib29sZWFuKQ0KcGdfcmVzdG9y
ZTogY3JlYXRpbmcgRlVOQ1RJT04gZGJsaW5rX2Nsb3NlKCJ0ZXh0IiwgInRl
eHQiKQ0KcGdfcmVzdG9yZTogY3JlYXRpbmcgRlVOQ1RJT04gZGJsaW5rX2Ns
b3NlKCJ0ZXh0IiwgInRleHQiLCBib29sZWFuKQ0KcGdfcmVzdG9yZTogY3Jl
YXRpbmcgRlVOQ1RJT04gZGJsaW5rX2Nvbm5lY3QoInRleHQiKQ0KcGdfcmVz
dG9yZTogY3JlYXRpbmcgRlVOQ1RJT04gZGJsaW5rX2Nvbm5lY3QoInRleHQi
LCAidGV4dCIpDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBkYmxp
bmtfY29ubmVjdF91KCJ0ZXh0IikNCnBnX3Jlc3RvcmU6IGNyZWF0aW5nIEZV
TkNUSU9OIGRibGlua19jb25uZWN0X3UoInRleHQiLCAidGV4dCIpDQpwZ19y
ZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBkYmxpbmtfY3VycmVudF9xdWVy
eSgpDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBkYmxpbmtfZGlz
Y29ubmVjdCgpDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBkYmxp
bmtfZGlzY29ubmVjdCgidGV4dCIpDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBG
VU5DVElPTiBkYmxpbmtfZXJyb3JfbWVzc2FnZSgidGV4dCIpDQpwZ19yZXN0
b3JlOiBjcmVhdGluZyBGVU5DVElPTiBkYmxpbmtfZXhlYygidGV4dCIpDQpw
Z19yZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBkYmxpbmtfZXhlYygidGV4
dCIsIGJvb2xlYW4pDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBk
YmxpbmtfZXhlYygidGV4dCIsICJ0ZXh0IikNCnBnX3Jlc3RvcmU6IGNyZWF0
aW5nIEZVTkNUSU9OIGRibGlua19leGVjKCJ0ZXh0IiwgInRleHQiLCBib29s
ZWFuKQ0KcGdfcmVzdG9yZTogY3JlYXRpbmcgRlVOQ1RJT04gZGJsaW5rX2Zl
dGNoKCJ0ZXh0IiwgaW50ZWdlcikNCnBnX3Jlc3RvcmU6IGNyZWF0aW5nIEZV
TkNUSU9OIGRibGlua19mZXRjaCgidGV4dCIsIGludGVnZXIsIGJvb2xlYW4p
DQpwZ19yZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBkYmxpbmtfZmV0Y2go
InRleHQiLCAidGV4dCIsIGludGVnZXIpDQpwZ19yZXN0b3JlOiBjcmVhdGlu
ZyBGVU5DVElPTiBkYmxpbmtfZmV0Y2goInRleHQiLCAidGV4dCIsIGludGVn
ZXIsCmJvb2xlYW4pDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBk
YmxpbmtfZ2V0X2Nvbm5lY3Rpb25zKCkNCnBnX3Jlc3RvcmU6IGNyZWF0aW5n
IEZVTkNUSU9OIGRibGlua19nZXRfbm90aWZ5KCkNCnBnX3Jlc3RvcmU6IGNy
ZWF0aW5nIEZVTkNUSU9OIGRibGlua19nZXRfbm90aWZ5KCJ0ZXh0IikNCnBn
X3Jlc3RvcmU6IGNyZWF0aW5nIEZVTkNUSU9OIGRibGlua19nZXRfcGtleSgi
dGV4dCIpDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBkYmxpbmtf
Z2V0X3Jlc3VsdCgidGV4dCIpDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBGVU5D
VElPTiBkYmxpbmtfZ2V0X3Jlc3VsdCgidGV4dCIsIGJvb2xlYW4pDQpwZ19y
ZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBkYmxpbmtfaXNfYnVzeSgidGV4
dCIpDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBkYmxpbmtfb3Bl
bigidGV4dCIsICJ0ZXh0IikNCnBnX3Jlc3RvcmU6IGNyZWF0aW5nIEZVTkNU
SU9OIGRibGlua19vcGVuKCJ0ZXh0IiwgInRleHQiLCBib29sZWFuKQ0KcGdf
cmVzdG9yZTogY3JlYXRpbmcgRlVOQ1RJT04gZGJsaW5rX29wZW4oInRleHQi
LCAidGV4dCIsICJ0ZXh0IikNCnBnX3Jlc3RvcmU6IGNyZWF0aW5nIEZVTkNU
SU9OIGRibGlua19vcGVuKCJ0ZXh0IiwgInRleHQiLCAidGV4dCIsIGJvb2xl
YW4pDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBkYmxpbmtfc2Vu
ZF9xdWVyeSgidGV4dCIsICJ0ZXh0IikNCnBnX3Jlc3RvcmU6IGNyZWF0aW5n
IEZVTkNUSU9OIHBnX2J1ZmZlcmNhY2hlX3BhZ2VzKCkNCnBnX3Jlc3RvcmU6
IGNyZWF0aW5nIEZVTkNUSU9OIHBnX3N0YXRfc3RhdGVtZW50cygpDQpwZ19y
ZXN0b3JlOiBjcmVhdGluZyBGVU5DVElPTiBwZ19zdGF0X3N0YXRlbWVudHNf
cmVzZXQoKQ0KcGdfcmVzdG9yZTogY3JlYXRpbmcgVklFVyBwZ19idWZmZXJj
YWNoZQ0KcGdfcmVzdG9yZTogY3JlYXRpbmcgVklFVyBwZ19zdGF0X3N0YXRl
bWVudHMNCnBnX3Jlc3RvcmU6IGNyZWF0aW5nIFZJRVcgdndfY3VycmVudHF1
ZXJpZXMNCnBnX3Jlc3RvcmU6IFthcmNoaXZlciAoZGIpXSBFcnJvciB3aGls
ZSBQUk9DRVNTSU5HIFRPQzoNCnBnX3Jlc3RvcmU6IFthcmNoaXZlciAoZGIp
XSBFcnJvciBmcm9tIFRPQyBlbnRyeSAxNjc7IDEyNTkgMTAzNDI5NTg0IFZJ
RVcKdndfY3VycmVudHF1ZXJpZXMgZGJhZG1pbg0KcGdfcmVzdG9yZTogW2Fy
Y2hpdmVyIChkYildIGNvdWxkIG5vdCBleGVjdXRlIHF1ZXJ5OiBFUlJPUjog
IGNvbHVtbgpwZ19zdGF0X2FjdGl2aXR5LnByb2NwaWQgZG9lcyBub3QgZXhp
c3QNCkxJTkUgMTQ6IFNFTEVDVCAicGdfc3RhdF9hY3Rpdml0eSIuInByb2Nw
aWQiLCAicGdfc3RhdF9hY3Rpdml0eSIuImNsaS4uLg0KICAgICAgICAgICAg
ICAgIF4NCiAgICBDb21tYW5kIHdhczoNCi0tIEZvciBiaW5hcnkgdXBncmFk
ZSwgbXVzdCBwcmVzZXJ2ZSBwZ190eXBlIG9pZA0KU0VMRUNUIGJpbmFyeV91
cGdyYWRlLnNldF9uZXh0X3BnX3R5cGVfb2lkKCcxMDM0Mjk1ODYnOjpwZ19j
YXRhbG9nLm9pZCk7DQoNCi4uLg0KW3Bvc3RncmVzQHRtMDRhYyB+XSQNCg0K
DQoNCg0KPT09PT09PT09PT09PT0NCg0KQXMgSSBrbm93IGZvciB0aGUgcG9z
dGdyZXNxbCA5LjMgdGhlIGNvbHVtbiBhbHJlYWR5IGNoYW5nZSB0byBwaWQg
ZnJvbQpwcm9jcGlkIG9uIHRhYmxlIHBnX3N0YXRfYWN0aXZpdHkgLiBwbGVh
c2UgaGVscCB0byBjb25maXJtIGlmIGl0IGJ1ZyBvciBub3QKLiB0aGFua3Mg
YSBsb3QNCgoK

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #14220: pg_get_expr() with an incorrect relation id crashes the server
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14220: pg_get_expr() with an incorrect relation id crashes the server