[TCMUG] PostGIS backup strategies

[David William Bitner]

Phillipe,

I have had just fine luck using normal PostgreSQL backup strategies along
with PostGIS. For any relatively small (~20GB) I still prefer to have a
series of pg_dump backups since I like the ease of being able to go into a
backup and extracting a single table or function if I realize I hosed
something up in the live database. I generally use a purge strategy for the
dumps that keeps one a month for a year, one a year, and the last three
days around.

David


On Tue, Jul 22, 2014 at 11:12 AM, GrandNord <grandnord4reg at gmail.com> wrote:

> Hi all.
>
> I started a new job this month at East View. I'm pushing some fairly large
> raster data sets into PostGIS to back some WMS and WCS services.
> An issue that one of my new colleagues brought forward is that PostGIS
> might require different backup strategies than a standard Postgres DB. Does
> anyone have any insights on the issue? Have you had success or failures
> with specific backup strategies with PostGIS?
>
> As an aside, if anyone felt that this is a topic better discussed over
> brewed wheat, or fermented apple or grape juice, I would not be opposed to
> a meeting.
>
> Philippe Le Grand
> _______________________________________________
> Tcmug mailing list
> Tcmug at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/tcmug
>



-- 
************************************
David William Bitner
dbSpatial LLC
612-424-9932
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/tcmug/attachments/20140723/34db7580/attachment.html>