Questions tagged [postgresql-cluster]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
58 views

Unable to create cluster with repmgr for postgrSQL

I follow this guide to setup. https://medium.com/@victor.boissiere/how-to-setup-postgresql-cluster-with-repmgr-febc2f10c243 Everythings going fine but when come to here sudo -i -u repmgr rm -rf /...
0
votes
0answers
25 views

What is the Best size shared_buffers, max_connections ,work_mem in postgresql in windows server? [duplicate]

I have a 18 GB database which is increasing day by day. Server configuration is- 128 GB RAM , 2TB SSD drive, 12 CORE Processor and 64 bit Windows Server 2017. There are 400 users in software and ...
0
votes
1answer
79 views

pgpool watchdog and too many masters

I am trying to deploy pgpool in native replication mode with watchdog to manage 2 nodes for Active-Standby. When I start pgpool2 on both servers, they each claim to be the only node alive and become ...
1
vote
1answer
348 views

pg_upgradecluster fails with “Error: could not get cluster locales”

I'm trying to upgrade postgres cluster from 9.5 to 10 Steps I did: installed postgresql-10 and postgresql-client-10 removed new default 10 main cluster used command "pg_upgradecluster 9.5 main" ...
0
votes
1answer
332 views

pg_upgradecluster to specific version? ( more than 2 version )

Theres a way to upgrade a cluster of postgreSQL to specific version?. An example: I have a 9.4.17 - 9.6.8 and 10.3 The 10.3 has cluster on The 9.4.17 has cluster on I need upgrade the 9.4.17 to 9....
0
votes
1answer
347 views

PostgreSQL installation under debian

I'm trying to install PostgreSQL server on a server running debian8. I installed the package postgresql-9.5 with apt, but it seems like there are missing programs. I tried to create a cluster but ...
4
votes
0answers
4k views

Postgresql 9.4 clusters not auto starting on Debian

I have Debian 8.2 x64 and Postgresql 9.4 (from repo). I've recreated default cluster in different location like this: # service postgresql stop # pg_dropcluster 9.4 main # pg_createcluster -d /srv/...
2
votes
0answers
572 views

How to automate failover of master in PostgreSQL 9.5 on Windows?

I have 4 nodes (version - PostgreSQL 9.5 Beta) in a slot replication set up. Recently the master node, due to less disk space available, PostgreSQL started throwing errors and crashed in the end. As I ...
2
votes
1answer
1k views

Changing tablespace on table with streaming replication

I've been searching for answers for a while know but can't find any reliable source. We have 2 postgres servers that replicates using streaming replication. I now need to move some tables to a ...
0
votes
1answer
2k views

Migrate data from postgresql 8.4 to postgresql 9.4 in 2 different servers

I have a problem with postgresql as below: I have a server CentOS 5.9 install postgresql 8.4. It is running for my production and Data Size = 300 GB. At the moment, I need migrate all data in ...
1
vote
1answer
10k views

PostgreSQL failed to start, pg_log shows nothing, what to do?

I've just setup PostgreSQL (9.3) as a replication to another server. When I started it with service postgresql-9.3 start, it reported [FAILED] without any further explanation. I don't see any thing ...