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
an
o
> delete the contents of the data directory on the slave first):
>
> pg_basebackup -D -c -P -h -U
>
>
> 4. If your config files are in your data directory of the master, they'll
> all be replicated over as well - if they are not then you'll need to copy
> them over by
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
replica
hanks so very much!
Dara
On Mon, Dec 8, 2014 at 2:11 PM, John R Pierce 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
> provi
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 loc
