pg_dump报错aborting because of server version mismatch的解决办法

pg_dump命令用法

https://www.postgresql.org/docs/9.3/app-pgdump.html

// pg_dump -h [host] -U [username] [db name] > dumpfile
$ pg_dump -O --inserts -h pinpoint.c3ymkme5.us-east-1.rds.amazonaws.com -U postgres pinpoint > db-prod.sql
pg_dump: server version: 11.6; pg_dump version: 10.12 (Ubuntu 10.12-0ubuntu0.18.04.1)
pg_dump: aborting because of server version mismatch
pg_dump的版本与postgres的版本不一致

https://wiki.postgresql.org/wiki/Apt

$ sudo apt-get install curl ca-certificates gnupg
$ curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
$ sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
$ sudo apt-get update
$ sudo apt-get install postgresql-client-11
————————————————
版权声明:本文为CSDN博主「worldzhy」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/worldzhy/article/details/106202523

发表评论

后才能评论