Re: 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