Upgrade from Early Access
Hello, according to this article https://www.prisma.io/docs/getting-started/prisma-postgres/upgrade-from-early-access I have tried backup my data but on step:
1.3. Creating the Backup with pg_dump
PGSSLMODE=disable \
pg_dump \
-h 127.0.0.1 \
-p 5432 \
-Fc \
-v \
-d postgres \
-f ./mydatabase.bak \
&& echo "-complete-"
I got an error
pg_dump: saving search_path =
pg_dump: saving database definition
pg_dump: dumping contents of table "public.Account"
pg_dump: dumping contents of table "public.Booking"
pg_dump: error: Dumping the contents of table "Booking" failed: PQgetCopyData() failed.
pg_dump: detail: Error message from server: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
pg_dump: detail: Command was: COPY public."Booking" (id, status, phone, name, "userEmail", "staffId", comment, "recordId", "studioId", "resourceId", "serviceIds", "seanceLength", "startDate", "createdAt", "updatedAt", "treatmentFeedbackSent", "visitFeedbackSent") TO stdout;
Upgrade Prisma Postgres from Early Access | Prisma Documentation
Upgrade your Prisma Postgres database from Early Access database to General Availability database.
20 Replies
You decided to hold for human wisdom. We'll chime in soon! Meanwhile,
#ask-ai is there if you need a quick second opinion.@Kasmadan (UA) Thanks for reporting!
I am checking. This happened while you were exporting your production environment in project named "loveepil-com"?
yes
@Nurul (Prisma)
Shared details with team internally. I’ll get back with an update
thanks
One of our engineers is investigating this error today. I should have an update for you latest by tomorrow
thanks
I also have same problem. I also encounter an unexpected server disconnection while creating the backup with pg_dump, and the process fails.
@Nurul (Prisma) I can't push anything in prod DB, is this expected?
@taiccy @Kasmadan (UA) Can you please try creating a backup again?
You can run the command:
npx @prisma/ppg-tunnel@latest to start the tunnel
We just deployed a few changeswill try
@Nurul is stuck in this phase
@Nurul maybe you can make this file for me? I need to push some features...
I cannot create the file as I do not have access to your Prisma Postgres connection string.
I would recommend waiting for a few mins and check if you get any errors.
I could give you access:) if needed.
But yes, i'm waiting
If it's just about security, I can create a new key after, I just want to pass it on to continue development.
@Nurul could be this option available?
still stuck
started from scratch
So nothing happens after you start the pg_dump command, right?
Can I DM you to get the connection string? I'll try creating the database dump file
ofc
I successfully made a backup using @latest.
Thank you.