#823·goose

goose migrate fails with sql, psql loads ok

Author: jmlsCreated Sep 11, 2024Updated Jun 12, 2026
Labelsdocs

I'm trying to load some existing schema and data as a migration into a new postgres db

when goose starts up, it creates the migration table but then errors with

"ERROR: trailing junk after numeric literal at or near "8c" (SQLSTATE 42601)" loading "20240911190228_development.sql"

however, if I use psql

psql < 20240911190228_development.sql

then all the data is loaded without any apparent errors

the 20240911190228_development.sql file was created with pg_dump . Is there any options / formatting that needs to be applied to pg_dump ?