Create database

Question

Asked 6 years, 3 months ago

Viewed 41 times

0

I’m trying to create a database on postgres but am getting the following message:

ERROR: cannot set transaction read-write mode During Recovery

I have uninstalled, cleaned the registry, installed put new password, but it always rescues users who were already installed and previous databases

I would like to have permission to create database or even reset everything start again, but with permission to create databases.

I’m using Pgadmin III, with Postgres 10 64bits, on Windows

It looks like you’re connected to a cluster configured as read-only replica.

– Camilo Santos

2018/08/20 at 13:42
I’ve seen this message somewhere before...

– adventistaam

2018/08/20 at 15:32
There’s a way I can create a place without being replicated?

– adventistaam

2018/08/20 at 15:41
The standard of postgres is to be installed normal, without being replicated. I know very little about replication, so I can’t tell you exactly what to set up to disable. As it is local, why not install postgres from the beginning and then restore a database backup?

– Camilo Santos

2018/08/20 at 16:24
I have uninstalled and reinstalled but it always recovers the previous data,

– adventistaam

2018/08/20 at 16:30
Was a different date folder used? Settings are in postgresql.conf.

– Camilo Santos

2018/08/20 at 16:32
The folder was even deleted rs

– adventistaam

2018/08/20 at 17:22

No answers

Browser other questions tagged postgresql windows pgadmin3

You are not signed in. Login or sign up in order to post.