Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [postgresql-cluster]

17 questions
4
votes
0 answers

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/postgresql/data/9.4/main 9.4 main -- -W -A md5 #…
Dawid
  • 186
  • 1
  • 7
3
votes
1 answer

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 different tablespace (residing on a different volume),…
jishi
  • 868
  • 2
  • 11
  • 25
2
votes
0 answers

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 did not have any failover mechanism in place,…
deepankardixit90
  • 153
  • 2
  • 7
1
vote
1 answer

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" which resulted in "Error: could not get cluster…
Sysadminguy
  • 11
  • 1
1
vote
1 answer

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.6.8, i'm wondering if i use: pg_upgradecluster 9.4…
fantasia
  • 13
  • 2
1
vote
1 answer

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 being reported to /var/lib/pgsql/9.3/pgstartup.log…
Phuong Nguyen
  • 703
  • 1
  • 12
  • 27
1
vote
0 answers

How to setup/make Haproxy send read-write request based on REST method

How to setup/make Haproxy send read-write request coming on same port 5432 from application, to backend servers of postgres-patroni cluster based on REST method. I have three node postgres-patroni cluster running as docker service/containers behind…
charlie
  • 31
  • 1
  • 2
0
votes
1 answer

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 master. I have lifecheck method of heartbeat and…
virullius
  • 1,048
  • 1
  • 9
  • 23
0
votes
1 answer

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 initdb can not be found on the server, I tried as…
ibi0tux
  • 161
  • 1
  • 7
0
votes
1 answer

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 postgresql 8.4 to postgresql 9.4 in different server…
Phong Đặng
  • 53
  • 1
  • 5
0
votes
1 answer

How to catch the error output in shell when error code is not enough?

I came across the script with if-else branch with a particular command succeed or not like this: pg_ctl -D /var/lib/pgsql/data -w promote if [ $? -ne 0 ]; then echo: failure exit 1 else echo: succeed exit 0 fi It looks straight forward.…
George Y
  • 528
  • 6
  • 16
0
votes
1 answer

HAProxy and postgres

My haproxy configuration is as below, in the backend there is pg_autoctl cluster, another VM (bunty4) hosts the monitor and haproxy is installed on it. global maxconn 100 defaults log global mode tcp retries 2 timeout client…
uozzyy
  • 23
  • 3
0
votes
1 answer

Which command to restart postgresql 12 service

I am about to restart postgresql 12 service running on Ubuntu 18. First, I check it's status : sudo service postgresql status. Its says : postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/systemd/system/postgresql.service; disabled;…
padjee
  • 1
0
votes
1 answer

Patroni Haproxy and pg-bouncer architecture

I'm building a patroni postgres cluster, however, I can't decide which is better architecture App > HAproxy > Pgbouncer > PostgreSQL (patroni) App > PGBouncer > HAproxy > PostgreSQL (patroni) I can't seem to get an answer upon my search and a lot of…
Nullyinthesky
  • 1
0
votes
0 answers

gvmd service not starting after postgresql replication - openvas

I deployed two openvas servers on two distinct VMs (Debian 10) with postgresql version 11. I replicated the postgres 11 using with hot standby configuration, the data is getting replicated but after the replication, gvmd service & gsad service goes…
xchan4
  • 1
1
2