X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id ED62011F60BF for ; Thu, 27 Apr 2006 09:06:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 05036-05 for ; Thu, 27 Apr 2006 09:06:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.187]) by postgresql.org (Postfix) with ESMTP id F37E711F60B1 for ; Thu, 27 Apr 2006 09:06:23 -0300 (ADT) Received: by nproxy.gmail.com with SMTP id b2so830870nfe for ; Thu, 27 Apr 2006 05:06:24 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=QSsSN2X9/J+mmszDOzaOguG+AXS26Ybc7yUYZkzOO4YMyIPiZA5vtRj/8H2j5P/HrEziP2Ve31D2FRyp9p3fi2ca2+rQzDlgeu/ivgFXS24RQ7E80Cn2ZFV6qw12EqivJleFWhJOZxb7PoFpQROukrf9uSAHQirG5VIudT6xBT4= Received: by 10.49.92.2 with SMTP id u2mr2546292nfl; Thu, 27 Apr 2006 05:06:24 -0700 (PDT) Received: by 10.48.216.14 with HTTP; Thu, 27 Apr 2006 05:06:24 -0700 (PDT) Message-ID: <52543fce0604270506w1a039533m5183000e610c8be9@mail.gmail.com> Date: Thu, 27 Apr 2006 14:06:24 +0200 From: "David Levy" To: "Jerry Sievers" Subject: Re: pg_restore index/trigger restoration issue Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_24752_25215797.1146139584204" References: <52543fce0604270359u7b2bac2cgd1e4cb93245bd245@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/303 X-Sequence-Number: 21472 ------=_Part_24752_25215797.1146139584204 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline SSBhbSB1c2luZyBwZ0FkbWluIGFuZCBwaHBQZ0FkbWluIHdpdGggdGhlIHNhbWUgcmVzdWx0cyAo bm8gdHJpZ2dlcnMsIG5vCmluZGV4ZXMpLgoKVGhhbmtzIGJ1dCB0aGUgZG9jcyB3ZXJlIG5vdCBo ZWxwZnVsIHlldC4gSSd2ZSBiZWVuIHRyeWluZyB0byBzb2x2ZSB0aGUKaXNzdWUgbWFueSB0aW1l cyBpbiB0aGUgcGFzdCBmZXcgbW9udGhlcyBiZWZvcmUgcG9zdGluZyB0byB0aGUgbGlzdCB0b2Rh eS4KOigKCgoKT24gMjcgQXByIDIwMDYgMDc6NDU6NTUgLTA0MDAsIEplcnJ5IFNpZXZlcnMgPGpl cnJ5QGplcnJ5c2lldmVycy5jb20+IHdyb3RlOgo+Cj4gIkRhdmlkIExldnkiIDxkdmlkLmxldnlA Z21haWwuY29tPiB3cml0ZXM6Cj4KPiA+IFNvIEkgYW0gdHJ5aW5nIHRvIHJlc3RvcmUgYSBwZ19k dW1wICh2ZXJzaW9uOC4xICkgc3FsIGR1bXAgZmlsZSBmcm9tCj4gPiBhIHJlbW90ZSA4LjAuMyBE QiBpbnRvIGEgbG9jYWwgOC4xIERCIHVzaW5nIHBnX3Jlc3RvcmUgKHZlcnNpb24KPiA+IDguMSku IElzIHRoZXJlIHNvbWV0aGluZyBpbmNvbXBhdGlibGUgVGhlIGR1bXAgZmlsZSBzZWVtcyB0byBi ZQo+ID4gY29ycmVjdCByZWdhcmRpbmcgaW5kZXggY3JlYXRpb24gc3RhdGVtZW50cyBJIHJlYWxs eSBkb24ndAo+ID4gdW5kZXJzdGFuZCB3aGF0IGlzIGhhcHBlbmluZyBBcyB0aGUgdGl0bGUgbWVu dGlvbnMsIEkgaGF2ZSB0aGUgc2FtZQo+ID4gaXNzdWUgd2l0aCB0cmlnZ2VycyA6IG5vbmUgb2Yg bXkgdHJpZ2dlcnMgYXJlIHJlc3RvcmVkIG5laXRoZXIgISBJcwo+ID4gdGhlcmUgYW55IG9wdGlv biBpbiBwZ19kdW1wIG9yIHBnX3Jlc3RvcmUgdG8gaGFuZGxlIHRoaXMKPgo+IEFueSBjaGFuY2Ug eW91ciBwc3FsIGhhZCB0aGUgXHQgKHNob3cgb25seSB0dXBsZXMpIG9wdGlvbiBzZXQ/ICBUaGlz Cj4gcHJldmVudHMgc2VlaW5nIGluZGV4ZXMgYW5kIHRyaWdzIGluIHRoZSB0YWJsZSBzY2hlbWEg bGlzdGluZy4KPgo+IEFzIGZvciB3aGF0IG9wdHMgcGdfZHVtcCBhbmQgcGdfcmVzdG9yZSBvZmZl ciwgc2VlIHRoZSBtYW51YWwuCj4KPgo+Cj4gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQo+IEplcnJ5 IFNpZXZlcnMgICAzMDUgODU0LTMwMDEgKGhvbWUpICAgICBXV1cgRUNvbW1lcmNlIENvbnN1bHRh bnQKPiAgICAgICAgICAgICAgICAgMzA1IDMyMS0xMTQ0IChtb2JpbGUgICAgaHR0cDovL3d3dy5K ZXJyeVNpZXZlcnMuY29tLwo+CgoKCi0tCkRhdmlkIExFVlkge3NlbGVuaXVtfQpXZWJzaXRlIH4g aHR0cDovL3d3dy5kYXZpZGxldnkub3JnCldpc2hsaXN0IFpMaU8gfiBodHRwOi8vZGF2aWQuemxp by5jb20vd2lzaGxpc3QKQmxvZyB+IGh0dHA6Ly9zZWxlbml1bS5ibG9nc3BvdC5jb20K ------=_Part_24752_25215797.1146139584204 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline SSBhbSB1c2luZyBwZ0FkbWluIGFuZCBwaHBQZ0FkbWluIHdpdGggdGhlIHNhbWUgcmVzdWx0cyAo bm8gdHJpZ2dlcnMsIG5vIGluZGV4ZXMpLjxicj48YnI+VGhhbmtzIGJ1dCB0aGUgZG9jcyB3ZXJl IG5vdCBoZWxwZnVsIHlldC4gSSd2ZSBiZWVuIHRyeWluZyB0byBzb2x2ZSB0aGUgaXNzdWUgbWFu eSB0aW1lcyBpbiB0aGUgcGFzdCBmZXcgbW9udGhlcyBiZWZvcmUgcG9zdGluZyB0byB0aGUgbGlz dCB0b2RheS4KPGJyPjooPGJyPjxicj48YnI+PGJyPjxkaXY+PHNwYW4gY2xhc3M9ImdtYWlsX3F1 b3RlIj5PbiAyNyBBcHIgMjAwNiAwNzo0NTo1NSAtMDQwMCwgPGIgY2xhc3M9ImdtYWlsX3NlbmRl cm5hbWUiPkplcnJ5IFNpZXZlcnM8L2I+ICZsdDs8YSBocmVmPSJtYWlsdG86amVycnlAamVycnlz aWV2ZXJzLmNvbSI+amVycnlAamVycnlzaWV2ZXJzLmNvbTwvYT4mZ3Q7IHdyb3RlOjwvc3Bhbj48 YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJib3JkZXItbGVmdDogMXB4IHNv bGlkIHJnYigyMDQsIDIwNCwgMjA0KTsgbWFyZ2luOiAwcHQgMHB0IDBwdCAwLjhleDsgcGFkZGlu Zy1sZWZ0OiAxZXg7Ij4KJnF1b3Q7RGF2aWQgTGV2eSZxdW90OyAmbHQ7PGEgaHJlZj0ibWFpbHRv OmR2aWQubGV2eUBnbWFpbC5jb20iPmR2aWQubGV2eUBnbWFpbC5jb208L2E+Jmd0OyB3cml0ZXM6 PGJyPjxicj4mZ3Q7IFNvIEkgYW0gdHJ5aW5nIHRvIHJlc3RvcmUgYSBwZ19kdW1wICh2ZXJzaW9u OC4xICkgc3FsIGR1bXAgZmlsZSBmcm9tPGJyPiZndDsgYSByZW1vdGUgOC4wLjMgREIgaW50byBh IGxvY2FsIDguMQogREIgdXNpbmcgcGdfcmVzdG9yZSAodmVyc2lvbjxicj4mZ3Q7IDguMSkuIElz IHRoZXJlIHNvbWV0aGluZyBpbmNvbXBhdGlibGUgVGhlIGR1bXAgZmlsZSBzZWVtcyB0byBiZTxi cj4mZ3Q7IGNvcnJlY3QgcmVnYXJkaW5nIGluZGV4IGNyZWF0aW9uIHN0YXRlbWVudHMgSSByZWFs bHkgZG9uJ3Q8YnI+Jmd0OyB1bmRlcnN0YW5kIHdoYXQgaXMgaGFwcGVuaW5nIEFzIHRoZSB0aXRs ZSBtZW50aW9ucywgSSBoYXZlIHRoZSBzYW1lCjxicj4mZ3Q7IGlzc3VlIHdpdGggdHJpZ2dlcnMg OiBub25lIG9mIG15IHRyaWdnZXJzIGFyZSByZXN0b3JlZCBuZWl0aGVyICEgSXM8YnI+Jmd0OyB0 aGVyZSBhbnkgb3B0aW9uIGluIHBnX2R1bXAgb3IgcGdfcmVzdG9yZSB0byBoYW5kbGUgdGhpczxi cj48YnI+QW55IGNoYW5jZSB5b3VyIHBzcWwgaGFkIHRoZSBcdCAoc2hvdyBvbmx5IHR1cGxlcykg b3B0aW9uIHNldD8mbmJzcDsmbmJzcDtUaGlzPGJyPgpwcmV2ZW50cyBzZWVpbmcgaW5kZXhlcyBh bmQgdHJpZ3MgaW4gdGhlIHRhYmxlIHNjaGVtYSBsaXN0aW5nLjxicj48YnI+QXMgZm9yIHdoYXQg b3B0cyBwZ19kdW1wIGFuZCBwZ19yZXN0b3JlIG9mZmVyLCBzZWUgdGhlIG1hbnVhbC48YnI+PGJy Pjxicj4tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCjxicj5KZXJyeSBTaWV2ZXJzJm5ic3A7Jm5ic3A7 IDMwNSA4NTQtMzAwMSAoaG9tZSkmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgV1dXIEVDb21tZXJj ZSBDb25zdWx0YW50PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOzMw NSAzMjEtMTE0NCAobW9iaWxlJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7PGEgaHJlZj0iaHR0cDov L3d3dy5KZXJyeVNpZXZlcnMuY29tLyI+aHR0cDovL3d3dy5KZXJyeVNpZXZlcnMuY29tLzwvYT48 YnI+PC9ibG9ja3F1b3RlPjwvZGl2Pjxicj48YnIgY2xlYXI9ImFsbCI+Cjxicj4tLSA8YnI+RGF2 aWQgTEVWWSB7c2VsZW5pdW19PGJyPldlYnNpdGUgfiA8YSBocmVmPSJodHRwOi8vd3d3LmRhdmlk bGV2eS5vcmciPmh0dHA6Ly93d3cuZGF2aWRsZXZ5Lm9yZzwvYT48YnI+V2lzaGxpc3QgWkxpTyB+ IDxhIGhyZWY9Imh0dHA6Ly9kYXZpZC56bGlvLmNvbS93aXNobGlzdCI+aHR0cDovL2RhdmlkLnps aW8uY29tL3dpc2hsaXN0PC9hPjxicj5CbG9nIH4gPGEgaHJlZj0iaHR0cDovL3NlbGVuaXVtLmJs b2dzcG90LmNvbSI+Cmh0dHA6Ly9zZWxlbml1bS5ibG9nc3BvdC5jb208L2E+Cg== ------=_Part_24752_25215797.1146139584204--