[GeoNetwork-devel] DR strategies with GeoNetwork and PostgreSQL

Hello Everyone,

I am about to start an install/migration of GeoNetwork for a University. The
database we are using is Postgresql 9.2 with PostGIS extensions. The ITS
department presented the following question regarding disaster recovery
policies to put in place for the Postgres database:

/DR options – There are two options for the Postgres DB (a) SVC replication
of the storage to our second site, which would require a DB consistency
check during failover or (b) implementing log-shipping replication. Do you
have any preference from an application viewpoint?/

Does anyone have any opinion on these options an which they should choose
for a GeoNetwork 2.10.2 install?

Cheers,
Byron

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/DR-strategies-with-GeoNetwork-and-PostgreSQL-tp5094071.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

I’d love to provide advice but I am afraid I have no expertise there :(… As far as I know it shouldn’t matter from the application’s point of view. The data access layer in Geonetwork 2.20 is pretty basic, raw SQL for the most part.

Jesse

···

On Fri, Dec 13, 2013 at 1:56 AM, ByronCinNZ <cochranes4@anonymised.com> wrote:

Hello Everyone,

I am about to start an install/migration of GeoNetwork for a University. The
database we are using is Postgresql 9.2 with PostGIS extensions. The ITS
department presented the following question regarding disaster recovery
policies to put in place for the Postgres database:

/DR options – There are two options for the Postgres DB (a) SVC replication
of the storage to our second site, which would require a DB consistency
check during failover or (b) implementing log-shipping replication. Do you
have any preference from an application viewpoint?/

Does anyone have any opinion on these options an which they should choose
for a GeoNetwork 2.10.2 install?

Cheers,
Byron


View this message in context: http://osgeo-org.1560.x6.nabble.com/DR-strategies-with-GeoNetwork-and-PostgreSQL-tp5094071.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.


Rapidly troubleshoot problems before they affect your business. Most IT
organizations don’t have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk


GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork