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
trevorturk
trevorturk
