read only transaction?

When i connect to a neon endpoint, sometimes it seems to think its a read only transaction?

psql (16.1, server 16.4)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type "help" for help.

platform-indexer-f35t=> create table test( i int);
ERROR:  cannot execute CREATE TABLE in a read-only transaction
platform-indexer-f35t=>

psql (16.1, server 16.4)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type "help" for help.

platform-indexer-f35t=> create table test( i int);
ERROR:  cannot execute CREATE TABLE in a read-only transaction
platform-indexer-f35t=>

psql (16.1, server 16.4)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type "help" for help.

platform-indexer-f35t=> create table test( i int);
ERROR:  cannot execute CREATE TABLE in a read-only transaction
platform-indexer-f35t=>

psql (16.1, server 16.4)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type "help" for help.

platform-indexer-f35t=> create table test( i int);
ERROR:  cannot execute CREATE TABLE in a read-only transaction
platform-indexer-f35t=>

anyone know why and how to avoid this?

for some additional context, there are some connections to this endpoint that use read only transaction mode, but freshly created connections seem to also be created in read only mode for some reason. with other postgres databases, new connections are not created in read only mode (i.e. read only mode is only per connection/session, shouldnt persist across different connections)

read only transaction?

Similar Threads

Similar Threads

Similar Threads