Skip to content

[BUG] Changing psql .env settings can create some problems #165

Description

@fluffy-marmot

Describe the bug

a few small issues:

  • in init.sql CREATE DATABASE cannot run within a DO $$ block, so this never runs and should be deleted. Docker creates the database anyway based on .env settings. This block also has "eos" hardcoded as the database name. It does nothing if .env also uses "eos" name but errors out if the database name is changed
  • in migration-entrypoint.sh a .env variable is misnamed
  • POSTGRES_PORT is used to dynamically set the psql port in DATABASE_URL envvar, but hardcoded to 5432 in docker-compose.yml

Expected behavior

should be able to change db name, username, and port number without issues

How was the bot ran

docker compose -up

Additional context

changed port number, db name and db username

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions