[OSGeo Africa] Web Maps

[Tim Sutton]

Hi


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
exit

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
exit

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.

Regards

Tim


>
>
> 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>