Stream: containers

Topic: โœ” can't run createsequence.sql


view this post on Zulip Philip Durbin ๐Ÿš€ (Jul 25 2023 at 13:18):

I'm having trouble getting createsequence.sql to run: https://github.com/pdurbin/dataverse-api-test-runner/commit/52c655c

view this post on Zulip Philip Durbin ๐Ÿš€ (Jul 25 2023 at 13:19):

I expected this to work:

psql -h localhost -U $DATAVERSE_DB_USER $DATAVERSE_DB_NAME -f doc/sphinx-guides/source/_static/util/createsequence.sql

view this post on Zulip Philip Durbin ๐Ÿš€ (Jul 25 2023 at 13:19):

But I got this:

psql: error: connection to server at "localhost" (::1), port 5432 failed: Connection refused

view this post on Zulip Philip Durbin ๐Ÿš€ (Jul 25 2023 at 13:20):

See https://github.com/pdurbin/dataverse-api-test-runner/actions/runs/5648925205/job/15302157873

view this post on Zulip Philip Durbin ๐Ÿš€ (Jul 25 2023 at 16:33):

https://github.com/pdurbin/dataverse-api-test-runner/commit/6cb1464 is getting me closer. Thanks, @Guillermo Portas !

view this post on Zulip Philip Durbin ๐Ÿš€ (Jul 25 2023 at 16:46):

I needed this fix too: https://github.com/pdurbin/dataverse-api-test-runner/commit/85a986e

view this post on Zulip Philip Durbin ๐Ÿš€ (Jul 25 2023 at 16:47):

All set. In short, ports instead of expose . And the env vars I was using were blank.

view this post on Zulip Philip Durbin ๐Ÿš€ (Jul 25 2023 at 16:48):

Bah. Spoke too soon. Next error is "psql:doc/sphinx-guides/source/_static/util/createsequence.sql:20: ERROR: role "dvnapp" does not exist"

view this post on Zulip Philip Durbin ๐Ÿš€ (Jul 25 2023 at 17:12):

Ok, fixed: https://github.com/pdurbin/dataverse-api-test-runner/commit/7711ff4


Last updated: Oct 30 2025 at 05:14 UTC