1 Reply Latest reply on Apr 26, 2021 2:05 AM by Harsha Kaknani

    Accessing PostgreSQL For Axon

    Maurya Bellapukonda New Member
    Maurya Bellapukonda Jan 2, 2021 9:22 PM

      1) Is there any way that we can integrate Axon PostgreSQL database with other analytical tools (power BI, Tableau?

      2) How to transfer Axon PostgreSQL database backup to other SQL database?

      • 87 Views
      • Tags:
        • 1. Re: Accessing PostgreSQL For Axon
          Harsha Kaknani Active Member
          Harsha Kaknani Apr 26, 2021 2:05 AM (in response to Maurya Bellapukonda)

          Hi Maurya,

          1. Currently , we cannot integrate Axon Postgres with other Analytical tools.

          2. In order to transfer Axon Postgresql backup, you can generate the Postgres .SQL file from the Axon Server using the steps mentioned below :


          a. Go to <INSTALLATION_DIR>/scripts and run the following command to back up the database:

          sh axon_db_backup.sh <BACKUP_DESTINATION_DIR>

           


          b. Go to the backup destination directory to verify that the database backup file has been created. The database backup is an SQL file with the timestamp:

           

          <BACKUP_DESTINATION_DIR>/<backup_sql_file>

           

          For example, your backup file might look like this: <BACKUP_DESTINATION_DIR>/postgres_2020_11_18_025744.sql