Import PostgreSQL Database Dump File

From Gejoreuy
Jump to navigation Jump to search


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

Import the Dump File

Just run below command and change it with the database value.

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

Note :

  • username: The username to log on to PostgreSQL database.
  • hostname: The hostname of the PostgreSQL database.
  • port: The port number of the PostgreSQL database.
  • destinationdb: The PostgreSQL database name.
  • dumpfilename: The name of the backup file to be restored.