Support for Postgres 14 (default config)

[jokay]

Feature description

pgModeler 0.9.3 (AppImage) is not able to connect to Postgres 14 (default config).

SCRAM authentication seems to be the default for postgres >= 14.x, see here.

Sample image

Additional info

We are using the official Docker postgres without any custom settings.

services:
  db:
    image: postgres:14.2-alpine
    volumes:
      - ./data:/var/lib/postgresql/data
    environment:
      - POSTGRES_DB=test
      - POSTGRES_USER=root
      - POSTGRES_PASSWORD=p@55w0rd
    networks:
      - default
    ports:
      - 5432:5432

Relates https://github.com/pgmodeler/pgmodeler/issues/1034.

[rkhaotix]

PostgreSQL 14 will be added on pgModeler 1.0 while older versions 9.x will be dropped.

[jokay]

@rkhaotix do you plan to support PostgreSQL 15 with pgModeler 1.0 as well?

[rkhaotix]

pgModeler already supports PG15.

[jokay]

pgModeler already supports PG15.

Including the default SCRAM authentication?

[jokay]

Confirmed working with pgModeler 1.0.2 and PostgreSQL 15.2 (default scram-sha-256).

See also #1034.

Issue closed.