[ADMIN] permission denied for schema public -need help

Поиск
Список
Период
Сортировка
От Kumar, Ram Murti
Тема [ADMIN] permission denied for schema public -need help
Дата
Msg-id AT5PR84MB0065BF579811AC0B90160F1FEF5E0@AT5PR84MB0065.NAMPRD84.PROD.OUTLOOK.COM
обсуждение исходный текст
Список 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 / Twitter / Facebook / LinkedIn

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: [ADMIN] Bad recovery: no pg_xlog/RECOVERYXLOG
Следующее
От: rammohan ganapavarapu
Дата:
Сообщение: Re: [ADMIN] Postgresql Upgrade from 9.3 to 9.4 failing