Questions tagged [postgresql-cluster]
13 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
#…
![](../../users/profiles/60209.webp)
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),…
![](../../users/profiles/11430.webp)
jishi
- 858
- 1
- 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,…
![](../../users/profiles/149153.webp)
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…
![](../../users/profiles/467211.webp)
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…
![](../../users/profiles/461625.webp)
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…
![](../../users/profiles/33163.webp)
Phuong Nguyen
- 703
- 1
- 11
- 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…
![](../../users/profiles/570302.webp)
charlie
- 21
- 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…
![](../../users/profiles/405852.webp)
virullius
- 988
- 8
- 22
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…
![](../../users/profiles/319929.webp)
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…
![](../../users/profiles/252241.webp)
Phong Đặng
- 53
- 1
- 5
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…
![](../../users/profiles/947540.webp)
xchan4
- 1
0
votes
0 answers
How to switch standby to master on postgresql 13?
For High Availability on DB was build Active-Standby(replica) cluster on Postgresql-13. Inserting data correctly transfer to 'replica' server, it is ok.
Now, I want check case, how i can make change roles on two servers.
for this I the…
![](../../users/profiles/700646.webp)
Red Hat
- 5
- 2
0
votes
1 answer
Patroni Postgres Cluster, what does 'TL' mean in the output of 'patronictl list'
Executing.
patronictl list
Produces
+ Cluster: psql-core03-uat-kong (6867488892458676291) ------+----+-----------+
| Member | Host | Role | State | TL | Lag in MB…
![](../../users/profiles/561199.webp)
englishPete
- 123
- 8