[OSGeo-Discuss] database replication
Kind Sirs, Being a novice postgreSQL user, i'm currently transfering from our current esri/arcsde/arcims/mssqlserver solution to a postgres/postgis/mapserver/openlayers solution. After this is down, the real server will be using software that is replicated in virtual machines used on external harddrives with a copy of the real server database. What I need to know is how should I execute a command, be it in the command line (prefferable because of scripting) or using some kind of gui tool like pgadminIII to let the virtual database get in sync with the real database when the external harddrive is connected to the real server. I've looked up sqlworkbench (no ubuntu binary) and slony (has to be compiled). I'm considering asking Ricardo from the GISVM project if he is available to help me think up a solution for this, you never know. Thanks in advance, Carlos ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] database replication
This might help: http://www.archaeogeek.com/blog/2008/11/21/database-replication/ Regards Chris - carlos sousa springal...@gmail.com wrote: Kind Sirs, Being a novice postgreSQL user, i'm currently transfering from our current esri/arcsde/arcims/mssqlserver solution to a postgres/postgis/mapserver/ openlayers solution. After this is down, the real server will be using software that is replicated in virtual machines used on external harddrives with a copy of the real server database. What I need to know is how should I execute a command, be it in the command line (prefferable because of scripting) or using some kind of gui tool like pgadminIII to let the virtual database get in sync with the real database when the external harddrive is connected to the real server. I've looked up sqlworkbench (no ubuntu binary) and slony (has to be compiled). I'm considering asking Ricardo from the GISVM project if he is available to help me think up a solution for this, you never know. Thanks in advance, Carlos ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss -- Files attached to this email may be in ISO 26300 format (OASIS Open Document Format). If you have difficulty opening them, please visit http://iso26300.info for more information. ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [Qgis-user] Re: [OSGeo-Discuss] augmenting donations
Thank you Andreas. Andreas Neumann ha scritto: I am just trying to help you guys to understand how government agencies or companies often work (exceptions are always possible). It is important to educate managers regarding the open-source development model. They are just not used to it and at the first glimpse they can find it strange - even if it is to their advantage. Yes, we are fully aware of this. That's why we start raising awareness on these themes - a (modest) cultural change will do much to the future of QGIS. One may discuss if QGIS/GRASS (or other projects) could offer yearly support contracts. It may help to raise additional money in some cases. It is important to distinguish such contracts from their fully commercial counterparts. Customers shouldn't be forced into paying those fees/contracts - but they may fell better with paying them. Probably, such contracts, would have to be done by individual companies - or could the steering board coordinate such activities? IMHO mixing core development with paid support is not very good. Several companies offer commercial, professional support on QGIS development, and they invest in core QGIS development, see http://qgis.org/en/commercial-support.html so if someone wants to play safe, they have an easy and efficient way. Many managers in government agencies don't want to be held responsible in case things go wrong - and in case of using open-source software they are fully responsible about their decisions, whereas with commercial software they can always blame their commercial vendor (even if the contracts are always in favor of the software vendor and includes very limited liability of the vendor). At least in Switzerland I know that many GIS managers are thinking this way. They often want to at least share their responsibility with an external company. So what I would tell them is: go ahead and contract one of the core developers, or one of the companies listed in http://qgis.org/en/commercial-support.html and http://grass.osgeo.org/community/commercial.php Several companies and agencies already do it. All the best. -- Paolo Cavallini: http://www.faunalia.it/pc ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
[OSGeo-Discuss] Fwd: [Gfoss] rilasciato spatialite-gis ALPHA
Hi All, Apologize Corossposting, some swit news from italy ;-) Inizio messaggio inoltrato: Da: Alessandro Furieri a.furi...@lqt.it Data: 06 luglio 2009 15:29:25 GMT+02:00 A: gf...@faunalia.it Oggetto: [Gfoss] rilasciato spatialite-gis ALPHA Sempre legato agli annunci precedenti: ora è anche disponibile un GIS elementare, leggero e veramente molto semplice basato su SpatiaLite e RasterLite saluti, Sandro --- Hi list, today I released 'spatialite-gis', a really simple and elementary GIS tool built directly on the top of SpatiaLite. http://www.gaia-gis.it/spatialite [or] http://www.gaia-gis.it/spatialite-2.3.1 -- 'spatialite-gis' is very alike to 'spatialite-gui'; both are intended to cooperate in a smooth way. - spatialite-gui allows you to access the DB in a classic SQL-based fashion - spatialite-gis supports a more 'visual' and interactive approach 'spatialite-gis' fully supports RasterLite's Raster Data Sources: you can get two useful sample-DB at: http://www.gaia-gis.it/spatialite-2.3.1/world.7z http://www.gaia-gis.it/spatialite-2.3.1/truemarble-4km.7z And a complete tutorial is available as well: http://www.gaia-gis.it/spatialite-2.3.1/spatialite-gis-basic.pdf http://www.gaia-gis.it/spatialite-2.3.1/spatialite-gis-advanced.pdf IMPORTANT NOTICE: this is an ALPHA state release, so it's quite unstable for sure; please, let me know any bug, oddity and so on ... Enjoy, Sandro ___ Iscriviti all'associazione GFOSS.it: http://www.gfoss.it/drupal/iscrizione gf...@faunalia.it http://lists.faunalia.it/cgi-bin/mailman/listinfo/gfoss Questa e' una lista di discussione pubblica aperta a tutti. I messaggi di questa lista non rispecchiano necessariamente le posizioni dell'Associazione GFOSS.it. ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] 5th gvSIG Conference: We keep growing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alvaro, I've added a link to the event on the OSGeo events catalogue: http://www.osgeo.org/events It will also appear on the front page of www.osgeo.org in a few more days. If you would like to change the text let me know and I will help you. Tyler Alvaro Anguix wrote: The 5th Edition of the gvSIG Conference [1], organized by the Regional Ministry of Infrastructure and Transport (CIT), will be held from December 2nd until December 4th at the Feria Valencia Convention and Exhibition Center, and will once again host the eclipseDay. In these difficult times when collaboration is most important, we cope with the adversities together with the aim of coming out strengthened by them. We continue moving ahead together. This is part of the gvSIG project and through this approach we keep on growing. This is our slogan for the fifth edition of the gvSIG Conference: We keep growing. The call for papers for the Fifth Edition of the gvSIG conference is now open. As of today communication proposals can be sent to the email address: contacto-jornadas-gv...@gva.es; they will be evaluated by the scientific committee as to their inclusion in the conference program. There are two types of communication: paper or poster. Information regarding to regulations on communication presentations can be found in the report?s section [2]. Abstracts will be accepted until September 21st . Organizations interested in collaborating in the event can find information in the section: How to collaborate? [3] [1] http://jornadas.gvsig.org/home/view?set_language=en [2] http://jornadas.gvsig.org/reports [3] http://jornadas.gvsig.org/how-to-collaborate Este mensaje y sus archivos son confidenciales. No está permitida su reproducción o distribución sin la autorización expresa de IVER Tecnologías de la Información. Si usted no es el destinatario previsto, queda desautorizado cualquier uso, acceso o copia de este mensaje. Si ha recibido este mensaje por error, por favor bórrelo e infórmenos por esta misma vía. ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpSPAQACgkQaqHtbnpFV33wUACeJvlJYItGjgaqd65NYO2qw6PA KqgAnRmymCJdfXisnEVn1IkunY+Ott23 =wcH4 -END PGP SIGNATURE- ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] 5th gvSIG Conference: We keep growing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tyler Mitchell (OSGeo) escribió: Alvaro, I've added a link to the event on the OSGeo events catalogue: http://www.osgeo.org/events It will also appear on the front page of www.osgeo.org in a few more days. If you would like to change the text let me know and I will help you. Tyler Hi, I've hacked a page on the osgeo wiki like past years, I'll update it as program and dates are published. http://wiki.osgeo.org/wiki/5th_gvSIG_Conference Cheers - -- Jorge Gaspar Sanz Salinas Ingeniero en Geodesia y Cartografía http://es.osgeo.org http://wiki.osgeo.org/wiki/Jorge_Sanz -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEcBAEBAgAGBQJKUlg8AAoJEAOYD75lvHdBPjMIAIVNPOYOg4vkgzacSACs+z/e eify/8ZIuJu/HrmUUmwYs+yM3CHwfG3GqHSlQH9tChkDzEO8KOUlQeKBtD6J4VfD Nmx8YI03F/8no1maSdWgrOSJ40qrxV06z575XOOQDLd9sJWJ6mJXnzV+c59vCU0W Eru7XFoEYiPIsL+hGnKuD7lqKCpclPJyuX0Ke54v8CPzk8Yi4R37Z8KHuntD5Rcc COTvUlGBUnRvUJrVhpENZbg1RJXRzYMobg1wkePRYA9fQFxNCdeSxYdpUTr9eVCe jpskkEkGeVaoD+vT3BDTQE1gfAp76cCTnLWJUGIRcXLz6Zf/h+aklcuvLZDRl+c= =7d+C -END PGP SIGNATURE- ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] database replication
Thank you, I'm gonna check it out On Mon, Jul 6, 2009 at 5:08 PM, Jo Cook j.c...@oxfordarch.co.uk wrote: Hi Carlos, I wrote that round-up, and there are a couple of things I would add. The first is that, of the packages I talk about in that blog post, I'd go with dbreplicator as it seems a little more active in terms of development and response to emails. However, these days I would actually choose sqlsync http://silvercoders.com/index.php?page=sqlsync This works very well as a cross-platform (cross-database too) command line tool, so once you're familiar with the syntax it can easily be incorporated into a script to run whenever you need it to. Hope that helps Jo Chris Puttick wrote: This might help: http://www.archaeogeek.com/blog/2008/11/21/database-replication/ Regards Chris - carlos sousa springal...@gmail.com wrote: Kind Sirs, Being a novice postgreSQL user, i'm currently transfering from our current esri/arcsde/arcims/mssqlserver solution to a postgres/postgis/mapserver/ openlayers solution. After this is down, the real server will be using software that is replicated in virtual machines used on external harddrives with a copy of the real server database. What I need to know is how should I execute a command, be it in the command line (prefferable because of scripting) or using some kind of gui tool like pgadminIII to let the virtual database get in sync with the real database when the external harddrive is connected to the real server. I've looked up sqlworkbench (no ubuntu binary) and slony (has to be compiled). I'm considering asking Ricardo from the GISVM project if he is available to help me think up a solution for this, you never know. Thanks in advance, Carlos ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss -- Files attached to this email may be in ISO 26300 format (OASIS Open Document Format). If you have difficulty opening them, please visit http://iso26300.info for more information. ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss -- View this message in context: http://n2.nabble.com/database-replication-tp3211446p3213862.html Sent from the OSGeo Discuss mailing list archive at Nabble.com. ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
