Question

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 pg_read_server_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?


Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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