docker compose exec -T postgres pg_dump
で余計な文字が混ざってくるのマジでなんなん
docker compose exec -T postgres pg_dump
で余計な文字が混ざってくるのマジでなんなん
pg_dump で create オプションつけるとコメントアウトの頭に余計な文字が入って不正なsqlファイルになっちゃうっぽい?
db_1 | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/db-backup-24-06-21.sql
db_1 | 2021-06-24 12:33:30.203 UTC [49] ERROR: syntax error at or near "" at character 1
db_1 | 2021-06-24 12:33:30.203 UTC [49] STATEMENT:
db_1 |
db_1 |
db_1 | SET statement_timeout = 0;
db_1 | psql:/docker-entrypoint-initdb.d/db-backup-24-06-21.sql:6: ERROR: syntax error at or near ""
db_1 | LINE 1:
db_1 | ^