Re: [GENERAL] pgAdmin shows two servers with the identical data

2013-04-28 Thread Jasen Betts
On 2013-04-28, Bob Futrelle bob.futre...@gmail.com wrote: --001a11c2f448244d3504db64b5d7 Content-Type: text/plain; charset=ISO-8859-1 I have two PG servers with the same data. I know the data is the same, because if I change a value in a table on one server, it changes the value in a table

Re: [GENERAL] pgAdmin shows two servers with the identical data

2013-04-28 Thread Ian Lawrence Barwick
013/4/28 Bob Futrelle bob.futre...@gmail.com: I have two PG servers with the same data. I know the data is the same, because if I change a value in a table on one server, it changes the value in a table with the same name in the other server. in pgAdmin III: Properties for server Local

[GENERAL] Missing WAL files - file-based replication

2013-04-28 Thread Scott Briggs
So we're using 8.3 with file-based replication using rsync to a warm backup server. The problem is the backup server crashed and somehow WAL files got lost so the backup server is continuously looking for WAL files that are no longer available on the master. My question is, how can I skip to a

Re: [GENERAL] Missing WAL files - file-based replication

2013-04-28 Thread Tom Lane
Scott Briggs scott...@gmail.com writes: So we're using 8.3 with file-based replication using rsync to a warm backup server. The problem is the backup server crashed and somehow WAL files got lost so the backup server is continuously looking for WAL files that are no longer available on the

Re: [GENERAL] regex help wanted

2013-04-28 Thread matt
On 2013-04-25, Karsten Hilbert karsten.hilb...@gmx.net wrote: On Thu, Apr 25, 2013 at 10:32:26AM -0400, Tom Lane wrote: Karsten Hilbert karsten.hilb...@gmx.net writes: What I don't understand is: Why does the following return a substring ? select substring ('junk $allergy::test::99$

Re: [GENERAL] apt.postgresql.org broken dependency?

2013-04-28 Thread Martín Marqués
2013/4/26 Richard Huxton d...@archonet.com: On 25/04/13 18:01, Martín Marqués wrote: Just tried upgrading and added the apt-postgresql.org repo to my Debian server (on testing now) and I got some backages like barman retained because some dependencies couldn't be satisfied. Los siguientes

Re: [GENERAL] Implementing DB2's distinct types

2013-04-28 Thread Simon Riggs
On 21 April 2013 12:17, Thomas Kellerer spam_ea...@gmx.net wrote: DB2 lets you define your own types (just as Postgres) but with the added benefit that you can mark them such that they are _not_ comparable, e.g. to avoid comparing apples to oranges. Sounds like an interesting feature we might

Re: [GENERAL] Checking for changes in other tables

2013-04-28 Thread CR Lender
Sorry for the late reply, I had to give this some time to digest. I'm still trying to wrap my head around the concept that triggers don't belong to a table... On 2013-04-26 17:15, Richard Huxton wrote: On 26/04/13 10:01, CR Lender wrote: I think this is more a problem of terminology rather than