how i can backup the database from postgres?

Question

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.

yes i can connect the database using php with my application but i would export it ?? — sara
– sara, Commented Sep 15, 2015 at 12:45
Answer below - I was reading the wrong permission into the message — LenW
– LenW, Commented Sep 15, 2015 at 16:52

user330315 · Accepted Answer · 2015-09-15 12:46:10Z

2

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"

answered Sep 15, 2015 at 12:46

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how i can backup the database from postgres?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related