I am working with confuence under Windows 8.1 and have produced a lot of Input there.
Now I wanted to backup my PostgreSQL 9.4 database with pgAdmin 3.
I get the error:
C:\Program Files (x86)\pgAdmin III\1.18\pg_dump.exe --host localhost --port 5432 --username "postgres" --no-password --format custom --blobs --verbose --file "C:\Users\milenko\Desktop\output.backup" "confluence"
pg_dump: server version: 9.4.1; pg_dump version: 9.3.1
pg_dump: aborting because of server version mismatch
Do you know a solution?
Connecting to a Database with pgAdmin IIIAfter running OpenVPN as administrator and establishing a connection you should also run pgAdmin III. Establish a new connection from File -> Add Server… menu (the first icon in the toolbar). Enter the details to connect to the database in the New Server Registration window.
You can backup a single table, a schema, or a complete database. Select the name of the backup source in the pgAdmin tree control, right click to open the context menu, and select Backup… to open the Backup dialog. The name of the object selected will appear in the dialog title bar.
You need to tell pgAdmin to use the 9.4 binaries, through the "Binary paths" section in the options dialog:
https://www.pgadmin.org/docs/pgadmin3/1.22.2/options-browser.html
your pgAdmin version is a bit old as well. 1.20 ships with Postgres 9.4, not 1.18
Also I found very effective to just replace pg_dump.exe in pgadmin version folder with my pg_dump.exe from my Postgres database.
I see why the solution above is better, but if someone would have problems with that, this also seems like functional alternative.
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