[postgis-users] outgrowing the standard Pg install

Mark Vantzelfde netmasters.ma at gmail.com
Tue Apr 6 03:48:36 PDT 2010


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 <punk.kish at gmail.com> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100406/e0785b05/attachment.html>


More information about the postgis-users mailing list