1
I am trying to create a database in Postgres, but is giving the following message
ERROR: cannot execute CREATE DATABASE in a read-only transaction
I’ve reinstalled and nothing.
I’ve already put off this line in the postgresql.conf file, but I don’t know how to restart the settings
default_transaction_read_only = off
'Cause to hear that’s what it is
I’m trying on the postgres user
I believe this can help
– Chance
Where can I run those commands? On DOS or SGBD?
– adventistaam
I believe in the SGBD.
– Chance
psql is the postgre shell. Postgre Docs
– Chance
I don’t know where to reach in his shell and in SGBD I can not type anything
– adventistaam
It comes installed with postgre just search on the pc. If it is windows, it will be in the postegre folder
– Chance
Have bin folder and date folder
– adventistaam
The bin folder is empty
– adventistaam
Vixi ai complica.
– Chance
Looks for PGADMIN in the C: Program Files folder Postgresql 9.5 bin the pgAdmin3.exe file (if your postgres is 9.5 and it is 64-bit). If not found in Program Files, search in Program Files (x86)
– user4701