Trying to import the database to hatchbox and keep...
# supportx
Xan
09/02/2021, 6:54 PMTrying to import the database to hatchbox and keep getting errors like "ERROR: relation "public.active_storage_blobs" does not exist"
Xan
09/02/2021, 6:54 PMthe database works locally, soo why wouldn't I be able to dump that and then import it?
j
Jared Norman
09/02/2021, 6:56 PM
Is the dump you're importing a data dump or does it include structure too? What state is the DB on hatchbox in?
x
Xan
09/02/2021, 7:01 PMit should be an empty db on hatchbox since I just made the webapp, this import script used to work against the production db back in March-ish the last time I ran it
Xan
09/02/2021, 7:01 PMpg_dump -a -U local_db_user local_db_nameXan
09/02/2021, 7:02 PMthats whats being ran to get the db, then its being uploaded and imported with..
j
Jared Norman
09/02/2021, 7:03 PM
-ax
Xan
09/02/2021, 7:03 PMpsql -v ON_ERROR_STOP=1 -h 127.0.0.1 -q --user testuser -d test_staging --dbname=test_staging < /home/deploy/test_staging-1630609153.pgsqlXan
09/02/2021, 7:04 PMah, I'll try removing that
Xan
09/02/2021, 7:04 PMI normally just deal with mysql besides our solidus sites, sorry, thanks!
Xan
09/02/2021, 7:05 PMnow it throws "unrecognized configuration parameter "default_table_access_method"" - googling it now though
Xan
09/02/2021, 7:08 PMah hatchbox is now on psql 13 and I believe used to be on 12 like my dev environment is