Error with Heroku Postgres DB connecion

[faebeee]

Issue Description

If I run the command migration:show with my local database, everything works fine. As soon as I run it with the DB from my
heroku account I get a error, which doesn't seem to be very helpful:

query: SELECT * FROM "information_schema"."tables" WHERE "table_schema" = current_schema() AND "table_name" = 'migrations'
query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
 [ ] GameModel1621443501376
 [ ] DefaultUsers1621671758215
Waiting for the debugger to disconnect...
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! wurfel-backend@0.2.13 migration:show: `npx ts-node --transpile-only ./node_modules/typeorm/cli.js migration:show`
npm ERR! Exit status 1
npm ERR! 
npm ERR! Failed at the wurfel-backend@0.2.13 migration:show script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR!     /Users/cx/.npm/_logs/2021-05-24T10_16_53_758Z-debug.log
Waiting for the debugger to disconnect...

Process finished with exit code 1

But I can run the application with the DB connection from heroku and it connects just fine. Just get the problem by running and showing the migrations.

Expected Behavior

Get a more helpfull error message

Actual Behavior

npm debug log

0 info it worked if it ends with ok
1 verbose cli [
1 verbose cli   '/Users/cx/.nvm/versions/node/v14.16.1/bin/node',
1 verbose cli   '/Users/cx/.nvm/versions/node/v14.16.1/lib/node_modules/npm/bin/npm-cli.js',
1 verbose cli   'run',
1 verbose cli   'migration:show',
1 verbose cli   '--scripts-prepend-node-path=auto'
1 verbose cli ]
2 info using npm@6.14.12
3 info using node@v14.16.1
4 verbose run-script [ 'premigration:show', 'migration:show', 'postmigration:show' ]
5 info lifecycle wurfel-backend@0.2.13~premigration:show: wurfel-backend@0.2.13
6 info lifecycle wurfel-backend@0.2.13~migration:show: wurfel-backend@0.2.13
7 verbose lifecycle wurfel-backend@0.2.13~migration:show: unsafe-perm in lifecycle true
8 verbose lifecycle wurfel-backend@0.2.13~migration:show: PATH: /Users/cx/.nvm/versions/node/v14.16.1/lib/node_modules/npm/node_modules/npm-lifecycle/node-gyp-bin:/Users/cx/Work/wurfel/wurfel-backend/node_modules/.bin:/Users/cx/.nvm/versions/node/v14.16.1/bin:/usr/bin:/bin:/usr/sbin:/sbin
9 verbose lifecycle wurfel-backend@0.2.13~migration:show: CWD: /Users/cx/Work/wurfel/wurfel-backend
10 silly lifecycle wurfel-backend@0.2.13~migration:show: Args: [
10 silly lifecycle   '-c',
10 silly lifecycle   'npx ts-node --transpile-only ./node_modules/typeorm/cli.js migration:show'
10 silly lifecycle ]
11 silly lifecycle wurfel-backend@0.2.13~migration:show: Returned: code: 1  signal: null
12 info lifecycle wurfel-backend@0.2.13~migration:show: Failed to exec migration:show script
13 verbose stack Error: wurfel-backend@0.2.13 migration:show: `npx ts-node --transpile-only ./node_modules/typeorm/cli.js migration:show`
13 verbose stack Exit status 1
13 verbose stack     at EventEmitter.<anonymous> (/Users/cx/.nvm/versions/node/v14.16.1/lib/node_modules/npm/node_modules/npm-lifecycle/index.js:332:16)
13 verbose stack     at EventEmitter.emit (events.js:315:20)
13 verbose stack     at ChildProcess.<anonymous> (/Users/cx/.nvm/versions/node/v14.16.1/lib/node_modules/npm/node_modules/npm-lifecycle/lib/spawn.js:55:14)
13 verbose stack     at ChildProcess.emit (events.js:315:20)
13 verbose stack     at maybeClose (internal/child_process.js:1048:16)
13 verbose stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5)
13 verbose stack     at Process.callbackTrampoline (internal/async_hooks.js:131:14)
14 verbose pkgid wurfel-backend@0.2.13
15 verbose cwd /Users/cx/Work/wurfel/wurfel-backend
16 verbose Darwin 20.4.0
17 verbose argv "/Users/cx/.nvm/versions/node/v14.16.1/bin/node" "/Users/cx/.nvm/versions/node/v14.16.1/lib/node_modules/npm/bin/npm-cli.js" "run" "migration:show" "--scripts-prepend-node-path=auto"
18 verbose node v14.16.1
19 verbose npm  v6.14.12
20 error code ELIFECYCLE
21 error errno 1
22 error wurfel-backend@0.2.13 migration:show: `npx ts-node --transpile-only ./node_modules/typeorm/cli.js migration:show`
22 error Exit status 1
23 error Failed at the wurfel-backend@0.2.13 migration:show script.
23 error This is probably not a problem with npm. There is likely additional logging output above.
24 verbose exit [ 1, true ]

Steps to Reproduce

1. Create a migration
2. Use postgres://dxnyvsqfoqqgsz:dc492cd9493a49d87e1d5b351cf3064752cda875174c11f7aa50d38656c2ff92@ec2-54-73-147-133.eu-west-1.compute.amazonaws.com:5432/d46k8534o9j7s0 as database (It's an empty DB for the sole purpose or reproducing this bug)
3. run migration:show

My Environment

Dependency	Version
Operating System	OSX 11.3.1 (20E241)
Node.js version	v14.16
Typescript version	v4.2.4
TypeORM version	v0.2.32

Additional Context

Relevant Database Driver(s)

• aurora-data-api
• aurora-data-api-pg
• better-sqlite3
• cockroachdb
• cordova
• expo
• mongodb
• mysql
• nativescript
• oracle
• postgres
• react-native
• sap
• sqlite
• sqlite-abstract
• sqljs
• sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

• Yes, I have the time, and I know how to start.
• Yes, I have the time, but I don't know how to start. I would need guidance.
• No, I don't have the time, although I believe I could do it if I had the time...
• No, I don't have the time and I wouldn't even know how to start.