Re: [GENERAL] Fully-automatic streaming replication failover when master dies?

2014-01-25 Thread Scott Marlowe
Please don't top post in technical discussions. On Sat, Jan 25, 2014 at 11:29 AM, Dmitry Koterov wrote: > > On Friday, January 24, 2014, Scott Marlowe wrote: >> >> On Thu, Jan 23, 2014 at 7:16 PM, Sameer Kumar >> wrote: >> > >> > >> > On Fri, Jan 24, 2014 at 1:38 AM, Susan Cassidy >> > wrote:

[GENERAL] any examples - sync offline json to server

2014-01-25 Thread john.tiger
scenario: download key data in json format to mobile - then use offline (ie in areas where no wifi available) - then when back in wifi range, sync with db server this is what pouch, couch offers but would like to do with postgresql if possible -- Sent via pgsql-general mailing list (pgsql-

Re: [GENERAL] pg_dump: dumpBlobs(): could not open large object: ERROR: large object 27729547 does not exist

2014-01-25 Thread Michael Paquier
On Fri, Jan 24, 2014 at 10:33 PM, Manoj Agarwal wrote: > Hi, > > > > I have a Postgresql-7.4.19 database in SQL_ASCII Encoding format. You should really consider an upgrade first... As mentioned by Kevin this version is outdated. The latest versions of pg_dump support servers down to 7.4 so an up

Re: [GENERAL] Fully-automatic streaming replication failover when master dies?

2014-01-25 Thread Dmitry Koterov
Failover is NOT about the RAID or SAN robusness mostly. It's about datacenters connectivity and network issues. If you lose one datacenter (it happens, and there is no aid for it), you should redirect all traffic to another DC ASAP and failover the master DB to it. When the disconnected DC is up ag

Re: [GENERAL] Exact Patch Version

2014-01-25 Thread Abdul Sayeed
Hi Bruce, Thank you for the information. Best Regards, Abdul Sayeed DBA - EnterpriseDB Skype: abdul.sayeed24 On Sat, Jan 25, 2014 at 9:44 AM, Bruce Momjian wrote: > On Sat, Jan 25, 2014 at 05:02:23AM +0530, Abdul Sayeed wrote: > > Hi All, > > > > Could any one please confirm me in which c