Hi Dennis, I already manage. The problem as because I wasn't in the right folder...rookie mistake.
Thank you for your email. Regards, José Santos From: den...@kabonkulator.com To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Dump Database Date: Mon, 17 Mar 2014 08:14:03 -0500 What does the shell command: pwd show when run immediately after you issue a su postgres command? You may want to try su - postgres to ensure you are in the postgres users home directory. From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of José Pedro Santos Sent: Monday, March 17, 2014 7:50 AM To: Postgres Ajuda Subject: [GENERAL] Dump Database Dear all, I'm trying to dump my database using the following command after I enter as su postgres: pg_dump - U postgres mydb -f mydb.sql ... but I'm always having the following message: pg_dump [archiver] Could not open output file "mydb.sql" : Permission denied I try to use the same statement using su.. but I didn't manage. Can someone give me a help? I'm using Ubuntu 12.04 LTS and Postgres 9.1. Kind Regards, José Santos
