Re: [ADMIN] compare integer to inet

2011-08-21 Thread Dimitri Fontaine
Bill MacArthur writes: > The reason I ask for this is that we have a dataset that contains > ranges of IP addresses, associated with countries, where the addresses > are represented as integers (bigints). I would then use the ip4r extension, which is very very good for that kind of things. htt

Re: [ADMIN] Validate standby against master

2011-08-21 Thread Dimitri Fontaine
A J writes: > What are the various ways in which I can validate that a standby (new or > existing) is caught-up with the master ? For streaming replication setup in > v9.x You could use repmgr to monitor your standby: http://repmgr.org/ https://github.com/greg2ndQuadrant/repmgr postgres@

Re: [ADMIN] Question on Postgres Index internals

2011-08-21 Thread A J
So I assume there is no redundant information stored such as checksum to validate the files against the stored checksums. I don't have an active issue. Just trying to understand in detail how Postgres behaves under index corruption. From: Craig Ringer To: A J