Open Source

Thursday, March 28, 2013

postgresql backup and restore commands


Ubuntu:
Postgres Commands:

pg_dump -U username db_name > filename.sql

psql -U username -d db_name -f filename.sql


Windows:
psql.exe -U postgres -d development -f "d:db.sql"



Posted by rupesh.. at 1:06 PM
Newer Post Older Post Home

widget

this is test widget

Pages

  • Home
  • CRM/ERP/CMS

Blog Archive

  • ►  2016 (12)
    • ►  December (1)
    • ►  October (2)
    • ►  September (1)
    • ►  July (4)
    • ►  June (3)
    • ►  May (1)
  • ►  2015 (4)
    • ►  September (1)
    • ►  May (1)
    • ►  January (2)
  • ►  2014 (4)
    • ►  March (1)
    • ►  February (1)
    • ►  January (2)
  • ▼  2013 (11)
    • ►  December (1)
    • ►  November (2)
    • ►  October (2)
    • ►  May (1)
    • ►  April (1)
    • ▼  March (3)
      • postgresql backup and restore commands
      • Ubuntu is running in low-graphics mode
      • Install Oracle Virtual Box on Ubuntu and Windows
    • ►  February (1)
  • ►  2012 (18)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  May (1)
    • ►  April (2)
    • ►  March (7)
    • ►  February (1)
    • ►  January (4)
  • ►  2011 (28)
    • ►  December (4)
    • ►  November (2)
    • ►  October (1)
    • ►  September (10)
    • ►  August (1)
    • ►  July (3)
    • ►  March (2)
    • ►  February (4)
    • ►  January (1)
Picture Window theme. Powered by Blogger.