Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g9yGo-0002XE-RQ for pgsql-sql@arkaria.postgresql.org; Tue, 09 Oct 2018 20:06:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g9yGk-0002Ns-Sl for pgsql-sql@arkaria.postgresql.org; Tue, 09 Oct 2018 20:06:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g9yGk-0002Nh-Ln; Tue, 09 Oct 2018 20:06:14 +0000 Received: from dc01pesav001.jacksonnational.com ([12.148.227.219]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g9yGb-00050R-OV; Tue, 09 Oct 2018 20:06:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=jackson.com; i=@jackson.com; q=dns/txt; s=Internal; t=1539115565; x=1570651565; h=from:to:subject:date:message-id:references:in-reply-to: content-transfer-encoding:mime-version; bh=0mWICghLcTVxOdEPeFVr5fq4T2mBFqHtBs4jLrS53sw=; b=wg/Ue4zUpc70fRQpKLwPDhpBLRlnGbqsPFO9AiofbbC/1T9gIWH0Qsl0 jLJilHZmgz8ccPRRJKLC/pR//D56CZTwa3np9/Wf311mYhV6h0guNbOAh DG9RD/BmSPqrGwAFomZ1JtCDTUg40R//Nii/N27nyflHrfNURkK2JA8ko k=; X-IronPort-AV: E=Sophos;i="5.54,361,1534824000"; d="scan'208";a="28652412" Received: from dc0xpdlpv002.jacksonnational.com (HELO DC01PXMBP003.jacksonnational.com) ([10.5.49.47]) by DC01PESAV001.jacksonnational.com with ESMTP; 09 Oct 2018 16:06:01 -0400 Received: from DC03PXMBP003.jacksonnational.com (10.12.105.32) by DC01PXMBP003.jacksonnational.com (10.8.105.32) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Tue, 9 Oct 2018 16:05:59 -0400 Received: from DC03PXMBP003.jacksonnational.com ([10.12.105.32]) by DC03PXMBP003.jacksonnational.com ([10.12.105.32]) with mapi id 15.00.1367.000; Tue, 9 Oct 2018 16:05:59 -0400 From: "Rossi, Maria" To: Laurenz Albe , "'pgsql-sql@lists.postgresql.org'" , "'pgsql-novice@lists.postgresql.org'" Subject: RE: pg_dumpall and restore Thread-Topic: pg_dumpall and restore Thread-Index: AdRf82EKpgBRUa2CQrS18+mj5Fx3JAALAOmAAAWSJQA= Date: Tue, 9 Oct 2018 20:05:59 +0000 Message-ID: <99b52306364e41068b6851db669e3db8@DC03PXMBP003.jacksonnational.com> References: <323742d3468543f590fc081c7fba0c7a@DC03PXMBP003.jacksonnational.com> <47175ca8aea768568fb51e1a91c94d436ef79d97.camel@cybertec.at> In-Reply-To: <47175ca8aea768568fb51e1a91c94d436ef79d97.camel@cybertec.at> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.12.16.10] x-tm-as-product-ver: SMEX-12.5.0.1300-8.5.1010-24146.002 x-tm-as-result: No-14.663900-5.000000-10 x-tmase-matchedrid: 6otD/cJAac27lpQUW6Uvz7iMC5wdwKqdwZLXS0hN8p0jJTYshMkID+Ga gQwUd6qhMXEn4M+GcWs2HZCtTkRx1OkA+LfAe/C6lVHM/F6YkvQHmzHO3TfA+A1xyQQ/F/PYg/5 gNr8OG71X/rAadq7WujjkL30Su/fhgpv51VMOdvbKUCo1O3wV1WQEM8vE0fkGBivPDXFZl7i7il OcyYARJ6JxQLJdv+fmWTunu1doispFqOm7OcUhtzXNObtCvUotUAjrAJWsTe8OkJQR4QWbsGnpm Y4JfJzejEUMtWWmoiRvaz8F3XoOFcjZGpIBeHfewrUhv0kAAvF9LQinZ4QefNZE3xJMmmXc+gtH j7OwNO0Q+z869mqTM9LdHHLXgng3Vl/JyJbORfnAvavyWNkAwuk9kq5J3sDUNMEnkU0hCo/FhXM jdQIJpg== x-tm-as-user-approved-sender: Yes x-tm-as-user-blocked-sender: No x-tmase-result: 10--14.663900-5.000000 x-tmase-version: SMEX-12.5.0.1300-8.5.1010-24146.002 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-CFilter-Loop: Reflected List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk VGhlIHRhYmxlICBoYXMgb25seSAyIGNvbHVtbnMsIG5hbWUgYW5kIHZhbHVlLg0KU2VsZWN0IGNv dW50KCopIGZyb20gdGFibGUxIGF0IHRoZSBvbGQgZGF0YWJhc2UgcmV0dXJuZWQgMTE1LCBvbiAg dGhlICBuZXcgZGF0YWJhc2UsIGl0IHJldHVybmVkIDExNy4gICBUaGlzIGEgc2ltcGxlIHNlbGVj dCB3aXRob3V0IGFueSBXSEVSRSBjbGF1c2UuDQpUaGFua3MuDQoNCk1hcmlhDQoNCg0KDQotLS0t LU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogTGF1cmVueiBBbGJlIDxsYXVyZW56LmFsYmVA Y3liZXJ0ZWMuYXQ+IA0KU2VudDogVHVlc2RheSwgT2N0b2JlciA5LCAyMDE4IDI6MjggUE0NClRv OiBSb3NzaSwgTWFyaWEgPG1hcmlhLnJvc3NpQGphY2tzb24uY29tPjsgJ3Bnc3FsLXNxbEBsaXN0 cy5wb3N0Z3Jlc3FsLm9yZycgPHBnc3FsLXNxbEBsaXN0cy5wb3N0Z3Jlc3FsLm9yZz47ICdwZ3Nx bC1ub3ZpY2VAbGlzdHMucG9zdGdyZXNxbC5vcmcnIDxwZ3NxbC1ub3ZpY2VAbGlzdHMucG9zdGdy ZXNxbC5vcmc+DQpTdWJqZWN0OiBSZTogcGdfZHVtcGFsbCBhbmQgcmVzdG9yZQ0KDQpFWFRFUk5B TCBFTUFJTA0KDQoNClJvc3NpLCBNYXJpYSB3cm90ZToNCj4gSSB1cGdyYWRlZCBvdXIgcG9zdGdy ZXMgZGF0YWJhc2UgIGZyb20gVjkuMyB0byBWMTAuNS4gIFVzZWQgcGdfZHVtcGFsbCB0aGVuIHJl c3RvcmUgaXQgdG8gdGhlIG5ldyAgaW5zdGFuY2UuDQo+IEFmdGVyIHRoZSByZXN0b3JlLCB3ZSBu b3RpY2UgdGhhdCAxIHRhYmxlIGhhZCBkdXBsaWNhdGUgcm93cywgc3VjaCB0aGF0IGl0IHdhcyBu b3QgYWJsZSB0byBjcmVhdGUgdGhlIHByaW1hcnkga2V5Lg0KPiBJIGNoZWNrZWQgdGhlIG9sZCBk YXRhYmFzZSwgaXQgZG9lcyBub3QgaGF2ZSB0aGUgZHVwcy4NCj4gSGFzIGFueW9uZSBlbmNvdW50 ZXJlZCAgaGF2aW5nIGR1cHMgcm93cyAgbG9hZGVkPyAgQW55IGlkZWEgIHdoYXQgY2F1c2VkIHRo aXMgYW5kIGhvdyB0byBwcmV2ZW50Pw0KPiAgDQo+IFlvdXIgaGVscCB3b3VsZCBiZSBtdWNoIGFw cHJlY2lhdGVkLg0KDQpJIGRvbid0IGJlbGlldmUgdGhhdCBwZ19kdW1wYWxsIG1pcmFjdWxvdXNs eSBkdXBsaWNhdGVkIHRoZSByb3cuDQoNCllvdSBwcm9iYWJseSAqZG8qIGhhdmUgYSBkdXBsaWNh dGUgcm93LCBhbmQgaGVuY2UgdGFibGUgY29ycnVwdGlvbiwgYnV0IEkgc3VzcGVjdCB0aGF0IG9u ZSBvZiB0aGUgcm93cyBpcyBub3QgaW4gdGhlIGluZGV4IHlvdSB1c2VkIHRvIGxvb2sgZm9yIHRo ZSByb3cuDQoNCklmIHlvdSBxdWVyeToNCg0KICAgU0VMRUNUICogRlJPTSB0YWIgV0hFUkUgaWQg PSA0MjsNCg0KdGhlIHF1ZXJ5IHdpbGwgbGlrZWx5IHVzZSB0aGUgaW5kZXggb24gImlkIiBhbmQg ZmluZCBvbmx5IG9uZSBvZiB0aGUgcm93cy4NCg0KWW91IHNob3VsZA0KDQogICBTRVQgZW5hYmxl X2luZGV4c2NhbiA9IG9mZjsNCiAgIFNFVCBlbmFibGVfaW5kZXhvbmx5c2NhbiA9IG9mZjsNCg0K YW5kIHRoZW4gcmVwZWF0IHRoZSBxdWVyeSwgc28gdGhhdCBhIHNlcXVlbnRpYWwgc2NhbiBpcyB1 c2VkLg0KDQpUbyBmaXgsIGRlbGV0ZSBvbmUgb2YgdGhlIHJvd3MgYW5kIHJlaW5kZXguDQoNCllv dSBjYW4gaWRlbnRpZnkgYSByb3cgYnkgaXRzIHR1cGxlIGlkOg0KDQogICBTRUxFQ1QgY3RpZCwg KiBGUk9NIHRhYiBXSEVSRSBpZCA9IDQyOw0KDQpZb3VycywNCkxhdXJlbnogQWxiZQ0KLS0NCkN5 YmVydGVjIHwgaHR0cHM6Ly93d3cuY3liZXJ0ZWMtcG9zdGdyZXNxbC5jb20NCg0K