mycak
PPrisma
•Created by mycak on 2/11/2025 in #help-and-questions
Upgrade from Prisma Postgres EA to GA - pg_dump Connection Error
Hi, I'm trying to upgrade from Prisma Postgres Early Access (EA) to General Availability (GA).
According to the documentation, I need to create a backup of my existing database using pg_dump. However, when running the following command:
futbolovo % PGSSLMODE=disable \
pg_dump \
-h 127.0.0.1 \
-p 5432 \
-Fc \
-v \
-d postgres \
-f ./mydatabase.bak \
&& echo "-complete-"
I get the following errors:
==============================
hostname: 127.0.0.1
port: 5432
username: <anything>
password: <none>
==============================
⏩ Establishing a new connection...
✅ Connection established
💥 TCP socket error: Error: read ECONNRESET
at TCP.onStreamRead (node:internal/stream_base_commons:216:20) {
errno: -54,
code: 'ECONNRESET',
syscall: 'read'
}
✖️ Connection closed { code: 1005, reason: '' }
pg_dump: error: connection to server at "127.0.0.1", port 5432 failed: received invalid response to GSSAPI negotiation: R14 replies