Skip to content

Instantly share code, notes, and snippets.

@stevepolitodesign
Last active June 24, 2021 14:44
Show Gist options
  • Save stevepolitodesign/85502a317d0c30448a372e87ae869192 to your computer and use it in GitHub Desktop.
Save stevepolitodesign/85502a317d0c30448a372e87ae869192 to your computer and use it in GitHub Desktop.
Export Database and Import into Render
pg_dump local_development_database_name -c -C -f local_development_database_backup.sql
# This worked, with errors.
psql $external_connection_string < local_development_database_backup.sql
# This might be better.
pg_restore $external_connection_string -c -f local_development_database_backup.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment