Re: [GENERAL] async streaming and recovery_target_timeline=latest

2013-07-28 Thread Ben Chobot
Anybody? On Jul 3, 2013, at 3:23 PM, Ben Chobot wrote: > We have an async streaming setup using 9.1.9 and 3 nodes - let's call them A, > B, and C. A is the master, B and C are slaves. Today, A crashed, so we made B > be the master and told C to follow along with the switch by changing the > pr

Re: [GENERAL]

2013-07-28 Thread Ashish Karalkar
wow! http://cochesclasicosparabodas.com/cnn.com_world.html mjfamywelicjnyqepohu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] async streaming and recovery_target_timeline=latest

2013-07-28 Thread Amit Langote
On Mon, Jul 29, 2013 at 3:02 AM, Ben Chobot wrote: > Anybody? > > On Jul 3, 2013, at 3:23 PM, Ben Chobot wrote: > > We have an async streaming setup using 9.1.9 and 3 nodes - let's call them > A, B, and C. A is the master, B and C are slaves. Today, A crashed, so we > made B be the master and told

Re: [GENERAL] SQL for multimedia retrieval

2013-07-28 Thread Rahila Syed
Hello, Yes. Multimedia data can be stored in PostgreSQL database using either bytea and BLOB types. Depending on size either can be used. BLOB is meant for storing large data. Various interfaces are provided to access such data. Following link can be referred for that. http://www.postgresql.org/d

Re: [GENERAL] Snapshot backups

2013-07-28 Thread James Sewell
Hey all, I understand that I have already been given an answer here, but I am still curious as to why this is the case (perhaps I should ask this on the hackers list though, if so let me know). More importantly I'd like to understand why I would need to use the start/stop backup commands to ensur

Re: [GENERAL] Snapshot backups

2013-07-28 Thread Amit Langote
On Mon, Jul 29, 2013 at 3:32 PM, James Sewell wrote: > Hey all, > > I understand that I have already been given an answer here, but I am still > curious as to why this is the case (perhaps I should ask this on the > hackers list though, if so let me know). > > More importantly I'd like to understa

Re: [GENERAL] Trigger and deadlock

2013-07-28 Thread Loïc Rollus
Hi, Thanks for your quick reply! I found the table. But the ctid of the row has changed. But during my test, I update only 1 row from this table, so I know the row. I had already put log_statement to 'all'. It's strange because in the log, I only see simple "SELECT ... FROM" on this table (no UPD