Обсуждение: BUG #14221: using postgresql 9.1.22 to 9.3.13 failed using pg_upgrade
BUG #14221: using postgresql 9.1.22 to 9.3.13 failed using pg_upgrade
От
lishengxian123@163.com
Дата:
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
On Fri, Jul 1, 2016 at 03:30:18AM +0000, lishengxian123@163.com wrote: > pg_restore: creating VIEW pg_buffercache > pg_restore: creating VIEW pg_stat_statements > pg_restore: creating VIEW vw_currentqueries > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 167; 1259 103429584 VIEW > vw_currentqueries dbadmin > pg_restore: [archiver (db)] could not execute query: ERROR: column > pg_stat_activity.procpid does not exist > LINE 14: SELECT "pg_stat_activity"."procpid", "pg_stat_activity"."cli... > ^ > Command was: > -- For binary upgrade, must preserve pg_type oid > SELECT binary_upgrade.set_next_pg_type_oid('103429586'::pg_catalog.oid); > > ============== > > As I know for the postgresql 9.3 the column already change to pid from > procpid on table pg_stat_activity . please help to confirm if it bug or not > . thanks a lot Yeah, I suggest you drop the view, run pg_upgrade, then recreate the view. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +