Update postgres client to match server (14/15)

Support Feature Requests
1

Describe your feature request
Currently, the default postgres client binaries on replit are a full version away from what Neon Provides. I encountered this when trying to run pg_dump to transfer a demo db contents from one replit to another.

What problem(s) would this feature solve?
access to other postgres CLI tools than psql.
It would be nice to share the postgres instance among replits, incidentally, as that solves my immediate problem, but I feel binaries should match anyway.

Explain what you were trying to do when you came across the problem leading to this feature request
On shell, with postgres enabled for that replit:

$ pg_dump
pg_dump: error: server version: 15.4; pg_dump version: 14.8
pg_dump: error: aborting because of server version mismatch
2 Likes
2

Iā€™m facing this same issue. Did you find a fix?

4

I think so:
Add _15 to the postgres package in your replit.nix
Nix official postgres package is still on 14.9.

~/EcoEng$ cat replit.nix 
{ pkgs }: {
  deps = [
    pkgs.duckdb
    pkgs.vim
    pkgs.postgresql_15
  ];
}