Granting privileges to ALL objects in a database - Postgres

Question

Hi folks,

I'm trying to backup my database with:

pg_dump my_database > backup.sql

unfortunately there are no privileges set for many objects in the database,

therefore the command does not work!

---

Furthermore this does not grant privileges as expected:

GRANT ALL ON DATABASE my_database TO root

---

Any ideas?

Answer 1

If you need to dump entire database much simpler solution is working as a superuser (postres by default). Isn't it an option?

pg_dump -U postgres my_database > backup.sql

Answer 2

I have the same problem v8.4