Hi im trying to setup persistance and visibility in postgres
I have a limitation that my production postgres cannot be reached from my network and my bastion server does not allow me to install Go and make , hence i cannot use temporal sql tool to setup schema
Are there list of sql commands thet i can run to setup schema correctly ,
I have already executed below sql file
https://github.com/temporalio/temporal/blob/v1.7.0/schema/postgresql/v96/temporal/schema.sql
Here is the error im facing
Error returned: received non-nil error from function "go.temporal.io/server/temporal".ServerOptionsProvider
/home/builder/temporal/temporal/fx.go:173:
sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: pq: relation "schema_version" does not exist
[Fx] ERROR Failed to initialize custom logger: could not build arguments for function "go.uber.org/fx".(*module).constructCustomLogger.func2```