Difference between revisions of "Import PostgreSQL Database Dump File"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
== Purpose == | == Purpose == | ||
Revision as of 13:12, 14 October 2019
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.
