poster icon indicating copy to clipboard operation
poster copied to clipboard

Documentation: pg_restore from heroku

Open dennyluan opened this issue 2 years ago • 0 comments

To locally restore from a 14.7 pg_dump backup, postgres complains about missing heroku_ext

psql poster_development -c "CREATE SCHEMA IF NOT EXISTS heroku_ext"
psql poster_development -c "ALTER database poster_development SET search_path TO heroku_ext,public"
pg_restore --verbose --clean --no-acl --no-owner -h localhost -d poster_development <backup>

dennyluan avatar May 13 '23 02:05 dennyluan