Import PostgreSQL Database Dump File
Revision as of 13:13, 14 October 2019 by Gejor (talk | contribs) (Gejor moved page Migrate an On-Premises PostgreSQL Database to ApsaraDB RDS for PostgreSQL to Import PostgreSQL Database)
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.
