[GENERAL] Constraint allowing value up to 2 times but no more than 2 times

2015-10-12 Thread Dara Unglaube
Greeetings. I'm trying to come up with a way to allow one column to have the same value up to two times, but no more than two times. I attempted adding a constraint to check the count of the value in the field - count (trsqqq) <=2 but aggregate functions are not allowed in constraints. Is there

Re: [GENERAL] Rebuild streaming replication

2015-03-13 Thread Dara Unglaube
5:05 PM, Dara Unglaube wrote: We had two servers set up with streaming replication. I believe when we did a full vacuum analyze to the database on the master, it caused the slave to not be able to catch up (wal_keep_segments = 32, but still not enough and had archive off). I am trying to re

[GENERAL] Rebuild streaming replication

2015-03-12 Thread Dara Unglaube
We had two servers set up with streaming replication. I believe when we did a full vacuum analyze to the database on the master, it caused the slave to not be able to catch up (wal_keep_segments = 32, but still not enough and had archive off). I am trying to re-set up the slave to streaming

Re: [GENERAL] Streaming Replication - changing IP addresses

2014-12-09 Thread Dara Unglaube
...@hogranch.com wrote: On 12/8/2014 11:56 AM, Dara Unglaube wrote: We have streaming replication set up on two servers that are on our local network using their external/public IP addresses. We are switching internet providers and need to change the external/public IP addresses of both servers

[GENERAL] Streaming Replication - changing IP addresses

2014-12-08 Thread Dara Unglaube
Greetings. We have streaming replication set up on two servers that are on our local network using their external/public IP addresses. We are switching internet providers and need to change the external/public IP addresses of both servers. I'm not sure how to go about this correctly. 1. Our