Re: Dump Database

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: dennis(at)kabonkulator(dot)com
To: pgsql-general(at)postgresql(dot)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-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)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