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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
