Graphql-engine: support pg_dump for Postgres 13

[phamquyhai]

I'm using Hasura ver 1.3.2. When I call hasura migrate ..., I got an error.

cannot fetch schema dump: [unexpected] error while executing pg_dump: pg_dump: error: server version: 13rc1; pg_dump version: 12.2 (Debian 12.2-2.pgdg90+1)

I think Hasura currently only supports pg ver 12 & below.

[GavinRay97]

Hey, unfortunately I am not able to reproduce this:

version: "3.6"
services:
  postgres:
    image: postgres:13
    restart: always
    volumes:
      - db_data:/var/lib/postgresql/data
    environment:
      POSTGRES_PASSWORD: postgrespassword

  graphql-engine:
    image: hasura/graphql-engine:v1.3.2
    ports:
      - "8090:8080"
    depends_on:
      - "postgres"
    restart: always
    environment:
      HASURA_GRAPHQL_DATABASE_URL: postgres://postgres:postgrespassword@postgres:5432/postgres
      HASURA_GRAPHQL_ENABLE_CONSOLE: "true" # set to "false" to disable console
      HASURA_GRAPHQL_DEV_MODE: "true"
      HASURA_GRAPHQL_ENABLED_LOG_TYPES: startup, http-log, webhook-log, websocket-log, query-log

volumes:
  db_data:

Can you link a repo here with a reproduction and system information?

[phamquyhai]

@GavinRay97
I used posgress from postgis image. cli and version hasura same you.
i got errors when I call hasura migrate

version: '3.6'
services:
  postgres:
    image: postgis/postgis:13-3.0-alpine
    restart: always

[donnerc]

Same issue for me. I use the images hasura/graphql-engine:v1.3.2 and postgres:13

This comes from the fact that pg_dump in the 1.3.2 hasura image still is version 12.2. This should be corrected in the Hasura images. The hasura Team should update the Postgres client tools in their image to version 13.

{bash} $ docker exec -it backend_hasura_1 pg_dump --version pg_dump (PostgreSQL) 12.2 (Debian 12.2-2.pgdg90+1)