Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e9Y3M-0003E8-PM for pgsql-admin@arkaria.postgresql.org; Tue, 31 Oct 2017 15:02:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e9Y3M-0008PC-AC for pgsql-admin@arkaria.postgresql.org; Tue, 31 Oct 2017 15:02:08 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e9XuP-00032Z-5A for pgsql-admin@postgresql.org; Tue, 31 Oct 2017 14:52:53 +0000 Received: from g9t5009.houston.hpe.com ([15.241.48.73]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e9XuG-0005wl-6O for pgsql-admin@postgresql.org; Tue, 31 Oct 2017 14:52:51 +0000 Received: from G4W9122.americas.hpqcorp.net (g4w9122.houston.hp.com [16.210.21.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-SHA384 (256/256 bits)) (No client certificate requested) by g9t5009.houston.hpe.com (Postfix) with ESMTPS id 9617571 for ; Tue, 31 Oct 2017 14:52:42 +0000 (UTC) Received: from G9W8455.americas.hpqcorp.net (2002:10d8:a15e::10d8:a15e) by G4W9122.americas.hpqcorp.net (2002:10d2:1511::10d2:1511) with Microsoft SMTP Server (TLS) id 15.0.1178.4; Tue, 31 Oct 2017 14:52:42 +0000 Received: from NAM03-DM3-obe.outbound.protection.outlook.com (15.241.52.12) by G9W8455.americas.hpqcorp.net (16.216.161.94) with Microsoft SMTP Server (TLS) id 15.0.1178.4 via Frontend Transport; Tue, 31 Oct 2017 14:52:42 +0000 Received: from AT5PR84MB0065.NAMPRD84.PROD.OUTLOOK.COM (10.162.137.150) by AT5PR84MB0066.NAMPRD84.PROD.OUTLOOK.COM (10.162.137.151) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256) id 15.20.178.6; Tue, 31 Oct 2017 14:52:41 +0000 Received: from AT5PR84MB0065.NAMPRD84.PROD.OUTLOOK.COM ([fe80::4cf7:8158:4f41:eabe]) by AT5PR84MB0065.NAMPRD84.PROD.OUTLOOK.COM ([fe80::4cf7:8158:4f41:eabe%13]) with mapi id 15.20.0178.014; Tue, 31 Oct 2017 14:52:41 +0000 From: "Kumar, Ram Murti" To: "pgsql-admin@postgresql.org" Subject: permission denied for schema public -need help Thread-Topic: permission denied for schema public -need help Thread-Index: AdNSV+VvmGhsneUMQ6W8wNSG93I9Ng== Date: Tue, 31 Oct 2017 14:52:41 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=ram.murti@hpe.com; x-originating-ip: [171.76.84.228] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;AT5PR84MB0066;6:5oD62sG0DIFRAPpqxm9rWcaX86UlNbqF5HJ6sns9lcNo0hREZ8QTBCp7JNR6J60TR+azNePlo3+80MZ8o53GVdkCRvu7p5ecyV5ZXB5nAPz/NAMou5h9eAf8q5LRm6hohxkrMh2g5tKvXj3i2G1S+ZDriJP5WiDjOU3K4PFURFfWg9zmSb1AM6ZZ4d39Bk9Lq0PF/w2N2JXPWWxQFaQyO6iIUVbijh5oKzbYITxC+YkKHwCWuL4DCN7iM1chLAL/qOzzpH+2+tkSRh7WwQPiR0EuorMaRhqW16bVql2LWJ5gd6ahSk7QqWONgy5fegZ+eiHqLKzGuB2Jfp+XzUOg9boI9ddKUPtkEsGTnsOthcc=;5:f2UMENDH+KX2FQOOUXXykkYzdw/esYKHWBorGTP4XRKkii6c7PKlO3upeG1MLy+xo7YrZ/bVH9HtiGbkNKmQXU/sbCahuj27mPlVGBIGqUK5EUJ329iHwc2vFDXAkVtVKvqNQDzirvFhO5g2l1emhXlctzEflG3a8YQmtM6nvSI=;24:+LktShIMIH5RiZua2i7B8l7qemoOLSGiC6Cw3IgXATaBwtKuPcOoBiBBC3Us6Ase8mMmhIis+3eglcdwZqicaM+C6ahr0Niy0oJxqW2k14k=;7:7lFr3M+QpkNtnSa4vxMZS32oNFZ2DFJBM8eTg6XISLuJftvseOu96qWMH08OrltG9wpRKitgm25PLdNBmo1Yq2bGQYnvK/BFptWWGxtSB5B7QoMOcJgt/nNRCcXwjIJUYXdsq1zI6Fhcn+NQ+CIg1xq02hK2W6QVrKAqAzck0EiTGZ2aMfcb+aH4hnpcaRWt37mA8FHWgx6pGowktbH9ZeTbTD+twL1vCPBjJiFKTZXUQixQ+1o6A3mL0q8UWwtR x-ms-exchange-antispam-srfa-diagnostics: SSOS; x-ms-office365-filtering-correlation-id: 2db5ac01-8c4a-4ac4-e918-08d5206f094c x-ms-office365-filtering-ht: Tenant x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001)(4534020)(4602075)(48565401081)(2017052603199);SRVR:AT5PR84MB0066; x-ms-traffictypediagnostic: AT5PR84MB0066: x-exchange-antispam-report-test: UriScan:(148322886591682)(31418570063057)(116415991822766)(128460861657000)(86561027422486)(81227570615382)(21748063052155)(81160342030619)(64217206974132); x-microsoft-antispam-prvs: x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(100000700101)(100105000095)(100000701101)(100105300095)(100000702101)(100105100095)(6040450)(2401047)(5005006)(8121501046)(100000703101)(100105400095)(10201501046)(93006095)(93001095)(3231020)(3002001)(6055026)(6041248)(20161123564025)(201703131423075)(201702281528075)(201703061421075)(201703061406153)(20161123558100)(20161123562025)(20161123560025)(20161123555025)(6072148)(201708071742011)(100000704101)(100105200095)(100000705101)(100105500095);SRVR:AT5PR84MB0066;BCL:0;PCL:0;RULEID:(100000800101)(100110000095)(100000801101)(100110300095)(100000802101)(100110100095)(100000803101)(100110400095)(100000804101)(100110200095)(100000805101)(100110500095);SRVR:AT5PR84MB0066; x-forefront-prvs: 04772EA191 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(346002)(376002)(39860400002)(189002)(199003)(101416001)(6916009)(3660700001)(5660300001)(7696004)(478600001)(25786009)(3280700002)(81156014)(8676002)(81166006)(316002)(189998001)(8936002)(7736002)(2501003)(14613045005)(2900100001)(33656002)(606006)(86362001)(50986999)(54356999)(53936002)(5250100002)(2906002)(66066001)(106356001)(97736004)(105586002)(2351001)(6506006)(5630700001)(9686003)(45080400002)(6436002)(74316002)(3846002)(54896002)(68736007)(6306002)(102836003)(790700001)(5640700003)(236005)(14454004)(55016002)(6116002);DIR:OUT;SFP:1102;SCL:1;SRVR:AT5PR84MB0066;H:AT5PR84MB0065.NAMPRD84.PROD.OUTLOOK.COM;FPR:;SPF:None;PTR:InfoNoRecords;MX:1;A:1;LANG:en; received-spf: None (protection.outlook.com: hpe.com does not designate permitted sender hosts) spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_AT5PR84MB0065BF579811AC0B90160F1FEF5E0AT5PR84MB0065NAMP_" MIME-Version: 1.0 X-MS-Exchange-CrossTenant-Network-Message-Id: 2db5ac01-8c4a-4ac4-e918-08d5206f094c X-MS-Exchange-CrossTenant-originalarrivaltime: 31 Oct 2017 14:52:41.1193 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 105b2061-b669-4b31-92ac-24d304d195dc X-MS-Exchange-Transport-CrossTenantHeadersStamped: AT5PR84MB0066 X-OriginatorOrg: hpe.com 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_AT5PR84MB0065BF579811AC0B90160F1FEF5E0AT5PR84MB0065NAMP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello experts , I have created AWS RDS PostgreSQL 9.4 instance but i am not able to import = the data to this instance .. when i running command like this psql -v ON_ER= ROR_STOP=3D1 -h XXXX.XXXXXXX.eu-west-1.rds.amazonaws.com -p 5432 -d opt -U = root -f myfile.pgsql to import the data ..i am getting below error ERROR: permission denied for schema public I am not database expert and i need help also i want to know which all para= meter on AWS RDS for PostgreSQL 9.4 i should modify to have good performanc= e Ram Murti Cloud Support T +91 80 61192740 M +91 8884026913 DXC Technology Sy No 30/3, Konappa Agrahara Village,Begur Hobli, Hosur Main Road Bangalore, KA - 560068 dxc.technology / Twitter / Facebook / LinkedIn= --_000_AT5PR84MB0065BF579811AC0B90160F1FEF5E0AT5PR84MB0065NAMP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello experts ,

 

I have created AWS RDS PostgreS= QL 9.4 instance but i am not able to import the data to this instance .. wh= en i running command like this psql -v ON_ERROR_STOP=3D1 -h XXXX.XXXXXXX.eu-west-1.rds.amazonaws.com -p 5432 -d opt -U root -f myfi= le.pgsql

 

to import the data ..i am getti= ng below error

 

ERROR:  permission denied for schema public

 

I am not database expert and i = need help also i want to know which all parameter on AWS RDS for PostgreSQL= 9.4 i should modify to have good performance

 

Ram Murti
Cloud Support


T +91 80 61192740
M +91 8884026913

DXC Technology
Sy No 30/3, Konappa Agrahara Village,Begur Hobli, Hosur Ma= in Road
Bangalore, KA - 560068


dxc.technology / T= witter / Facebook / LinkedIn

 

--_000_AT5PR84MB0065BF579811AC0B90160F1FEF5E0AT5PR84MB0065NAMP_--