[OSGeo Africa] Web Maps

Tim Sutton tim at linfiniti.com
Wed Dec 4 00:36:58 PST 2013


On Mon, Dec 2, 2013 at 8:26 AM, Toini Paulus <tnpaulus at gmail.com> wrote:

> Good Morning Sir/Madam
> I have created web maps using OpenGeo Suite and now I have difficulties to
> migrate data from my local computer to the company's server.
> Any to help please?
> Where are the PostGIS data located in Mt computer?
> Which file should I copy?

You need to dump and restore your postgis database. Assuming you have
linux, open a terminal window and do:

sudo su - postgres
psql -l

Make sure your database is listed. Lets assume it is called foo:

pg_dump -Fc -f /tmp/foo.dmp foo

Now copy the foo.dmp file to your server's /tmp/ directory. I assume that
it already has PostgreSQL and PostGIS installed. Then do this in a terminal
on your server:

sudo su - postgres
createdb -T template_postgis foo
pg_restore /tmp/foo.dmp | psql foo

You may need to do more things (e.g. creating your template_postgis if you
dont have it already) but the above is the general workflow.



> Thank you Very Much
> Regards
> Toini
> _______________________________________________
> Africa mailing list
> Africa at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/africa

Tim Sutton - QGIS Project Steering Committee Member
Visit http://linfiniti.com to find out about:
 * QGIS programming services
 * GeoDjango web development
 * FOSS Consulting Services
Skype: timlinux Irc: timlinux on #qgis at freenode.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/africa/attachments/20131204/ccaec8c1/attachment.html>

More information about the Africa mailing list