Puneet, a posting to the ADMIN list pgsql-admin will likely get you some good ideas.
On Tue, Apr 6, 2010 at 2:21 AM, P Kishor <[email protected]> wrote: > If my database grows beyond what is available on PostGIS/Pg computer, > what are my options? Can I add more drives to the computer and have > part of the database on one disk and another part on another disk? Or, > do I have to plan ahead, chop up my database into disk-sized chunks, > and install each chunk on separate machines? Here is an illustration > -- > > computer 1: Single disk, 1 TB space available, PGDATA in > /usr/local/pgsql/data > > database is going to 5 TB eventually. I start on computer 1, when that > is filling up, I add external disks, so Postgres can just write > spillover from /usr/local/pgsql/data to /external/pgsql/data (is this > even possible?) > > OR > > computer 1: 1 TB space > computer 2: 1 TB space > .. and so on > > I divide my database into 1 TB chunks, install five instances of > PostGres/PostGIS on the five computers (what a nightmare) > > > > -- > Puneet Kishor > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
