| From: | "Kumar, Ram Murti" <ram(dot)murti(at)dxc(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | permission denied for schema public -need help |
| Date: | 2017-10-31 14:52:41 |
| Message-ID: | AT5PR84MB0065BF579811AC0B90160F1FEF5E0@AT5PR84MB0065.NAMPRD84.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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_ERROR_STOP=1 -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 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 Main Road
Bangalore, KA - 560068
dxc.technology<http://www.dxc.technology/> / Twitter<https://twitter.com/dxctechnology> / Facebook<https://www.facebook.com/DXCTechnology/> / LinkedIn<https://www.linkedin.com/company/dxctechnology>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | rammohan ganapavarapu | 2017-10-31 18:10:13 | Re: Postgresql Upgrade from 9.3 to 9.4 failing |
| Previous Message | Stephen Frost | 2017-10-31 11:47:56 | Re: Bad recovery: no pg_xlog/RECOVERYXLOG |