All Questions
Tagged with postgresql-9.2 replication
16 questions
1
vote
1
answer
2k
views
How to identify file for "The system cannot find the file specified." during a pg_ctl -D start?
I'm getting one message during pg_ctl -D start of the standby server. Perhaps more of a general troubleshooting question.
This is what I'm seeing when I do a pg_ctl -D start:
D:\>pg_ctl -D d:\...
- 635
3
votes
1
answer
16k
views
When can I clean up archived WAL files?
I need some help understanding the how archived WAL files are used and when I can clean them up.
Currently we have a master database replicating to a slave, but every so often our master database ...
- 133
3
votes
0
answers
508
views
Recovery from Live to a new Slave Server - PostgreSQL - ERROR
I've started a new SLAVE PostgreSQL server set up.
master: 192.168.100.1
slave1: 192.168.100.2
slave2(NEW SLAVE) 192.168.100.3
* NOTE: I run the pg_basebackup from another STANDBY SERVER. Not from ...
- 31
1
vote
1
answer
975
views
Postgresql Streaming replication - monitoring
I have setup streaming replication for my postgres servers. I am using PostgreSQL 9.2.6. Replication seems to be working fine. I am monitoring this with two ways using nagios:
Log_delay and
Byte_lag
...
- 11
4
votes
1
answer
10k
views
How to determine whether a PostgreSQL Hot Standby is fully mirrored?
I have set up a hot standby of a PostgreSQL server. It all seems to be working, but I just want to be sure that I'm not missing something. In /var/lib/pgsql/9.2/data/pg_log/postgresql-Wed.log I have ...
- 43
5
votes
2
answers
2k
views
How to measure or estimate the streaming replication lag in Postgres 9.2
I've been asked to reverse engineer an app that uses postgresql in the back end.
I can see that there is some database replica
tion going on... based on my reading, I *think it's called streaming ...
- 781
0
votes
1
answer
721
views
PostgreSQL replication with periodic log shipping
I'm using Windows Server 2008 R2 with 64-bit PostgreSQL 9.2 on both test machines. What I wish to achieve is that one server will be a master and other will be a slave. This is just for tests, finally ...
- 101
1
vote
1
answer
4k
views
Streaming replication between postgresql 9.2 and 9.3
Does anyone know if it's problematic to have a postgresql 9.3 slave setup to do streaming replication from a postgresql 9.2 master?
- 971
4
votes
1
answer
646
views
Postgresql 9.2.6 ignoring archive_command
I'm attempting to set up a 3-server chain by leveraging WAL-E. I've done this in the past with replication/wal segments and I'm attempting the exact same method, just with using WAL-E in between.
My ...
- 188
2
votes
2
answers
4k
views
Setting up binary replication between two PostgreSQL instances
I have two virtual machines: dbrepa (-.175) and dbrepb (-.191).
Both have PostgreSQL 9.2 installed; once PG was installed (never initialized) on dbrepa, dbrepb was made as a clone.
I need to have the ...
- 207
2
votes
1
answer
265
views
changing server roles in streaming replication
I want to implement streaming replication using postgresql-9.2.4 in my reporting application. I came stuck on the below scenario.
create master and slave with synchronous replication which is working ...
- 21
2
votes
1
answer
705
views
Do I need to perform any tasks after Postgres goes into recovery mode?
For starters, I do not have any sort of automated failover in place.
After two scenarios, I'm unsure of the state of the database and any required actions, if any, to take:
My master server ...
- 1,209
4
votes
1
answer
813
views
Why aren't my Postgres WAL segments (up to the point of turning on archiving) being archived?
The pg_xlog directory for my master cluster looks like this:
-rw------- 1 postgres postgres 16M Jun 21 21:42 000000010000000000000001
-rw------- 1 postgres postgres 16M Jun 21 22:42 ...
- 1,209
0
votes
1
answer
939
views
How to install and configure Postgres-XC in windows?
Can anybody suggest me any resources of the complete installation procedure of postgres-XC in windows. I've installed postgresql-9.2 in my windows and can use it. Now I need to know the installation ...
- 1
6
votes
1
answer
5k
views
Is replication from SQL Server 2008 to PostgreSql possible?
Is it possible ? Sql Server as publisher(master) and PostgreSql as slave(subscriber) ? Any type of replication really.
- 557