Home / Repstance User Guide / 6. DATABASE CONFIGURATION COMMANDS / 7.3 Validate Source and Target Databases / 7.3.3 Validate PostgreSQL and Aurora PostgreSQL Databases

7.3.3 Validate PostgreSQL and Aurora PostgreSQL Databases

REST API:

  • Endpoint: https://repstance_url/configure/database
  • Method: POST
  • Header:
    • Content-Type: application/json
    • X-Token: token
  • Body:
    {
      "command":"validate",
      "parameters":[
         ["database","target"],
         ["dbtype","postgresql"],
         ["server","host_name"],
         ["port","port_number"],
         ["dbname","database_name"],
         ["user","db_user_name"],
         ["password","db_user_password"]
      ]
    }

Server response:

  • HTTP Status – status of the command, possible codes are:
    • 200 – if no error occurs
    • 422 – if error occurs
  • Body:
    {
     "Status":"{Valid|Invalid}",
     "Message":"The command execution details"
    }

CLI Syntax:

repcli validate database=target dbtype=postgresql \
server=databaseHost port=databasePort \
user=username password=password \
dbname=databaseName

The input parameters are:

  • database – Database role, the possible value is target – to validate Apply Process Objects
  • dbtype – Type of RDBMS, the value is postgresql
  • server – Host name or IP address of the database server
  • port – Database port
  • dbname – Database name
  • user – Database User name
  • password – Database User password