From: | "Bob Pawley" <rjpawley(at)shaw(dot)ca> |
---|---|
To: | "Guillaume Lelarge" <guillaume(at)lelarge(dot)info> |
Cc: | "Postgresql" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: DB Dump |
Date: | 2011-11-09 17:53:37 |
Message-ID: | A1B975A46CC0435DB27E5915CD8AA8A2@BobPC |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The file doesn't exist.
Just in case, I modified the dump to pg_dump -h localhost -p 5432 -U
postgres -v -f "PDW2_cp_Nov_2011.backup" PDW and got the same error.
Bob
-----Original Message-----
From: Guillaume Lelarge
Sent: Wednesday, November 09, 2011 9:48 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] DB Dump
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 | Bob Pawley | 2011-11-09 17:58:26 | Re: DB Dump |
Previous Message | David Kerr | 2011-11-09 17:52:01 | Re: Foreign Keys and Deadlocks |