Lazer_Pope (Vossi / Hendrik) Posts

Lazer_Pope (Vossi / Hendrik)

•Created by Lazer_Pope (Vossi / Hendrik) on 6/25/2024 in #help

Connection terminated unexpectedly after adding postgres.conf

Heyo, after adding a postgres.conf to my db, I always get 'Connection terminated unexpectedly'. I've tried multiple config setups, and this error arises as soon as I add any config to postgres. This is my docker postgres setup:

  db:
    container_name: db
    image: postgres:13
    platform: linux/x86_64
    ports:
      - '5432:5432'
    environment:
      POSTGRES_USER: root
      POSTGRES_PASSWORD: 123
      POSTGRES_DB: solid-hour-2
    volumes:
      - ./postgres.conf:/etc/postgresql/postgresql.conf
      - ./data:/var/lib/postgresql/data
    command: postgres -c config_file=/etc/postgresql/postgresql.conf

This is a conf straight from the postgres website:

# This is a comment
log_connections = yes
log_destination = 'syslog'
search_path = '"$user", public'
shared_buffers = 128MB

And this is the error from drizzle: Error: Connection terminated unexpectedly at /Users/user/Documents/solid-hour/repos/solid-hour-2-fullstack/node_modules/pg-pool/index.js:45:11 at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async PgDialect.migrate (file:///Users/user/Documents/solid-hour/repos/solid-hour-2-fullstack/node_modules/drizzle-orm/pg-core/dialect.js:37:5) at async Module.migrate (file:///Users/user/Documents/solid-hour/repos/solid-hour-2-fullstack/node_modules/drizzle-orm/node-postgres/migrator.js:4:3) at async Module.initDb (/Users/user/Documents/solid-hour/repos/solid-hour-2-fullstack/src/lib/server/db/db.ts:66:5) at async eval (/Users/user/Documents/solid-hour/repos/solid-hour-2-fullstack/src/hooks.server.ts:13:3) at async instantiateModule (file:///Users/user/Documents/solid-hour/repos/solid-hour-2-fullstack/node_modules/vite/dist/node/chunks/dep-jvB8WLp9.js:54897:9) Adding the same settings via environment variables works, though.

4 replies

DTDrizzle Team

•Created by Lazer_Pope (Vossi / Hendrik) on 10/16/2023 in #help

Automatic migrationbs

Heyo, I am currently thinking about using SvelteKit with drizzle for a new project. Currently I use NestJs +TypeOrm, and one thing I like is that my migrations get automatically applied whenever I push an update into production. (Work locally, change database entities (e.g. add a column, create a new seed query), and I don't have to worry about manually starting any migrations on the client's server). Is the same possible in drizzle?

2 replies

Gaming

Programming