On 11/09/11 11:09 AM, Bob Pawley wrote:
Opening Command Prompt as administrator solved my problem.
thats a terrible solution.
rather, you should be writing your backups to a directory that the
current user has permissions to write to. or if the directory you're
using is specifically the one
Opening Command Prompt as administrator solved my problem.
Thanks everybody.
Bob
-Original Message-
From: Raymond O'Donnell
Sent: Wednesday, November 09, 2011 10:41 AM
To: Bob Pawley
Cc: Adrian Klaver ; Guillaume Lelarge ; Postgresql
Subject: Re: [GENERAL] DB Dump
On 09/11
On 09/11/2011 18:05, Bob Pawley wrote:
I'm logged on to my computer as an administrator(and am the only user).
What other permission do I need??
Well, does the administrator have write permission to the directory?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql
On 09/11/2011 17:53, Bob Pawley wrote:
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.
Hi Bob,
It sounds as if (as Guillaume suggested) the OS user you're working
under doesn't
I'm logged on to my computer as an administrator(and am the only user). What
other permission do I need??
Bob
-Original Message-
From: Adrian Klaver
Sent: Wednesday, November 09, 2011 10:00 AM
To: Bob Pawley
Cc: Guillaume Lelarge ; Postgresql
Subject: Re: [GENERAL] DB Dump
On
On 11/09/2011 09:58 AM, Bob Pawley wrote:
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 be
--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 – “coul
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 requir
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 i
