Using psql Command

If your data is already on PostgreSQL, you can easily migrate it to TencentDB for PostgreSQL by using the psql command.
Data migration mainly involves two parts:

1. Perform logical backup by using the pg_dump command to create dump data.
2. Restore the backup data to TencentDB for PostgreSQL.
   Preparation: get the PostgreSQL instance ready. If not, please see the operation guide on applying for an instance and connecting to it.

Step 1

Connect to the local database by using the PostgreSQL client and run the following command to back up the data.

pg_dump -U username -h hostname -p port -d databasename -f filename

Descriptions of parameters:

Step 2

Preparation: upload the backup data to the CVM instance in the same private network and then restore the data over the private network, which helps ensure network stability and data security.
After you log in to the CVM instance, run the following command on the PostgreSQL client to restore the data.

psql -U username -h hostname -d desintationdb -p port -f dumpfilename

Descriptions of parameters: