Re: DB Dump
От | Bob Pawley |
---|---|
Тема | Re: DB Dump |
Дата | |
Msg-id | 1120DD530F044B45B3AA7EC77C6FE607@BobPC обсуждение исходный текст |
Ответ на | Re: DB Dump (Guillaume Lelarge <guillaume@lelarge.info>) |
Ответы |
Re: DB Dump
|
Список | pgsql-general |
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: