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

[Hildegard.GERLACH at ec.europa.eu]

Thanks Karen. Your answer seems to have resolved my problem. That's how we changed the parameters in the Postgres configuration file. Just in case, anyone encounters the same problem.

tcp_keepalives_idle = 30 # TCP_KEEPIDLE
tcp_keepalives_interval = 30 # TCP_KEEPINTVL

Cheers
Hilde
________________________________________
From: ckan-dev [ckan-dev-bounces at lists.okfn.org] on behalf of Karen Turner [karen at catalyst.net.nz]
Sent: 04 May 2017 23:12
To: CKAN Development Discussions
Subject: Re: [ckan-dev] database connection error if database on a separate server

Hi

We use a setup where postgres and solr are on a second server.
One thing to check is whether your web server and database server are
separated by a firewall.  In our case the firewall was silently dropping
the connection and CKAN didn't handle this and we would have to restart
all the processes.
The fix was to shorten the  keepalive in the Posgres configuration.

Cheers
 Karen

On 05/05/17 00:26, Hildegard.GERLACH at ec.europa.eu wrote:
> Unfortunately it didn't solve my problem. It still gives me a server
> error after a while connecting again (opening whatever page).
> Is there anything which needs to be set on the database server ?
>
> Is anyone using an external database or is this not recommended ?
>
> Thank you.
>
> Hilde
>

_______________________________________________
ckan-dev mailing list
ckan-dev at lists.okfn.org
https://lists.okfn.org/mailman/listinfo/ckan-dev
Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev