Automated Postgresql backups with pg_dump

Language: Plain Text

Annoyingly, postgres makes is very annoying to pass in your password when using pg_dump. There's a way around it, though...

PGPASSWORD=YOUR_PASS pg_dump -Fc --username=YOUR_USER --host=YOUR_HOST YOUR_DB_NAME > YOUR_BACKUP_FILE
Reveal More
Added 5 months ago by Costco_normal trevorturk