From: | José Pedro Santos <zpsantos1(at)hotmail(dot)com> |
---|---|
To: | Postgres Ajuda <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Dump Database |
Date: | 2014-03-20 13:35:55 |
Message-ID: | DUB110-W110DF72BF3B040149F9AAC2E07E0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2014-03-20 14:19:09 | Re: Backup WAL Replication Server |
Previous Message | François Beausoleil | 2014-03-20 13:06:20 | Re: How to access NEW or OLD field given only the field's name? |