pg_dump:如何在适用于PostgreSQL 9.5.2的Amazon Linux上安装? [英] pg_dump: how to install on Amazon Linux for PostgreSQL 9.5.2?
本文介绍了pg_dump:如何在适用于PostgreSQL 9.5.2的Amazon Linux上安装?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我曾经安装并执行以下操作:
$ sudo yum install -y postgresql94-server postgresql94
$ pg_dump -h db.us-east-1.rds.amazonaws.com的名称-U用户dbName>转储
在RDS升级到9.5.2之后,我得到了:
pg_dump:服务器版本:9.5.2; pg_dump版本:9.4.5
pg_dump:由于服务器版本不匹配而终止
我可以找不到适用于Amazon Linux的软件包
这对我没有帮助: http://tecadmin.net/install-postgresql-9-5-on-centos/
可以吗?
解决方案
好,找到它。
( 1)安装仓库:
$ sudo rpm -Uvh https://download.postgresql.org/pub/repos/yum /9.5/redhat/rhel-6-x86_64/pgdg-ami201503-95-9.5-3.noarch.rpm
-更新:9.5.2-> 9.5.3
找到了仓库此处。
(2)然后安装软件包:
$ sudo yum install postgresql95
现在您可以转储您的RDS数据库到EC2实例附近! p>
I used to install and do:
$ sudo yum install -y postgresql94-server postgresql94
$ pg_dump -h name-of-db.us-east-1.rds.amazonaws.com -U user dbName > dump
After RDS upgrade to 9.5.2 I get this:
pg_dump: server version: 9.5.2; pg_dump version: 9.4.5
pg_dump: aborting because of server version mismatch
I can't find a proper package for Amazon Linux
This didn't help me: http://tecadmin.net/install-postgresql-9-5-on-centos/
Can you?
解决方案
Ok, found it.
(1) Install the repo:
$ sudo rpm -Uvh https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6-x86_64/pgdg-ami201503-95-9.5-3.noarch.rpm
- Update: 9.5.2-> 9.5.3 Found the repo here.
(2) Then install the package:
$ sudo yum install postgresql95
Now you can dump your RDS database to a near by ec2 instance!
这篇关于pg_dump:如何在适用于PostgreSQL 9.5.2的Amazon Linux上安装?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文