Re: Dump Database - Mailing list pgsql-general

From José Pedro Santos
Subject Re: Dump Database
Date
Msg-id DUB110-W110DF72BF3B040149F9AAC2E07E0@phx.gbl
Whole thread Raw
In response to Re: Dump Database  ("Dennis" <dennis@kabonkulator.com>)
List pgsql-general
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@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-owner@postgresql.org [mailto:pgsql-general-owner@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

pgsql-general by date:

Previous
From: François Beausoleil
Date:
Subject: Re: How to access NEW or OLD field given only the field's name?
Next
From: Michael Paquier
Date:
Subject: Re: Backup WAL Replication Server