Cacher is the code snippet organizer for pro developers

If Access Denied:

Write into directory where postgres user has write access. For instance /tmp.

$ sudo su - postgres

$ pg_dump -h localhost mydb >/tmp/tempfile