postgresql - 来自 aws-rds 实例的 postgres 数据库转储

Question

我正在尝试使用以下命令通过 ubunutu 终端从 postgress aws-rds 实例导出数据库转储，但出现抛出错误。

pg_dump -h XX.XXXXXXXX.us-east-1.rds.amazonaws.com:5432 -Fc -o -U XXUser XXDbname > output.dump
pg_dump: [archiver (db)] connection to database "XXDbname" failed: could not translate host name "XX.XXXXXXXX.us-east-1.rds.amazonaws.com:5432" to address: Name or service not known

我也尝试使用 sql 查询来查找 ip 地址选择 inet_server_addr()

当我使用这个 ip 运行 pg_dump 命令时。它抛出连接超时。请建议有没有一种方法可以从 rds-postgress 实例导出转储，同时只有数据库用户访问权限。

Update - tried with -p port too. But still same error

pg_dump -h XX.31.X.X -p 5432 -Fc -o -U XXuser XXdb > XXdump.dump

pg_dump: [archiver (db)] connection to database "XXdb" failed: could not connect to server: Connection timed out Is the server running on host "XX.31.X.X" and accepting TCP/IP connections on port 5432?

Answer 1

您不应在主机名中包含端口，而应使用 -p 选项指定它。

所以代替

-h XX.XXXXXXXX.us-east-1.rds.amazonaws.com:5432

使用

-h XX.XXXXXXXX.us-east-1.rds.amazonaws.com -p 5432