Getting "Access is denied" error when executing pg_dump on Windows

postgresql pg-dump
goh picture goh · Jul 23, 2010 · Viewed 14.9k times · Source

I'm trying to execute pg_dump for one of my PostgreSQL databases, but I am having permission problems.

C:\Windows\system32>pg_dump -U postgres -p 1863 -O social_sense > C:\\Program Files\\PostgreSQL\\8.4\\data\\social_sense.sql


I am getting the following error:

Access is denied


Can anyone enlighten?

Answer

goh picture goh · Jul 23, 2010

I apologise for taking up your time. It was due to that there is no write permission to the directory i was writing to.

Related questions

Postgresql 9.2 pg_dump version mismatch

I am trying to dump a Postgresql database using the pg_dump tool. $ pg_dump books > books.out How ever i am getting this error. pg_dump: server version: 9.2.1; pg_dump version: 9.1.6 pg_dump: aborting because of server version …

Read More
How to create a backup of a single table in a postgres database?

Is there a way to create a backup of a single table within a database using postgres? And how? Does this also work with the pg_dump command?

Read More
How do I do a schema only backup and restore in PostgreSQL?

How do I take a schema level backup in PostgreSQL database and restore on the another database? Is there any single command available for this? For example, can I pg_dump and restore in single line?

Read More