Corner cubicle

Thursday, April 24, 2014

How to back up & restore postgres database?

pg_dump is the functionality  provided by Postgres to take the backup of database

Usage:
If the intent is create database while restoring 
pg_dump -f <fileName> -U <user name> --create <databaseName>
Posted by abhinav at 9:54 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2017 (1)
    • ►  February (1)
      • ►  Feb 05 (1)
  • ►  2016 (41)
    • ►  December (12)
      • ►  Dec 15 (2)
      • ►  Dec 10 (2)
      • ►  Dec 06 (1)
      • ►  Dec 05 (2)
      • ►  Dec 03 (1)
      • ►  Dec 02 (3)
      • ►  Dec 01 (1)
    • ►  November (1)
      • ►  Nov 04 (1)
    • ►  October (7)
      • ►  Oct 31 (1)
      • ►  Oct 30 (1)
      • ►  Oct 29 (1)
      • ►  Oct 28 (2)
      • ►  Oct 21 (1)
      • ►  Oct 01 (1)
    • ►  September (19)
      • ►  Sep 30 (1)
      • ►  Sep 25 (1)
      • ►  Sep 24 (1)
      • ►  Sep 14 (2)
      • ►  Sep 12 (4)
      • ►  Sep 11 (1)
      • ►  Sep 10 (1)
      • ►  Sep 09 (1)
      • ►  Sep 08 (1)
      • ►  Sep 07 (1)
      • ►  Sep 05 (1)
      • ►  Sep 04 (3)
      • ►  Sep 03 (1)
    • ►  August (2)
      • ►  Aug 27 (2)
  • ▼  2014 (17)
    • ►  September (1)
      • ►  Sep 12 (1)
    • ►  June (2)
      • ►  Jun 21 (1)
      • ►  Jun 06 (1)
    • ►  May (7)
      • ►  May 01 (7)
    • ▼  April (7)
      • ►  Apr 30 (5)
      • ▼  Apr 24 (1)
        • How to back up & restore postgres database?
      • ►  Apr 22 (1)
  • ►  2013 (1)
    • ►  September (1)
      • ►  Sep 01 (1)
Simple theme. Powered by Blogger.