PostgreSQL Database Dump and Restore: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 17: Line 17:
===Dump the Database===
===Dump the Database===


While the database is running (<font color=red>do we need to drop connections and prevent new connections being accepted while doing it?</font>) execute the following command"
While the database is running (<font color=red>do we need to drop connections and prevent new connections being accepted while doing it?</font>) execute the following command:


  pg_dump -U ''database-user-name'' ''database-name'' > ''database-name''-''user-name''-export.pgsql
  pg_dump -U ''database-user-name'' ''database-name'' > ''database-name''-''user-name''-export.pgsql

Revision as of 18:21, 21 December 2018

Internal

Overview

This article describes the dump and restore procedure for a PostgreSQL database. The procedure can be used in various situations, such as when the database needs to be back up, or transferred into another physical RDBMS.

Procedure

Dump the Database

Get Access to Host Database is Running On

pg_dump utility needs to run on the host the database to be dumped runs on.

Dump the Database

While the database is running (do we need to drop connections and prevent new connections being accepted while doing it?) execute the following command:

pg_dump -U database-user-name database-name > database-name-user-name-export.pgsql