[GENERAL] Long-running query on replica not timing out

eplication ground to a halt until we terminated the query (which triggered crash recovery). Are we seeing something abnormal or unexpected here? It caught us by surprise… Thank you, Andrew Hannon -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] Amazon High I/O instances

Just looking into High IO instances for a DB deployment. In order to get past 1TB, we are looking at RAID-0. I have heard (http://hackerne.ws/item?id=4266119) there might be a problem if TRIM isn't supported. Does anyone know if it is and has anyone used RAID-0 on these instances? (Linux of cou

[GENERAL] Streaming Replication Error

this error? Too much time between log recovery, streaming startup and a low wal_keep_segments value (currently 128)? Thank you very much, Andrew Hannon -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] PG 9.0 EBS Snapshot Backups on Slave

command to retain logs in a transient location when I am in "snapshot mode", and then ship them in bulk once the snapshot has completed? Are there any other remedies that I am missing? Thank you very much for your time, Andrew Hannon -- Sent via pgsql-general mailing list (pgsql-ge

[GENERAL] Repercussions of Cancelled Autovacuum

Hello, We have a large(ish) table that had a series of delete statements executed against it (culling most of the rows in the table). This triggered a time consuming autovacuum, which we allowed to run for 2+ days (and were planning to allow to run to completion). However, it ended up getting c

[GENERAL] Two 9.1 Questions

Hello, Now that 9.1 has been released, I have two questions: 1. Can we upgrade a 9.0 hot standby (replicating from a 9.0 master) to a 9.1 standby while still replicating from the 9.0 master? Are there any version differences that would cause a problem? We would then eventually promote the 9.1

[GENERAL] Adding Additional Standby

Hello, We have an existing master-slave setup running on 9.0. I was looking into adding a new hot standby into this setup — I have added a script that satisfies the requirements of the archive_command, but it isn't clear to me how to add this new standby into the mix. Is it as simple as calling