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;
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 your Prisma Postgres database from Early Access database to General Availability database.
