Thread: pg_restore parameter( -n) not work

SGVsbG8sIEkgcnVuIHBnX3Jlc3RvcmUgb24gbGludXguIEkgbWVldCBhIHBy
b2JsZW0uIEl0IGlzIC4uLg0KDQpwZ19yZXN0b3JlIDguMS4wIHBhcmFtZXRl
ciggLW4pICBub3Qgd29ya6GjDQoNCg0KVEVTVCBDQVNFOg0KDQpbcG9zdGdy
ZXNAZGIyIH5dJCBjcmVhdGVkYiBkYjUNCkNSRUFURSBEQVRBQkFTRQ0KW3Bv
c3RncmVzQGRiMiB+XSQgcHNxbCBkYjUNCldlbGNvbWUgdG8gcHNxbCA4LjEu
MCwgdGhlIFBvc3RncmVTUUwgaW50ZXJhY3RpdmUgdGVybWluYWwuDQoNClR5
cGU6ICBcY29weXJpZ2h0IGZvciBkaXN0cmlidXRpb24gdGVybXMNCiAgICAg
ICBcaCBmb3IgaGVscCB3aXRoIFNRTCBjb21tYW5kcw0KICAgICAgIFw/IGZv
ciBoZWxwIHdpdGggcHNxbCBjb21tYW5kcw0KICAgICAgIFxnIG9yIHRlcm1p
bmF0ZSB3aXRoIHNlbWljb2xvbiB0byBleGVjdXRlIHF1ZXJ5DQogICAgICAg
XHEgdG8gcXVpdA0KDQpkYjU9IyBjcmVhdGUgdGFibGUgdDEoaSBpbnQsaiBp
bnQpOw0KQ1JFQVRFIFRBQkxFDQpkYjU9IyBjcmVhdGUgIHNjaGVtYSB3b3Jr
Ow0KQ1JFQVRFIFNDSEVNQQ0KZGI1PSMgY3JlYXRlIHRhYmxlIHdvcmsudDEo
aSBpbnQsaiBpbnQpOw0KQ1JFQVRFIFRBQkxFDQpkYjUtIyBccQ0KW3Bvc3Rn
cmVzQGRiMiB+XSQgcGdfZHVtcCAtZCBkYjUgLUZjID4gYS5vdXQNCg0KT29u
bHkgYSBsaXR0bGUgaW5mb3JtYXRpb24gaXMgZGlzcGxheWVkLg0KW3Bvc3Rn
cmVzQGRiMiB+XSQgcGdfcmVzdG9yZSAtbiB3b3JrIGEub3V0ICAgICAgICAN
Ci0tDQotLSBQb3N0Z3JlU1FMIGRhdGFiYXNlIGR1bXANCi0tDQoNClNFVCBj
bGllbnRfZW5jb2RpbmcgPSAnRVVDX0NOJzsNClNFVCBjaGVja19mdW5jdGlv
bl9ib2RpZXMgPSBmYWxzZTsNClNFVCBjbGllbnRfbWluX21lc3NhZ2VzID0g
d2FybmluZzsNCg0KLS0NCi0tIFBvc3RncmVTUUwgZGF0YWJhc2UgZHVtcCBj
b21wbGV0ZQ0KLS0NCg0KDQoNCgoKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQpDb25maWRlbnRpYWxpdHkgTm90
aWNlOiBUaGUgaW5mb3JtYXRpb24gY29udGFpbmVkIGluIHRoaXMgZS1tYWls
IGFuZCBhbnkgYWNjb21wYW55aW5nIGF0dGFjaG1lbnQocykgaXMgaW50ZW5k
ZWQgb25seSBmb3IgdGhlIHVzZSBvZiB0aGUgaW50ZW5kZWQgcmVjaXBpZW50
IGFuZCBtYXkgYmUgY29uZmlkZW50aWFsIGFuZC9vciBwcml2aWxlZ2VkIG9m
IE5ldXNvZnQgR3JvdXAgTHRkLiwgaXRzIHN1YnNpZGlhcmllcyBhbmQvb3Ig
aXRzIGFmZmlsaWF0ZXMuIElmIGFueSByZWFkZXIgb2YgdGhpcyBjb21tdW5p
Y2F0aW9uIGlzIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50LCB1bmF1dGhv
cml6ZWQgdXNlLCBmb3J3YXJkaW5nLCBwcmludGluZywgc3RvcmluZywgZGlz
Y2xvc3VyZSBvciBjb3B5aW5nIGlzIHN0cmljdGx5IHByb2hpYml0ZWQsIGFu
ZCBtYXkgYmUgdW5sYXdmdWwuIElmIHlvdSBoYXZlIHJlY2VpdmVkIHRoaXMg
Y29tbXVuaWNhdGlvbiBpbiBlcnJvciwgcGxlYXNlIGltbWVkaWF0ZWx5IG5v
dGlmeSB0aGUgc2VuZGVyIGJ5IHJldHVybiBlLW1haWwsIGFuZCBkZWxldGUg
dGhlIG9yaWdpbmFsIG1lc3NhZ2UgYW5kIGFsbCBjb3BpZXMgZnJvbSB5b3Vy
IHN5c3RlbS4gVGhhbmsgeW91LiAKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KCg==

Wang Haiyong <wanghaiyong@neusoft.com> writes:
> pg_restore 8.1.0 parameter( -n)  not work¡£

This is fixed in 8.1.4.

2006-04-12 18:19  tgl

    * src/bin/pg_dump/: pg_backup_archiver.c, pg_restore.c
    (REL8_1_STABLE): Fix pg_restore -n option to do what the man page
    says it does.  The original coding only worked if one of the
    selTypes restriction options was also given.  Per report from Nick
    Johnson.

            regards, tom lane