[ckan-dev] database connection error if database on a separate server

[Thompson, Ross (STATCAN)]

> Date: Wed, 3 May 2017 09:51:30 +0000
> From: <Hildegard.GERLACH at ec.europa.eu<mailto:Hildegard.GERLACH at ec.europa.eu>>
> To: <ckan-dev at lists.okfn.org<mailto:ckan-dev at lists.okfn.org>>
> Subject: [ckan-dev] database connection error if database on a separate       server
> Message-ID:
>       <3389FFAB30EE96408E8C2058A564BF0A022E39C7 at S-DC-ESTC02-J.net1.cec.eu.int<mailto:3389FFAB30EE96408E8C2058A564BF0A022E39C7 at S-DC-ESTC02-J.net1.cec.eu.int>>
>
> Content-Type: text/plain; charset="cp1256"
>
> Dear all,
>
> I am having the following issue:
> I am setting up a production server on which I want to use the postgresql database on a separate database server instead installing it locally (with the local installations I never had this problem).
>
> I am using Ckan 2.5.1 and postgresql 9.6
> ........

We experienced a similar problem in our environment - in our situation adding the following parameter to the sqlalchemy connection string seemed to resolve the issue: "?connect_timeout=30"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20170503/dfed4d01/attachment-0003.html>