I have a setup with an auto configured Postgres database, and a regular droplet ubuntu server.
I wish to copy a file from the server to the postgres db. However when I run the sql command
COPY table name from file.csv
It results with the error: must be superuser or a member of the pgreadserver_files role to COPY from a file
I am connected to the db with the default created user in the postgres db (doadmin) I cannot use the command line to connect a superuser through my other droplet, I have the: must be superuser to alter superusers when trying to setup doadmin as a superuser…
How can I proceed?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

https://www.digitalocean.com/community/questions/managed-postgres-clusters-pg_restore-errors-for-superuser-privileges

looking at this thread it seems that, the doadmin user i was using is not superuser. will create my own postgres

Submit an Answer