COPY command from another droplet
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.×