role 'postgres' does not exist
Hi, Trying to run db:push with a postgres db, gettign this error:
do i need a postgres role? what privleges does it need? and is there any documentation around this?
No config path provided, using default path
Reading config file '/Users/johnbogart/RCOOP/com/drizzle.config.ts'
error: role "postgres" does not exist
at Parser.parseErrorMessage (/Users/johnbogart/RCOOP/com/node_modules/drizzle-kit/index.cjs:40722:98)
at Parser.handlePacket (/Users/johnbogart/RCOOP/com/node_modules/drizzle-kit/index.cjs:40563:25)
at Parser.parse (/Users/johnbogart/RCOOP/com/node_modules/drizzle-kit/index.cjs:40487:34)
at Socket.<anonymous> (/Users/johnbogart/RCOOP/com/node_modules/drizzle-kit/index.cjs:40763:44)
at Socket.emit (node:events:527:28)
at addChunk (node:internal/streams/readable:315:12)
at readableAddChunk (node:internal/streams/readable:289:9)
at Socket.Readable.push (node:internal/streams/readable:228: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: '710',
routine: 'InitializeSessionUserId'
}
error: script "db:push" exited with code 1 (SIGHUP)No config path provided, using default path
Reading config file '/Users/johnbogart/RCOOP/com/drizzle.config.ts'
error: role "postgres" does not exist
at Parser.parseErrorMessage (/Users/johnbogart/RCOOP/com/node_modules/drizzle-kit/index.cjs:40722:98)
at Parser.handlePacket (/Users/johnbogart/RCOOP/com/node_modules/drizzle-kit/index.cjs:40563:25)
at Parser.parse (/Users/johnbogart/RCOOP/com/node_modules/drizzle-kit/index.cjs:40487:34)
at Socket.<anonymous> (/Users/johnbogart/RCOOP/com/node_modules/drizzle-kit/index.cjs:40763:44)
at Socket.emit (node:events:527:28)
at addChunk (node:internal/streams/readable:315:12)
at readableAddChunk (node:internal/streams/readable:289:9)
at Socket.Readable.push (node:internal/streams/readable:228: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: '710',
routine: 'InitializeSessionUserId'
}
error: script "db:push" exited with code 1 (SIGHUP)do i need a postgres role? what privleges does it need? and is there any documentation around this?
