How To Backup and Restore Postgres Databases

Опубликовано: 05 Октябрь 2024
на канале: Just Another Dang How To Channel

373

In this video we are going to learn How to backup and restore databases using the command line and also using a GUI like PGAdmin

I have tutorials on how to install postgres ang PGAdmin you can go check it out.
PostgreSQL HowTos
• PostgreSQL HowTos

Commands:
Backup
pg_dump -Fc -f mydb.dump -h localhost -U username -w -d mydb

Restore
pg_restore -d mydb -h localhost -U username mydb.dump

Buy Me Coffee
https://buymeacoffee.com/pauloorquillo

Gears:
Shot with Sony ZV-E10
https://amzn.to/3uVzPQt

SanDisk 128GB Extreme PRO
https://amzn.to/3RF9gZD

Sigma 16mm f/1.4 DC DN
https://amzn.to/3AgH1d1

Joby GorillaPod 1kg
https://amzn.to/3V5slVn

iPhone 14 Pro
https://amzn.to/3PLubcG

PGYTech Mini Holder for Tripods
https://amzn.to/3UQxDUg

Zhiyun Crane M2S
https://amzn.to/3ATAa9K

My Workstation Setup:
Macbook Pro 16 inch M1 Pro
https://amzn.to/3OdBqb7

Samsung 28-Inch 4K UHD Led-Lit Monitor
https://amzn.to/3H246Tc

USB C to HDMI Cable 4K
https://amzn.to/3REVpBe

Apple Magic Keyboard with Touch ID and Numeric Keypad
https://amzn.to/3Pwm6HF

Rode TRS to TRRS Patch Cable
https://amzn.to/3EL3RM1

Rode MicroVideo Microphone
https://amzn.to/3ccVRYR

Gaming Rig:
Lian Li O11 AIR MINI White
https://amzn.to/475GaZF

ASUS Dual GeForce® RTX 4070
https://amzn.to/483PDBY