Provisioned test environments are not running PostgreSQL 18, causing migrations using uuidv7() to fail

[VKWHM]

Is there an existing issue for this?

• I have searched the existing issues

What part(s) of Encore does this bug report apply to?

• Encore.ts (TypeScript)
• Encore.go (Go)
• Encore CLI
• Local Development Dashboard
• Encore Cloud

Current behavior

There appears to be a mismatch between local development environments and provisioned test environments.

Locally, Encore is using PostgreSQL 18, where the native uuidv7() function is available. However, provisioned environments used for testing appear to be running an older PostgreSQL version that does not support uuidv7().

Example migration:

ALTER TABLE "refresh_tokens" ALTER COLUMN "family_id" SET DEFAULT uuidv7();

Error:

could not migrate database dencheckout-auth-db_template: migration failed: function uuidv7() does not exist in line 0: ALTER TABLE "refresh_tokens" ALTER COLUMN "id" SET DEFAULT uuidv7();--> statement-breakpoint

Minimum reproduction code

No response

Steps to reproduce

No response

Expected behavior

Provisioned environments should use the same PostgreSQL major version as local development environments, or at minimum the documentation should clearly state the PostgreSQL version differences and any unsupported features.

Encore CLI version

1.57.6

Node.js version

25.8.2

In which operating systems have you tested?

• macOS
• Windows
• Linux

Other

No response

[ekerfelt]

Test environments are using Neon, which up until a few weeks ago didn't have a stable PSQL 18 available. They now seem to have released stable support for it, so I'll go ahead and see if we can bump it.