heroku Heroku Postgres How to copy heroku database to local database


Example

Steps to copy heroku database to local database:

1. Run copy process in terminal:

heroku pg:pull DATABASE_URL change_to_your_data_base_name --app change_to_your_app_name

2. Change db owner using this query:

GRANT ALL PRIVILEGES ON DATABASE change_to_your_data_base_name to change_to_your_user; ALTER DATABASE change_to_your_data_base_name OWNER TO change_to_your_user;

3. Generate and run query for all tables in you database:

SELECT 'ALTER TABLE '|| schemaname || '.' || tablename ||' OWNER TO change_to_your_user;' FROM pg_tables WHERE NOT schemaname IN ('pg_catalog', 'information_schema') ORDER BY schemaname, tablename;