当前位置: 动力学知识库 > 问答 > 编程问答 >

amazon ec2 - Timeout of remote connection to Postgresql

问题描述:

I have two EC2 instances, one of them needs to insert large amounts of data into a Postgresql db that lives on the other one. Incidentally it's Open Street Map data and I am using the osm2pgsql utility to insert the data, not sure if that's relevant, I don't think so.

For smaller inserts everything is fine but for very large inserts something times out after around 15 minutes and the operation fails with:

COPY_END for planet_osm_point failed: SSL SYSCALL error: Connection timed out

Is this timeout enforced by Postgresql, Ubuntu or AWS? Not too sure where to start troubleshooting.

Thanks

网友答案:

Could be caused by renegotiation. Check the log, and maybe tweak ssl_renegotiation_limit = 512MB (the default) setting it to zero will disable negotiation

分享给朋友:
您可能感兴趣的文章:
随机阅读: