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
