(Quit on unsupport PostgreSQL version) Database connection error Retrying the connection

[sseenivasan89]

Environment

• PostgreSQL version: 7.4 (not in docker)
• PostgREST version: 11.2.0 (c820efb)
• Operating system: Windows 11

Description of the issue

getting database connection error, shared my postgrest.conf file as well

I installed PostgresDB and install postgrest and setup postgrest.conf and tried to connect

postgrest.conf

db-uri = "postgres://postgres:postgres@host:5432/my_db"
db-anon-role = "anon"
db-schema="public"
server-port = 3000

[steve-chavez]

PostgreSQL version: 7.4

We only support PostgreSQL 9.6 and up, see https://postgrest.org/en/stable/explanations/install.html#supported-postgresql-versions.

PostgreSQL only started supporting JSON functions since 9.3, so 7.4 is unfeasible to support.

---

I'm surprised we're not responding with an error though, we have:

postgrest/src/PostgREST/AppState.hs

Lines 337 to 343 in 87d6a0d

	Right version ->
	if version < minimumPgVersion then
	return . FatalConnectionError $
	"Cannot run in this PostgreSQL version, PostgREST needs at least "
	<> pgvName minimumPgVersion
	else
	return . Connected $ version

We could bring back pg 9.5 (#2038) to be sure we test the above.

[sseenivasan89]

@steve-chavez

Sorry my bad, i am using 15.3

[steve-chavez]

As per your error message, host seems incorrect below:

db-uri = "postgres://postgres:postgres@host:5432/my_db"

I suggest to try and connect with regular psql, then use the same connection string for PostgREST.

[sseenivasan89]

Hi @steve-chavez

Thanks, my bad i update the host as invalid one
I am able to connect the server, Thanks !