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

[Karen Turner]

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
>