This guide will assist you in migrating to the new CNPG operator.

Prerequisites

Install PGAdmin form the TrueCharts Stable train.
Setup [tcdbinfo.sh script](<https://truecharts.org/manual/SCALE/guides/sql-export#how-to-list-database-login-info-for-truecharts-apps>)
Add the Operator train to your TrueCharts Catalog

https://prod-files-secure.s3.us-west-2.amazonaws.com/00ca13a9-3fa4-4fd5-a345-67a1f89ff832/48589c9b-cd24-42ea-a86c-00e5c9f0025f/cnpg-add-operator-train-315ce8e8dd6afbfc771a0c5967da085b.png

Acquire Database Credentials

  1. Run tcdbinfo.sh to get a list of database credentials.
bash tcdbinfo.sh

https://prod-files-secure.s3.us-west-2.amazonaws.com/00ca13a9-3fa4-4fd5-a345-67a1f89ff832/76513d55-0cc7-4585-9147-1aefa28b196b/cnpg-info-87e9502f29764e6efadf9f85e8ed4d24.png

Connect to CNPG Databases in PGAdmin

  1. Click Add Server.

https://prod-files-secure.s3.us-west-2.amazonaws.com/00ca13a9-3fa4-4fd5-a345-67a1f89ff832/2b14686b-2d2c-4426-b765-b93c67f02d3f/cnpg-pgadmin-add-c57c1672cc3ba1066fdba539e98c5adb.png

  1. Choose a name for the database, this will only be used to help you identify it.

https://prod-files-secure.s3.us-west-2.amazonaws.com/00ca13a9-3fa4-4fd5-a345-67a1f89ff832/cbfc843e-582b-474b-941a-7cb54c49da3a/cnpg-pgadmin-name-81a2590a51dd3492e584d0093198939a.png

Enter database server and credentials previously acquired from tcdbinfo.sh script and save.

https://prod-files-secure.s3.us-west-2.amazonaws.com/00ca13a9-3fa4-4fd5-a345-67a1f89ff832/4293b4eb-2479-4c9e-82fe-352f25538c1b/cnpg-pgadmin-creds-bfa33524052f771ab898bccb816de6c3.png

Backup CNPG Databases

  1. Right click on the database and select backup as shown below.

https://prod-files-secure.s3.us-west-2.amazonaws.com/00ca13a9-3fa4-4fd5-a345-67a1f89ff832/063ed809-e33a-4592-bec9-076c64821881/cnpg-pgadmin-backup-90134a9ca7307878c7bf88a3957d0ffb.png