Menu
I have to backup a database using remote desktop connection in PGAdmin.I have installed three versions in my client machine 9.1,9.2,9.3.In server i am using 9.3.While trying to backup its showing server version mismatch error.Eventhough i have installed 9.3 version,dont know why its not working.
D:\Program Files\PostgreSQL\9.1\bin\pg_dump.exe --host 192.99.197.25 --port 5432 --username "postgres" --no-password --format custom --blobs --verbose --file "D:\V\QuartzBee dbbackup\QuartzBee_19_3_15.backup" "QuartzBee"
pg_dump: server version: 9.3.6; pg_dump version: 9.1.3
pg_dump: aborting because of server version mismatch
pg_dump: *** aborted because of error
Process returned exit code 1.
how can i change the pg_dump from 9.1 and set 9.3 as default.
877
pg_dump is a utility for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurrently. pg_dump does not block other users accessing the database (readers or writers). pg_dump only dumps a single database.
In pgAdmin, navigate to File -> Options, and under Browser -> Binary paths, change PG bin path to D:\Program Files\PostgreSQL\9.1\bin. That should make it use the 9.3 executables.
192
You can change the binaries of pg_dump. OR You can simply ignore server/utility version mismatches. Please navigate to File > Options. Then, Browser > Binary Paths. Click on the checkbox with label ignore server/utility version mismatches Refresh you database tree. It will work. Thanks
42
In pgAdmin 4, this navigation route is now:
File -> Preferences -> Paths -> Binary Paths
27
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
