pg_dump version upgrade needed

[p-null]

Version Information

Server Version: 2.48.6 CLI Version (for CLI related issue): 2.48.0

Environment

OSS

What is the current behaviour?

Running hasura migrate create "init" --from-server will have:

FATA[0004] cannot fetch schema dump: pg_dump request: 500 
{
  "error": "error while executing pg_dump",
  "path": "$",
  "code": "unexpected",
  "internal": "pg_dump: error: aborting because of server version mismatch\npg_dump: detail: server version: 18.0 (Debian 18.0-1.pgdg13+3); pg_dump version: 17.6 (Ubuntu 17.6-2.pgdg22.04+1)\n"
} 

What is the expected behaviour?

pg_dump works properly in hasura cli

How to reproduce the issue?

1. Connect Hasura with a Postgres 18 database
2. Run hasura migrate with --from-server

Screenshots or Screencast

Please provide any traces or logs that could help here.

Any possible solutions/workarounds you're aware of?

Upgrade pg_dump for postgres 18

Keywords

[robertjdominguez]

@jberryman - is this related to this commit?

[jberryman]

Thanks for reporting

@robertjdominguez it's not a regression but we do need to bump the version of pg_dump we ship again, just like in that PR. Since v18 is now in released/supported status: https://www.postgresql.org/support/versioning/

[joshua1]

@jberryman any Joy on this ? I just ran into thesame issue , now looking to downgrade postgres to 17 to see if it would work

[jberryman]

Yes, this will go out in the next minor release. In the meantime you should be able to work around it by installing postgresql-client-18 in a new docker image based on the current release