Twenty•3mo ago

Postgres Error During Local Setup

Hi, I am getting the following errors when following the local setup instructions (after running

npx nx database:reset twenty-server

Error during migration run:
error: role "postgres" does not exist
    at Parser.parseErrorMessage (/Users/bellahuang/ECE444/twenty/node_modules/pg/node_modules/pg-protocol/src/parser.ts:369:69)
    at Parser.handlePacket (/Users/bellahuang/ECE444/twenty/node_modules/pg/node_modules/pg-protocol/src/parser.ts:188:21)
    at Parser.parse (/Users/bellahuang/ECE444/twenty/node_modules/pg/node_modules/pg-protocol/src/parser.ts:103:30)
    at Socket.<anonymous> (/Users/bellahuang/ECE444/twenty/node_modules/pg/node_modules/pg-protocol/src/index.ts:7:48)
    at Socket.emit (node:events:517:28)
    at Socket.emit (node:domain:489:12)
    at addChunk (node:internal/streams/readable:368:12)
    at readableAddChunk (node:internal/streams/readable:341:9)
    at Socket.Readable.push (node:internal/streams/readable:278:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
  length: 100,
  severity: 'FATAL',
  code: '28000',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'miscinit.c',
  line: '798',
  routine: 'InitializeSessionUserId'
}
Warning: command "ts-node ../../node_modules/typeorm/cli.js migration:run -d src/database/typeorm/metadata/metadata.datasource" exited with non-zero status code

Error during migration run:
error: role "postgres" does not exist
    at Parser.parseErrorMessage (/Users/bellahuang/ECE444/twenty/node_modules/pg/node_modules/pg-protocol/src/parser.ts:369:69)
    at Parser.handlePacket (/Users/bellahuang/ECE444/twenty/node_modules/pg/node_modules/pg-protocol/src/parser.ts:188:21)
    at Parser.parse (/Users/bellahuang/ECE444/twenty/node_modules/pg/node_modules/pg-protocol/src/parser.ts:103:30)
    at Socket.<anonymous> (/Users/bellahuang/ECE444/twenty/node_modules/pg/node_modules/pg-protocol/src/index.ts:7:48)
    at Socket.emit (node:events:517:28)
    at Socket.emit (node:domain:489:12)
    at addChunk (node:internal/streams/readable:368:12)
    at readableAddChunk (node:internal/streams/readable:341:9)
    at Socket.Readable.push (node:internal/streams/readable:278:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
  length: 100,
  severity: 'FATAL',
  code: '28000',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'miscinit.c',
  line: '798',
  routine: 'InitializeSessionUserId'
}
Warning: command "ts-node ../../node_modules/typeorm/cli.js migration:run -d src/database/typeorm/metadata/metadata.datasource" exited with non-zero status code

7 Replies

Bella HOP•3mo ago

———————————————————————————————————————————————————————————————————————————————————————————————————

 NX   Ran target typeorm for project twenty-server (2s)

      With additional flags:
        migration:run
        --d=src/database/typeorm/metadata/metadata.datasource

   ✖  1/1 failed
   ✔  0/1 succeeded [0 read from cache]

Warning: command "nx typeorm -- migration:run -d src/database/typeorm/metadata/metadata.datasource" exited with non-zero status code
———————————————————————————————————————————————————————————————————————————————————————————————————

 NX   Ran target database:migrate for project twenty-server and 2 task(s) they depend on (3s)

   ✖  1/3 failed
   ✔  2/3 succeeded [2 read from cache]

Warning: command "nx database:migrate" exited with non-zero status code
———————————————————————————————————————————————————————————————————————————————————————————————————

 NX   Ran target database:reset for project twenty-server and 2 task(s) they depend on (44s)

   ✖  1/3 failed
   ✔  2/3 succeeded [2 read from cache]

———————————————————————————————————————————————————————————————————————————————————————————————————

 NX   Ran target typeorm for project twenty-server (2s)

      With additional flags:
        migration:run
        --d=src/database/typeorm/metadata/metadata.datasource

   ✖  1/1 failed
   ✔  0/1 succeeded [0 read from cache]

Warning: command "nx typeorm -- migration:run -d src/database/typeorm/metadata/metadata.datasource" exited with non-zero status code
———————————————————————————————————————————————————————————————————————————————————————————————————

 NX   Ran target database:migrate for project twenty-server and 2 task(s) they depend on (3s)

   ✖  1/3 failed
   ✔  2/3 succeeded [2 read from cache]

Warning: command "nx database:migrate" exited with non-zero status code
———————————————————————————————————————————————————————————————————————————————————————————————————

 NX   Ran target database:reset for project twenty-server and 2 task(s) they depend on (44s)

   ✖  1/3 failed
   ✔  2/3 succeeded [2 read from cache]

thomast•3mo ago

hi @Bella H, what steps did you follow here https://twenty.com/developers/local-setup?

Twenty - Local Setup

Mostly for contributors or curious developers

Bella HOP•3mo ago

Hi @thomast , I went through steps 1-7 for Mac OS, and ran into the above error after running

npx nx database:reset twenty-server

at step 7

thomast•3mo ago

what option did you choose for step 3? can you provide the available roles you have in your postgres DB? could you provide your PG_DATABASE_URL in your .env @Bella H

den6gal•2w ago

Hi @thomast and @Bella H , I ran into the same error when trying trying to instal locally on Mac OS. I chose option 1 (local DB provisioning). I checked my .env file and it's default settings: PG_DATABASE_URL=postgres://postgres:postgres@localhost:5432/default Postgres version looks OK: psql (PostgreSQL) 16.6 (Homebrew) Any idea how to fix this?

thomast•2w ago

try with user twenty and pswd twenty in your PG_DATABASE_URL

den6gal•5d ago

Thank you for your reply @thomast; I tried twenty as user/password, it didn't fix the issue, it appears I can't properly access my Postgres DB, so I'm investigating it.

Gaming

Programming

Postgres Error During Local Setup

Did you find this page helpful?