Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YxMOR-0002Vi-9l for pgsql-admin@arkaria.postgresql.org; Tue, 26 May 2015 21:28:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YxMOQ-0003Cp-PX for pgsql-admin@arkaria.postgresql.org; Tue, 26 May 2015 21:28:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YxMOP-0003B2-20 for pgsql-admin@postgresql.org; Tue, 26 May 2015 21:28:09 +0000 Received: from mgap1c-mgmt.jacksonnational.com ([12.148.227.38]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_CAMELLIA_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1YxMOJ-0007BG-E1 for pgsql-admin@postgresql.org; Tue, 26 May 2015 21:28:07 +0000 X-IronPort-AV: E=Sophos;i="5.13,501,1427774400"; d="scan'208,217";a="217751088" Received: from vtunpep1c.jacksonnational.com (HELO DC03PXMBP003.jacksonnational.com) ([10.12.111.24]) by mgap1c-mgmt.jacksonnational.com with ESMTP; 26 May 2015 17:28:00 -0400 Received: from DC01PXMBP003.jacksonnational.com (10.8.105.32) by DC03PXMBP003.jacksonnational.com (10.12.105.32) with Microsoft SMTP Server (TLS) id 15.0.1044.25; Tue, 26 May 2015 17:28:15 -0400 Received: from DC01PXMBP003.jacksonnational.com ([10.8.105.32]) by DC01PXMBP003.jacksonnational.com ([10.8.105.32]) with mapi id 15.00.1044.021; Tue, 26 May 2015 17:27:59 -0400 From: "Rossi, Maria" To: "'David G. Johnston'" CC: "'pgsql-admin@postgresql.org'" Subject: Re: refreshing a database with pg_dump and psql Thread-Topic: [ADMIN] refreshing a database with pg_dump and psql Thread-Index: AQHQl/qKViW+YVTOokSm1YZ8XTzIyJ2OxUKQ Date: Tue, 26 May 2015 21:27:58 +0000 Message-ID: References: In-Reply-To: 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.8.96.1] x-tm-as-product-ver: SMEX-11.0.0.1251-8.000.1202-21572.003 x-tm-as-result: No--48.108500-0.000000-31 x-tm-as-user-approved-sender: Yes x-tm-as-user-blocked-sender: No Content-Type: multipart/alternative; boundary="_000_ea08290421c641a0bb560409efc8124aDC01PXMBP003jacksonnati_" MIME-Version: 1.0 X-DLP-JNL: Passed X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_ea08290421c641a0bb560409efc8124aDC01PXMBP003jacksonnati_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 U29ycnksICAgSSBtZWFuIHRvIHNheSwgcmVsb2FkICB0aGUgZGF0YWJhc2UuICBEb2VzIHRoYXQg bWFrZXMgc2Vuc2U/DQoNCk1hcmlhIEEgUm9zc2kNCkRhdGFiYXNlIEFkbWluaXN0cmF0aW9uDQpQ R0RTIChVUykNCmVtYWlsOiBtYXJpYS5yb3NzaUB1cy5wZ2RzLmNvbTxtYWlsdG86bWFyaWEucm9z c2lAdXMucGdkcy5jb20+DQpjZWxsIHBob25lOiA1MTcuMjU2LjQzOTINCndvcmsgcGhvbmU6IDUx Ny4zNjcuMzA5OQ0Kd29yayBwaG9uZSBleHRlbnNpb246IDIzMDk5DQoNCkZyb206IERhdmlkIEcu IEpvaG5zdG9uIFttYWlsdG86ZGF2aWQuZy5qb2huc3RvbkBnbWFpbC5jb21dDQpTZW50OiBUdWVz ZGF5LCBNYXkgMjYsIDIwMTUgNToyNiBQTQ0KVG86IFJvc3NpLCBNYXJpYQ0KQ2M6IHBnc3FsLWFk bWluQHBvc3RncmVzcWwub3JnDQpTdWJqZWN0OiBSZTogW0FETUlOXSByZWZyZXNoaW5nIGEgZGF0 YWJhc2Ugd2l0aCBwZ19kdW1wIGFuZCBwc3FsDQoNCk9uIFR1ZXNkYXksIE1heSAyNiwgMjAxNSwg Um9zc2ksIE1hcmlhIDxtYXJpYS5yb3NzaUB1cy5wZ2RzLmNvbTxtYWlsdG86bWFyaWEucm9zc2lA dXMucGdkcy5jb20+PiB3cm90ZToNCkkgaGF2ZSBhIGRhdGFiYXNlIHRoYXQgd2FzIGNyZWF0ZWQg ZnJvbSBhIOKAmHBnX2R1bXAg4oCTQ+KAmS4gIE5vIHByb2JsZW1zIHRoZXJlLiAgVGhlbiAgSSBy YW4gdGhlIHBnX2R1bXAgIGFnYWluLCB0aGlzIHRpbWUgd2l0aG91dCB0aGUg4oCTQy4gYW5kIHRy aWVkIHRvIGxvYWQgaXQuICAgQnV0ICAgZ290IGEgYnVuY2ggb2Yg4oCYb2JqZWN0IGFscmVhZHkg ZXhpc3TigJkuDQpDYW7igJl0IEkgcmVmcmVzaCBhbiBleGlzdGluZyBkYXRhYmFzZSBmcm9tIGEg cGxhaW4gcGdfZHVtcD8gIElzICB0aGVyZSBhbiBvcHRpb24gdGhhdCBJIGhhdmUgdG8gdXNlPw0K WW91IHNob3VsZCBwcm9iYWJseSBleHBvdW5kIG9uIHdoYXQgeW91IG1lYW4gYnkgInJlZnJlc2gi Lg0KDQpEYXZpZCBKLg0K --_000_ea08290421c641a0bb560409efc8124aDC01PXMBP003jacksonnati_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ Zm9udC1zaXplOjEyLjBwdDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIixzZXJpZjt9 DQphOmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCglj b2xvcjpibHVlOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KYTp2aXNpdGVkLCBzcGFu Lk1zb0h5cGVybGlua0ZvbGxvd2VkDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xvcjpw dXJwbGU7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQpzcGFuLkVtYWlsU3R5bGUxNw0K CXttc28tc3R5bGUtdHlwZTpwZXJzb25hbC1yZXBseTsNCglmb250LWZhbWlseToiQ2FsaWJyaSIs c2Fucy1zZXJpZjsNCgljb2xvcjojMUY0OTdEO30NCi5Nc29DaHBEZWZhdWx0DQoJe21zby1zdHls ZS10eXBlOmV4cG9ydC1vbmx5Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJpIixzYW5zLXNlcmlmO30N CkBwYWdlIFdvcmRTZWN0aW9uMQ0KCXtzaXplOjguNWluIDExLjBpbjsNCgltYXJnaW46MS4waW4g MS4waW4gMS4waW4gMS4waW47fQ0KZGl2LldvcmRTZWN0aW9uMQ0KCXtwYWdlOldvcmRTZWN0aW9u MTt9DQotLT48L3N0eWxlPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVkZWZhdWx0 cyB2OmV4dD0iZWRpdCIgc3BpZG1heD0iMTAyNiIgLz4NCjwveG1sPjwhW2VuZGlmXS0tPjwhLS1b aWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVsYXlvdXQgdjpleHQ9ImVkaXQiPg0KPG86aWRt YXAgdjpleHQ9ImVkaXQiIGRhdGE9IjEiIC8+DQo8L286c2hhcGVsYXlvdXQ+PC94bWw+PCFbZW5k aWZdLS0+DQo8L2hlYWQ+DQo8Ym9keSBsYW5nPSJFTi1VUyIgbGluaz0iYmx1ZSIgdmxpbms9InB1 cnBsZSI+DQo8ZGl2IGNsYXNzPSJXb3JkU2VjdGlvbjEiPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+ PGEgbmFtZT0iX01haWxFbmRDb21wb3NlIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtm b250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RCI+ U29ycnksJm5ic3A7Jm5ic3A7IEkgbWVhbiB0byBzYXksIHJlbG9hZCZuYnNwOyB0aGUgZGF0YWJh c2UuJm5ic3A7IERvZXMgdGhhdCBtYWtlcyBzZW5zZT8NCjxvOnA+PC9vOnA+PC9zcGFuPjwvYT48 L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtm b250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RCI+ PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PGI+PHNw YW4gc3R5bGU9ImZvbnQtc2l6ZToxMC4wcHQ7Y29sb3I6dGVhbCI+TWFyaWEgQSBSb3NzaTwvc3Bh bj48L2I+PHNwYW4gc3R5bGU9ImNvbG9yOiMxRjQ5N0QiPjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4N CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTAuMHB0O2NvbG9y OiMxRjQ5N0QiPkRhdGFiYXNlIEFkbWluaXN0cmF0aW9uPC9zcGFuPjxzcGFuIHN0eWxlPSJjb2xv cjojMUY0OTdEIj48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48 c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwLjBwdDtjb2xvcjojMUY0OTdEIj5QR0RTIChVUyk8L3Nw YW4+PHNwYW4gc3R5bGU9ImNvbG9yOiMxRjQ5N0QiPjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxw IGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTAuMHB0O2NvbG9yOiMx RjQ5N0QiPmVtYWlsOiA8L3NwYW4+PGEgaHJlZj0ibWFpbHRvOm1hcmlhLnJvc3NpQHVzLnBnZHMu Y29tIiB0aXRsZT0ibWFpbHRvOm1hcmlhLnJvc3NpQHVzLnBnZHMuY29tIj48c3BhbiBzdHlsZT0i Zm9udC1zaXplOjEwLjBwdCI+bWFyaWEucm9zc2lAdXMucGdkcy5jb208L3NwYW4+PC9hPjxzcGFu IHN0eWxlPSJmb250LXNpemU6MTAuMHB0O2NvbG9yOiMxRjQ5N0QiPjxicj4NCmNlbGwgcGhvbmU6 IDUxNy4yNTYuNDM5Mjwvc3Bhbj48c3BhbiBzdHlsZT0iY29sb3I6IzFGNDk3RCI+PG86cD48L286 cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6 ZToxMC4wcHQ7Y29sb3I6IzFGNDk3RCI+d29yayBwaG9uZTogNTE3LjM2Ny4zMDk5PGJyPg0Kd29y ayBwaG9uZSBleHRlbnNpb246IDIzMDk5PC9zcGFuPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEu MHB0O2ZvbnQtZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMUY0 OTdEIj48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBz dHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNh bnMtc2VyaWY7Y29sb3I6IzFGNDk3RCI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHAg Y2xhc3M9Ik1zb05vcm1hbCI+PGI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1m YW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmIj5Gcm9tOjwvc3Bhbj48L2I+PHNw YW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90 OyxzYW5zLXNlcmlmIj4gRGF2aWQgRy4gSm9obnN0b24gW21haWx0bzpkYXZpZC5nLmpvaG5zdG9u QGdtYWlsLmNvbV0NCjxicj4NCjxiPlNlbnQ6PC9iPiBUdWVzZGF5LCBNYXkgMjYsIDIwMTUgNToy NiBQTTxicj4NCjxiPlRvOjwvYj4gUm9zc2ksIE1hcmlhPGJyPg0KPGI+Q2M6PC9iPiBwZ3NxbC1h ZG1pbkBwb3N0Z3Jlc3FsLm9yZzxicj4NCjxiPlN1YmplY3Q6PC9iPiBSZTogW0FETUlOXSByZWZy ZXNoaW5nIGEgZGF0YWJhc2Ugd2l0aCBwZ19kdW1wIGFuZCBwc3FsPG86cD48L286cD48L3NwYW4+ PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFz cz0iTXNvTm9ybWFsIj5PbiBUdWVzZGF5LCBNYXkgMjYsIDIwMTUsIFJvc3NpLCBNYXJpYSAmbHQ7 PGEgaHJlZj0ibWFpbHRvOm1hcmlhLnJvc3NpQHVzLnBnZHMuY29tIj5tYXJpYS5yb3NzaUB1cy5w Z2RzLmNvbTwvYT4mZ3Q7IHdyb3RlOjxvOnA+PC9vOnA+PC9wPg0KPGJsb2NrcXVvdGUgc3R5bGU9 ImJvcmRlcjpub25lO2JvcmRlci1sZWZ0OnNvbGlkICNDQ0NDQ0MgMS4wcHQ7cGFkZGluZzowaW4g MGluIDBpbiA2LjBwdDttYXJnaW4tbGVmdDo0LjhwdDttYXJnaW4tcmlnaHQ6MGluIj4NCjxkaXY+ DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCIgc3R5bGU9Im1zby1tYXJnaW4tdG9wLWFsdDph dXRvO21zby1tYXJnaW4tYm90dG9tLWFsdDphdXRvIj5JIGhhdmUgYSBkYXRhYmFzZSB0aGF0IHdh cyBjcmVhdGVkIGZyb20gYSDigJhwZ19kdW1wIOKAk0PigJkuJm5ic3A7IE5vIHByb2JsZW1zIHRo ZXJlLiZuYnNwOyBUaGVuJm5ic3A7IEkgcmFuIHRoZSBwZ19kdW1wJm5ic3A7IGFnYWluLCB0aGlz IHRpbWUgd2l0aG91dCB0aGUg4oCTQy4gYW5kIHRyaWVkIHRvIGxvYWQgaXQuJm5ic3A7ICZuYnNw O0J1dCZuYnNwOyZuYnNwOyBnb3QgYSBidW5jaA0KIG9mIOKAmG9iamVjdCBhbHJlYWR5IGV4aXN0 4oCZLiZuYnNwOyAmbmJzcDs8bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiIHN0 eWxlPSJtc28tbWFyZ2luLXRvcC1hbHQ6YXV0bzttc28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0byI+ Q2Fu4oCZdCBJIHJlZnJlc2ggYW4gZXhpc3RpbmcgZGF0YWJhc2UgZnJvbSBhIHBsYWluIHBnX2R1 bXA/Jm5ic3A7IElzICZuYnNwO3RoZXJlIGFuIG9wdGlvbiB0aGF0IEkgaGF2ZSB0byB1c2U/PG86 cD48L286cD48L3A+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9ibG9ja3F1b3RlPg0KPGRpdj4NCjxwIGNs YXNzPSJNc29Ob3JtYWwiPllvdSBzaG91bGQgcHJvYmFibHkgZXhwb3VuZCBvbiB3aGF0IHlvdSBt ZWFuIGJ5ICZxdW90O3JlZnJlc2gmcXVvdDsuPG86cD48L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+ DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRp dj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkRhdmlkIEouPG86cD48L286cD48L3A+DQo8L2Rpdj4N CjwvZGl2Pg0KPC9ib2R5Pg0KPC9odG1sPg0K --_000_ea08290421c641a0bb560409efc8124aDC01PXMBP003jacksonnati_--