Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How restore postgreSQL dump file using pgAdmin?

Tags:

sql

postgresql

pgadmin

I've a .dmp file. Want to restore the database from it. Using pgAdmin how can I do it?

like image 927
fatCop Avatar asked May 31 '15 07:05

fatCop

People also ask

How do I restore a dump file in PostgreSQL?

PostgreSQL Dump Import process can be carried out using psql command. You can use the psql utility to recover the SQL script file created by pg_dump, pg_dumpall, or any other tool that creates compatible backup files. You can run the complete script in the dump file with the psql tool.

1 Answers

Within PgAdmin3...

  • Create a new database within the server you are using.
  • Right click this database and choose 'Restore'.
  • Use the 'Browser' button to select your '.dmp' file.
  • Select 'Restore' to start restoring the database.
like image 69
Gareth Flowers Avatar answered Oct 15 '22 15:10

Gareth Flowers
Sign in to Comment

Related questions

Pandas writing dataframe to other postgresql schema
Decimal(19,4) or Decimal(19.2) - which should I use?
JSON without array wrapper on lower levels
normalizing accented characters in MySQL queries
Use AJAX to watch SQL database for changes [closed]
Pass array literal to PostgreSQL function
Stop SQL Server from running until needed [closed]
How to create Daylight Savings time Start and End function in SQL Server
Why CTE (Common Table Expressions) in some cases slow down queries comparing to temporary tables in SQL Server
How to find the name of stored procedure, based on table name search, using SQL Server 2008?
Deferrable check constraint in PostgreSQL
How to use the 'as' keyword to alias a table in Oracle?
Resetting Row number according to record data change
SQL Where not equal does not return NULL results
Spark SQL converting string to timestamp
Linq to SQL - How to find the value of the IDENTITY column after InsertOnSubmit()
MySQL: Count entries without grouping?
INSERT rows into multiple tables in a single query, selecting from an involved table
How to understand a database that is already developed? [closed]
What is {ts '2013-04-02 00:00:00'}?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!