PostgreSQL — pg_dump permission denied – LOCK TABLE

Check if the user running pg_dump has access to the tables.

For me, I had 2 tables owned by postgres instead of my usual user for some reason.

Check by going into psql, connecting to your DB, and typing \d

To change your table owner, type

ALTER TABLE tablename USER TO user;

1 Comment

Leave a Comment