Grep Ruby

Monday, 15 September 2014

Commands for exporting and importing database from postgresql

To export data:
pg_dump -U username -Fc database_name > db_backup.dump


To import data:
pg_restore --verbose --clean --no-acl --no-owner -d database_name db_backup.dump
Posted by Anonymous at 19:02
Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2016 (4)
    • ►  October (1)
    • ►  July (1)
    • ►  April (2)
  • ►  2015 (27)
    • ►  September (1)
    • ►  August (1)
    • ►  July (1)
    • ►  June (3)
    • ►  May (3)
    • ►  April (12)
    • ►  March (6)
  • ▼  2014 (20)
    • ►  December (2)
    • ►  October (3)
    • ▼  September (15)
      • RVM Project Workflow
      • Agile project management tool, Real time group cha...
      • Configure Nginx with Unicorn on Ubuntu(Linux)
      • Commands for exporting and importing database from...
      • Setting hosts on ubuntu and windows 7
      • Configure Ubuntu 12.04 for Ruby On Rails development
      • CREATE EXTENSION hstore getting error
      • SETTING UP A CLOUDFRONT CDN FOR RAILS
      • In AngularJS, how would you cache the data (for ex...
      • conditional multiplication of rates as per increas...
      • Rename Database Column in a Rails Migration
      • Install postgres on ubuntu 12.04
      • Adding the existing application on heroku and depl...
      • Validating uniqueness of nested model with parent_id
      • Steps for creating gem
Awesome Inc. theme. Powered by Blogger.