On the sofia profiles the parameter name will be odbc-dsn not core-db-dsn.

Don't worry about the odbc in the name. It works fine with pgsql, the name just harks back to when DSNs were only for ODBC.

Steve


On 18 July 2014 09:34, Nick Zaitsev <nick.zaitsev@mail.ru> wrote:
Good day to you!
Could you advise me with Freeswitch, please?
I have load balancer (opensips) in front of 2 Freeswitch (fsw1 and fsw2) servers, each with their own hostname. The load balancing works fine, but the shared database did not work. I use PostgreSQL
I add to external and internal sip profiles and sofia.conf.xml this:
<param name="track-calls" value="true"/>
<param name="core-db-dsn" value="pgsql://hostaddr=x.x.x.x dbname=db_name user=user password='password'"/>

And to switch.conf.xml at fsw1:
<param name="switchname" value="fsw1"/>
<param name="track-calls" value="true"/>
<param name="core-db-dsn" value="pgsql://hostaddr=x.x.x.x dbname=db_name user=user password='password'"/>
<param name="core-recovery-db-dsn" value="pgsql://hostaddr=x.x.x.x dbname=db_name user=user password='password'"/>
and at fsw2 the same,except hostname.

There is not any errors, but the DB is empty.
What I do wrong? Could you help me please?
Thank you for your time,
Best Regards.

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org