When executing the postgres copy command in a terminal, postgres shows the following error: ERROR: must be superuser or a member of the pg_read_server_files role to COPY from a file HINT: Anyone can COPY to stdout or from stdin. psql’s Leer más
postgres install extensions (pgcrypto) without giving the application superuser rights
In this example, I’m going to install the pgcrypto extension to be able to generate UUID data type. Procedure 1. Access as Postgres superuser. By default, it is the postgres user. sudo su – postgres 2. Access to the database Leer más