[GENERAL] WAL Streaming Failure PostgreSQL 9.4

2015-05-28 Thread Ivann Ruiz
I'm trying to setup streaming replication but I'm stuck, please help! I followed the steps in https://wiki.postgresql.org/wiki/Streaming_Replication On Master I have (postgresql.conf) archive_mode = on wal_level = archive max_wal_senders = 5 wal_keep_senders = 150 (pg_hba.conf) host replicatio

[GENERAL] Is my standby fully connected?

2015-06-01 Thread Ivann Ruiz
I just setup my databases and got this LOG: LOG: database system was shut down in recovery at 2015-06-01 13:31:21 EDT LOG: entering standby mode LOG: redo starts at 0/67000278 LOG: consistent recovery state reached at 0/67000350 LOG: record with zero length at 0/67000350 LOG: database system

[GENERAL] Automatic Failover

2015-06-02 Thread Ivann Ruiz
Hello everyone, I know most of you guys have plenty of experience with PostgreSQL, do any of you know a tool for windows that allows me to create an automatic failover system? I'm running Windows servers 2008 and 2012 and PostgreSQL 9.4. Thanks in advance for your time!