Home Error in Postgres TX
Reply: 0

Error in Postgres TX

user927
1#
user927 Published in May 27, 2018, 11:33 pm

Trying to create a user in the database and it's telling me that cannot execute **** in a read-only transaction. I have no idea what's causing this? Is this a bad state in the database or connection? Why is this telling that it's not in a transaction but then telling me it's a read-only transaction? Does "transaction" refer to the same thing?

$ psql --host localhost --port 5432 --username **** postgres --no-password -v dbuser=root -t -X
psql (10.1, server 9.4.13)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.

postgres=# set transaction read write;
WARNING:  SET TRANSACTION can only be used in transaction blocks
ERROR:  cannot set transaction read-write mode during recovery
postgres=# CREATE USER root WITH PASSWORD 'root';
ERROR:  cannot execute CREATE ROLE in a read-only transaction
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.305264 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO