Re: DB Dump

Following is a copy of the end of running the dump -

pg_dump: saving standard_conforming_strings = off
pg_dump: saving database definition
pg_dump: [archiver] could not open output file "PDW_cp_Nov_2011.backup":
Permiss
ion denied
pg_dump: *** aborted because of 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