/ / / Postgres Remote Access in 3CX

Postgres Remote Access in 3CX

- , Edit
We installed a 3CX PBX on a Win 2008 server. The PBX uses a Postgres  database.
We are trying to establish a remote connection with the database but it is refusing connections.
we are able to make a connection from localhost.
Any ideas and suggestions will be appreciated!
Share on Google Plus

About Johny

I am Johny, A Tech Jeannie. You can always free to ask any question related to Technology.
    Blogger Comment

3 comments:

  1. R Arya30 July 2015 at 09:24

    It sounds to me like PostgreSQL is not bound to the public IP interface of the machine. By default, PostgreSQL packages ship with a configuration that leaves the database server listening only on the internal/loopback interface.

    You can change this in the postgresql.conf, which, if this is a windows 2008, will live in: /program files/3cx phone system/DB/data/postgresql.conf

    In there is a 'listen_addresses' directives, which is probably commented
    out by default:

    #listen_addresses='*'

    The simplest thing to do is to just uncomment it and restart PostgreSQL.

    You'll also need to ensure that the ACL (Access Control List) in
    /program files/3cx phone system/DB/data/pg_hba.conf allows connections from
    the IP addresses or subnets from which you'll be connecting

    host all logsreader 0.0.0.0/0 password

    And allow port 5480 in windows 2008 firewall

    ReplyDelete
  2. Unknown19 July 2018 at 01:46

    Not Able to Access PostgreSQL Database Remotely? PostgreSQL Remote Database Service
    The PgAdmin is a free and open source GUI which is wonderfully proper for a couple of stages including Windows, Mac, Linux and OS X. The PgAdmin similarly offers server information recuperation, testing, and nonstop upkeep. However, by far most of the customers don't know how to get to the PostgreSQL database remotely with PgAdmin. Contact to Cognegic's Postgres SQL Support for Windows and Postgres SQL Support for Linux for an authentic system of PostgreSQL database remotely with PgAdmin.
    For More Info: https://cognegicsystems.com/
    Contact Number: 1-800-450-8670
    Email Address- info@cognegicsystems.com
    Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801

    ReplyDelete
  3. Kartik Sharma25 October 2019 at 20:23

    3CX Hosting in USA

    https://systmsvc.com/platform/

    Hosted Switchvox - We provide the best 3CX Hosting service for IP Office Hosting in USA. Get our help and start deploying your favorite voice applications in the cloud with switchvox hosting service.

    ReplyDelete

Subscribe to: Post Comments ( Atom )