COPY command from another droplet

Posted April 7, 2020 421 views

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.

Submit an Answer
1 answer

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