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 Posts Older Posts Home
Subscribe to: Posts (Atom)

widget

this is test widget

Pages

  • Home
  • CRM/ERP/CMS

Blog Archive

  • ▼  2016 (12)
    • ▼  December (1)
      • Techinical URL's
    • ►  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)
    • ►  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.