[ADMIN] upgrades and streaming replication

2013-09-10 Thread Charles Sprickman
I just wanted to check if there are any updates on the preferred way to upgrade a group of servers that are using streaming replication with minimal downtime. Mailing list messages from a year or two ago pretty much state the following: * No current plans to come up with some new mechanism to

Re: [ADMIN] Opinions on SSDs

2013-08-12 Thread Charles Sprickman
On Aug 12, 2013, at 4:15 PM, Lonni J Friedman wrote: On Mon, Aug 12, 2013 at 1:05 PM, Bruce Momjian br...@momjian.us wrote: On Mon, Aug 12, 2013 at 08:33:04AM -0700, Joshua D. Drake wrote: 1) Has anyone had experience with Intel 520 SSDs? Are they reliable? When they fail, do they fail

Re: [ADMIN] Installing multiple instances of Postgred on one FreeBSD server

2013-05-08 Thread Charles Sprickman
On May 8, 2013, at 11:32 AM, Jim Mercer wrote: On Wed, May 08, 2013 at 05:29:53PM +0300, Achilleas Mantzios wrote: 1st the above links do not reveal anything new. 2nd, judging by the wiki : https://wiki.freebsd.org/Jails , jailified SysV IPC (or SysV IPC-ified jails) (the specific territory

[ADMIN] logging full queries separately

2013-02-22 Thread Charles Sprickman
Howdy, I've been finding that keeping full query logs is quite helpful; I started doing this to be able to run pgbadger each day to get a nice overview of what's going on with the db servers. The one huge downside to this is that the logs are so noisy, it's hard to track down errors and stats