Difference between revisions of "Import PostgreSQL Database Dump File"
Jump to navigation
Jump to search
m (Gejor moved page Import PostgreSQL Database to Import PostgreSQL Database Dump File without leaving a redirect: Renaming tittle) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 8: | Line 8: | ||
<pre> | <pre> | ||
| − | [root@gejoreuy ~]# psql -U username -h hostname -d | + | [root@gejoreuy ~]# psql -U username -h hostname -d destinationdb -p port -f dumpfilename.sql |
</pre> | </pre> | ||
Note : | Note : | ||
| − | * username: The username to log on to | + | * username: The username to log on to PostgreSQL database. |
| − | * hostname: The hostname of the | + | * hostname: The hostname of the PostgreSQL database. |
| − | * port: The port number of the | + | * port: The port number of the PostgreSQL database. |
| − | * | + | * destinationdb: The PostgreSQL database name. |
* dumpfilename: The name of the backup file to be restored. | * dumpfilename: The name of the backup file to be restored. | ||
Latest revision as of 21:47, 9 January 2020
Purpose
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.
