Doubt with backup postgres?

Asked

Viewed 1,180 times

2

I have on the same machine a Postgresql 9.0 server and also a Postgresql 9.4, I have a database in this latest version, when I try to make a backup I have the following error, as it could solve this problem?

C:/Program Files/Postgresql/9.0/bin pg_dump.exe --host localhost -port 5432 --username "postgres" -format custom --blobs --encoding UTF8 --verbose --file "D: bck_hospi.backup" "hospi" pg_dump: version of server: 9.4.1; pg_dump version: 9.0.19 pg_dump: aborting because the server version does not match pg_dump: **broken because of error

Process returned Exit code 1.

postgresql
  • 3

    the error message indicates that you are trying to backup the server with version 9.4 from pg_dump.exe version 9.0, maybe use pg_dump.exe of version 9.4 solve the problem

  • Yes, that I already knew! I have found a solution to the problem! thank you!

  • Vote today! Vote tomorrow! Vote forever! Vote consciously! Your vote is very important to our community, contribute to us, and help make Stack Overflow in Portuguese (Sopt) bigger and bigger. You can learn more at: Vote early, vote often

  • Take a look at my question and see if it helps you https://answall.com/questions/168698/como-realizar-backup-de-uma-base-data-baseos-postgresql-atrav%C3%a9s-do-pgadmin-4

1 answer

1

As answered in the comments by @sanction:

"The error message indicates that you are trying to back up the server with version 9.4 from the pg_dump.exe version 9.0, maybe use the pg_dump.exe of version 9.4 solve the problem."

Browser other questions tagged postgresql

You are not signed in. Login or sign up in order to post.