Solving failing manual backup and restore operations
Reviewed on 13 August 2024 • Published on 07 February 2024
Manual SQL backup and restore fails
Problem
When creating or restoring backup manually (i.e. via SQL Administration tools such as pgAdmin, or directly via SQL commands), some errors may occur.
Cause
These issues are caused by using pg_dump
and pg_restore
versions that are not compatible with PostgreSQL 16 (on which Serverless SQL Databases rely).
Solution
To solve these issues, upgrade your pg_dump
and/or pg_restore
modules:
- You can upgrade them by installing PostgreSQL 16 which includes these tools.
- If you are using a third-party tool that includes these libraries, upgrade your tool. For instance, pgAdmin supports PostgreSQL 16 ecosystem from version 7.8.