467,921 Members | 1,350 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,921 developers. It's quick & easy.

Error during migration run: no PostgreSQL user name specified in startup packet

Bit
yarn migrate:run && yarn start
yarn typeorm migration:run --config ./lib/src/ormconfig
/usr/src/app/node_modules/.bin/typeorm migration:run --config ./lib/src/ormconfig
Error during migration run:
{ error: no PostgreSQL user name specified in startup packet
at Connection.parseE (/usr/src/app/node_modules/pg/lib/connection.js:606:11)
at Connection.parseMessage (/usr/src/app/node_modules/pg/lib/connection.js:403:19)
at Socket.<anonymous> (/usr/src/app/node_modules/pg/lib/connection.js:123:22)
at Socket.emit (events.js:193:13)
at addChunk (_stream_readable.js:295:12)
at readableAddChunk (_stream_readable.js:276:11)
at Socket.Readable.push (_stream_readable.js:231:10)
at TCP.onStreamRead (internal/stream_base_commons.js:154:17)
name: 'error',
length: 121,
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: 'postmaster.c',
line: '2217',
routine: 'ProcessStartupPacket' }
error Command failed with exit code 1.
2 Weeks Ago #1
  • viewed: 2156
Share:
1 Reply
Niheel
Expert Mod 2GB
Double check your ormconfig file at /lib/src/ormfconfig

It might look like this.
Expand|Select|Wrap|Line Numbers
  1. import { ConnectionOptions } from 'typeorm';
  2.  
  3. const config: ConnectionOptions = {
  4.   type: 'postgres',
  5.   host: process.env.POSTGRES_HOST,
  6.   port: Number(process.env.POSTGRES_PORT),
  7.   username: process.env.POSTGRES_USER,
  8.   password: process.env.POSTGRES_PASSWORD,
  9.   database: process.env.POSTGRES_DB,
  10.   entities: [
  11.     __dirname + '/../**/*.entity{.ts,.js}',
  12.   ],
  13.   cli: {
  14.     migrationsDir: 'src/migrations',
  15.   }
  16. };
  17.  
  18. export = config;
  19.  
You might need to change your env variables. Or you can try manually inserting them in that file after the ":".

more information here:
https://github.com/typeorm/typeorm/b...-new-migration
1 Week Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Tony Wright | last post: by
3 posts views Thread by dstewart | last post: by
reply views Thread by Pavel N. Shtanko | last post: by
reply views Thread by Frank_00001 | last post: by
2 posts views Thread by ticars | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.