Re: [GENERAL] Growing a live database

2011-05-06 Thread Scott Marlowe
On Fri, May 6, 2011 at 7:27 AM, Rick Genter wrote: > I have a PostgreSQL 8.4.4 database that is running 24/7. The drive that the > database is on is becoming full and I need to expand it. We are currently > doing log-shipping of the WAL files to a slave system to run in a hot > standby mode. I hav

Re: [GENERAL] Growing a live database

2011-05-06 Thread Vick Khera
On Fri, May 6, 2011 at 9:27 AM, Rick Genter wrote: > I believe that this accomplishes the goal (increasing available drive space) > with a minimum amount of down time. Am I thinking correctly, or have I > missed something? > That is the general procedure you would follow to perform maintenance on

[GENERAL] Growing a live database

2011-05-06 Thread Rick Genter
I have a PostgreSQL 8.4.4 database that is running 24/7. The drive that the database is on is becoming full and I need to expand it. We are currently doing log-shipping of the WAL files to a slave system to run in a hot standby mode. I have two servers: S1 (currently running as master) and S2 (curr