472,804 Members | 1,057 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,804 software developers and data experts.

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

1 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.
Feb 20 '21 #1
1 4724
2,459 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';
  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. };
  18. export = config;
You might need to change your env variables. Or you can try manually inserting them in that file after the ":".

more information here:
Feb 25 '21 #2

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

Similar topics

by: Tony Wright | last post by:
Hi, I am having a problem installing an msi for a web site. The error message I am getting is: "The specified path 'http://mipdev05/features/Fas2' is unavailable. The Internet Information...
by: dstewart | last post by:
Situation: One common MySQL database server on SuSE 9.1 with all updates. Uses 'rinetd'. Has entries for the appropriate IP addresses of all servers. NOTE: If the appropirate entries are NOT in...
by: Pavel N. Shtanko | last post by:
Hi. I compiled v7.4 and then try to test it After make check I got: ============== creating database "regression" ==============...
by: Frank_00001 | last post by:
I'm trying to use Active Directory to get a list of users that are in the same directory as the logon user. I'm trying to do this as a Web App written in C# using Windows Security and...
by: mrwoopey | last post by:
Hi, I am using the example "Authenticate against the Active Directory by Using Forms Authentication and Visual Basic .NET": http://support.microsoft.com/default.aspx?scid=KB;EN-US;326340 ...
by: Kurt Van Campenhout | last post by:
Hi, I am trying to get/set Terminal server information in the active directory on a windows 2000 domain. Since the ADSI calls for TS don't work until W2K3, I need to do it myself. I'm fairly...
by: Tore Halset | last post by:
Hello. I am trying to port an old java application from MS SQL Server to PostgreSQL running on Mac OS X. I have access to the java source code and can make modifications. I have tried with...
by: Jozef | last post by:
Hello, I've set up VS2003 on my laptop which is running Win XP pro in a stand alone situation, no domain or dc. When I try and "Create a blank solution", I use the Laptop IP address since...
by: ticars | last post by:
I'm getting a weird error when trying to access a user control from within a base page during runtime. Here's what I have: I have a master page with a user control on it. I then have a few...
by: matias.cornejo | last post by:
I have a problem to startup de DB2 Admin. I read meny documentation in internet and nothing work, anybody know something??. I have DB2 UDB V8 fixpack 14 and AIX 5.2 x134 db2admin start SQL4409W...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.