Re: Dump Database

[José Pedro Santos <zpsantos1@xxxxxxxxxxx>]

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@xxxxxxxxxxxxxxxx
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: 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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of José Pedro Santos
Sent: Monday, March 17, 2014 7:50 AM
To: Postgres Ajuda
Subject: 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