CODEWITHSUNDEEP
postgresqlpg-dump
sara
sara

Reputation: 41

how i can backup the database from postgres?

I'm trying to back up the database from Postgres but: 

C:/Program Files (x86)/PostgreSQL/9.3/bin\pg_dump.exe --host localhost --port 5432 --username "postgres" --no-password  --format custom --blobs --verbose --file "projet" "postgis_21_sample"
    pg_dump: [custom archiver] could not open output file "projet": Permission denied

    Process returned exit code 1.

Upvotes: 0

Views: 1309

Answers (1)

user330315
user330315

Reputation:

You are trying to write the backup file to C:/Program Files (x86)/PostgreSQL/9.3/bin which is not writable for regular users (for a good reason).

You need to supply a file location that is writable for your current user, e.g. 

--file "c:/Users/sara/projet"

Upvotes: 2

Related Questions