Re: [ADMIN] Safe to put indexes in tablespaces on raid0 disk?

2012-03-05 Thread Nicholson, Brad (Toronto, ON, CA)
-Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- ow...@postgresql.org] On Behalf Of Rural Hunter Sent: Monday, March 05, 2012 8:28 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Safe to put indexes in tablespaces on raid0 disk? I want to separate

Re: [ADMIN] Best practise for upgrade of 24GB+ database

2012-01-23 Thread Nicholson, Brad (Toronto, ON, CA)
-Original Message- From: francis picabia [mailto:fpica...@gmail.com] Sent: Friday, January 20, 2012 3:39 PM To: Nicholson, Brad (Toronto, ON, CA) Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Best practise for upgrade of 24GB+ database In the past I've used Slony to upgrade

Re: [ADMIN] Best practise for upgrade of 24GB+ database

2012-01-20 Thread Nicholson, Brad (Toronto, ON, CA)
-Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- ow...@postgresql.org] On Behalf Of francis picabia Sent: Friday, January 20, 2012 1:12 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] Best practise for upgrade of 24GB+ database How do others

Re: [ADMIN] Question about multiple slaves and Master loss.

2011-12-07 Thread Nicholson, Brad (Toronto, ON, CA)
From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Chris Hoover Sent: Wednesday, December 07, 2011 12:05 PM To: pgsql-admin@postgresql.org Admin Subject: [ADMIN] Question about multiple slaves and Master loss. I'm pretty sure that the answer to this

Re: [ADMIN] Question about multiple slaves and Master loss.

2011-12-07 Thread Nicholson, Brad (Toronto, ON, CA)
-Original Message- From: Evan Rempel [mailto:erem...@uvic.ca] Sent: Wednesday, December 07, 2011 1:12 PM To: Nicholson, Brad (Toronto, ON, CA) Cc: Chris Hoover; pgsql-admin@postgresql.org Admin Subject: Re: [ADMIN] Question about multiple slaves and Master loss. Can you have

Re: [ADMIN] transaction error handling

2011-11-30 Thread Nicholson, Brad (Toronto, ON, CA)
-Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- ow...@postgresql.org] On Behalf Of Rob Richardson Sent: Tuesday, November 29, 2011 1:35 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] transaction error handling Very naïve question here: Why

Re: [ADMIN] transaction error handling

2011-11-29 Thread Nicholson, Brad (Toronto, ON, CA)
-Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- ow...@postgresql.org] On Behalf Of Kasia Tuszynska Sent: Tuesday, November 29, 2011 3:35 PM To: Kevin Grittner; pgsql-admin@postgresql.org Subject: Re: [ADMIN] transaction error handling Hi Kevin,

Re: [ADMIN] initdb fails on AIX

2011-08-11 Thread Nicholson, Brad (Toronto, ON, CA)
-Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- ow...@postgresql.org] On Behalf Of Tom Lane Sent: Wednesday, August 10, 2011 4:22 PM To: CS DBA Cc: PG Admin Subject: Re: [ADMIN] initdb fails on AIX CS DBA cs_...@consistentstate.com writes: On

Re: [ADMIN] pg_stat_all_tables column value reseting problem.

2011-03-22 Thread Nicholson, Brad (Toronto, ON, CA)
-Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- ow...@postgresql.org] On Behalf Of leslie samuel Sent: Saturday, March 19, 2011 8:49 AM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] pg_stat_all_tables column value reseting problem. For

Re: [ADMIN] Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?

2011-03-22 Thread Nicholson, Brad (Toronto, ON, CA)
-Original Message- From: Tapio Pitkäranta [mailto:tapio.pitkara...@relex.fi] Sent: Monday, March 21, 2011 7:53 AM To: Nicholson, Brad (Toronto, ON, CA) Cc: pgsql-admin@postgresql.org; Devrim GÜNDÜZ Subject: RE: [ADMIN] Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB

Re: [ADMIN] pg_stat_all_tables column value reseting problem.

2011-03-18 Thread Nicholson, Brad (Toronto, ON, CA)
-Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- ow...@postgresql.org] On Behalf Of leslie samuel Sent: Friday, March 18, 2011 1:17 AM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] pg_stat_all_tables column value reseting problem. Thanks for ur

Re: [ADMIN] Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?

2011-03-18 Thread Nicholson, Brad (Toronto, ON, CA)
-Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- ow...@postgresql.org] On Behalf Of Tapio Pitkäranta Sent: Friday, March 18, 2011 4:10 AM To: Devrim GÜNDÜZ Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Memory limits and PostgreSQL 8.4 - Over 63 GB

[ADMIN] Determining the WAL file needed by a standby

2011-02-09 Thread Nicholson, Brad (Toronto, ON, CA)
Hi, Once I've shut down a streaming replica standby, is there a way from the master I can tell which WAL file is going to be the earliest one needed in order for the replica to catch back up? What I want to do is be able to automatically detect if that WAL file is still around so that the