Project

General

Profile

Actions

Activity #4297

open

Feature #63: DigiPatho Web -- Development, Validation, Certification and Deployment

Feature #4296: DB server upgrade

Verfiy data migration from DB server 13 to 17

Added by Thara S Pillai 10 months ago. Updated 9 months ago.

Status:
New
Priority:
Normal
Assignee:
Start date:
10/14/2025
Due date:
10/15/2025 (about 10 months late)
% Done:

96%

Estimated time:
(Total: 0:00 h)
Planned Due Date:
10/15/2025

Description

Please connect to PostgreSQL 17 server at
10.176.14.181:5533

and the following databases
DigiPatho.Global
  • dp_glo_dev
  • dp_glo_test
  • dp_glo_prod
  • dp_glo_stag
DigiPatho.Local
  • dp_loc_dev
  • dp_loc_test
  • dp_loc_prod
  • dp_loc_stag

Restored databases dp_glo_dev and dp_loc_dev

Malavika,
[1] a database level check to ensure the count of records in tables matches with existing 13 version databases in use for both .Local and .Global.
Execute
SELECT * FROM public.get_exact_table_counts() ORDER BY schema_name, table_name;

Aswathy,
[2] Have the staging applications connect to new server databases

Malavika,
[3] To test the functionality of all modules in both applications connected new server.

Please discuss if any issue exist. Once stable, the _test, _stag and _prod databases can be restored.


Subtasks 3 (3 open0 closed)

Activity #4298: Database level check to ensure the count of recordsResolvedMalavika Krishnakumar10/14/202510/15/2025

Actions
Activity #4299: Staging applications connect to server version 17 databasesResolvedAswathy M G10/14/202510/15/2025

Actions
Activity #4300: Test functionality connected to DB server 17 versionNewMalavika Krishnakumar10/14/202510/15/2025

Actions
Actions #1

Updated by Thara S Pillai 10 months ago

  • Subtask #4298 added
Actions #2

Updated by Thara S Pillai 10 months ago

  • Subtask #4299 added
Actions #3

Updated by Thara S Pillai 10 months ago

  • Subtask #4300 added
Actions

Also available in: Atom PDF