کشفیات بی ارزش

Saturday, August 4, 2018

backup and restore on postgres

Wanna backup and restore postgres db?
 pg_dump -Fc -Z 9 -U postgres -W --file=file.dump db_name  
 pg_restore -Fc -j 8 -U postgres -W -d db_name file.dump  
Posted by کاشف پاره‌وقت at 7:25 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

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

About Me

کاشف پاره‌وقت
View my complete profile

Blog Archive

  • ►  2020 (1)
    • ►  May (1)
  • ▼  2018 (6)
    • ►  October (1)
    • ▼  August (1)
      • backup and restore on postgres
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  March (1)
  • ►  2017 (12)
    • ►  October (6)
    • ►  August (1)
    • ►  July (1)
    • ►  April (2)
    • ►  March (2)
  • ►  2016 (6)
    • ►  October (1)
    • ►  September (1)
    • ►  July (1)
    • ►  June (2)
    • ►  February (1)
  • ►  2015 (12)
    • ►  October (1)
    • ►  September (1)
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  April (1)
    • ►  February (1)
    • ►  January (5)
  • ►  2014 (21)
    • ►  December (4)
    • ►  November (6)
    • ►  October (11)
Simple theme. Powered by Blogger.