Postgres Pro
Downloads
Home   >   mailing lists

DB Dump - Mailing list pgsql-general

From Bob Pawley
Subject DB Dump
Date
Msg-id 2CD96B36894B4E829FB1DA5C2950D1D2@BobPC
Whole thread Raw
Responses Re: DB Dump  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-general
Tree view
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
 
Bob

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Foreign Keys and Deadlocks
Next
From: Carlos Mennens
Date:
Subject: Create Tables As Specific Role