| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
| Cc: | Postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: DB Dump |
| Date: | 2011-11-09 17:48:07 |
| Message-ID: | 1320860888.2120.13.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2011-11-09 at 08:58 -0800, Bob Pawley wrote:
> Hi
>
> PostgreSQL v9.0
> Win 7
>
> I am using the following to dump a database.
>
> I get an error – “could not open output file “.........backup”. Permission denied.”
>
> To me, this sounds as if I am required to create an output file in order to get an output file.
>
> In previous versions the output file was created as part of the transaction.
>
> What am I missing?
>
> pg_dump -h localhost -p 5432 -U postgres -v -f "PDW_cp_Nov_2011.backup" PDW
>
I suppose it means that the "PDW_cp_Nov_2011.backup" file already exists
but the OS user executing pg_dump has no right to overwrite it.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2011-11-09 17:49:39 | Re: Create Tables As Specific Role |
| Previous Message | Carlos Mennens | 2011-11-09 17:20:13 | Create Tables As Specific Role |