Drizzle-kit push:pg not working
I can't run npx drizzle-kit push:pg. I'm using an aws rds database with manage_master_user_password = true.
My drizzle config:
export default {
dbCredentials: {
database: 'ecominatestagingdb',
host: 'ecominate-staging-db.**.us-east-1.rds.amazonaws.com',
port: 5432
},
driver: 'pg',
out: './drizzle',
schema: './src/schema.ts'
} satisfies Config;
npx drizzle-kit push:pg outputs:
drizzle-kit: v0.20.9
drizzle-orm: v0.29.2
No config path provided, using default path
Reading config file '/Users/visiononyeaku/Desktop/Work/rip-technologies/packages/ecominate/database/drizzle.config.ts'
node:internal/process/promises:289
triggerUncaughtException(err, true / fromPromise /);
^
Error: connect ETIMEDOUT 172.31..:5432
at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1595:16)
at TCPConnectWrap.callbackTrampoline (node:internal/async_hooks:130:17) {
errno: -60,
code: 'ETIMEDOUT',
syscall: 'connect',
address: '172.31...*',
port: 5432
}
Node.js v21.5.0
My drizzle config:
export default {
dbCredentials: {
database: 'ecominatestagingdb',
host: 'ecominate-staging-db.**.us-east-1.rds.amazonaws.com',
port: 5432
},
driver: 'pg',
out: './drizzle',
schema: './src/schema.ts'
} satisfies Config;
npx drizzle-kit push:pg outputs:
drizzle-kit: v0.20.9
drizzle-orm: v0.29.2
No config path provided, using default path
Reading config file '/Users/visiononyeaku/Desktop/Work/rip-technologies/packages/ecominate/database/drizzle.config.ts'
node:internal/process/promises:289
triggerUncaughtException(err, true / fromPromise /);
^
Error: connect ETIMEDOUT 172.31..:5432
at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1595:16)
at TCPConnectWrap.callbackTrampoline (node:internal/async_hooks:130:17) {
errno: -60,
code: 'ETIMEDOUT',
syscall: 'connect',
address: '172.31...*',
port: 5432
}
Node.js v21.5.0
