Import PostgreSQL Database Dump File

Purpose

This topic describes how to use the psql command to restore the PostgreSQL data backup files to PostGreSQL DB.

Import the Dump File

[root@gejoreuy ~]# psql -U username -h hostname -d desintationdb -p port -f dumpfilename.sql

Note :
username: The username to log on to the ApsaraDB RDS for PostgreSQL database.
hostname: The hostname of the ApsaraDB RDS for PostgreSQL database.
port: The port number of the ApsaraDB RDS for PostgreSQL database.
desintationdb: The ApsaraDB RDS for PostgreSQL database name.
dumpfilename: The name of the backup file to be restored.