[Qgis-user] Import (not so) large data into a remote postgis database

[Olivier Dalang]

Thanks for the answer.

Try using the two "Import into PostGIS" algorithms included with
> processing. The "Import Vector into PostGIS database" OGR algorithm
> should be quite fast.


Here I have only one in the list.
I tried it, but again : no visual feedback (just a non-responding window).
Also, when looking at the row count using pgadmin, I don't see rows being
inserted, while I was seeing rows being inserted (very slowly) when
importing through the DB Manager...


I tried monitoring the network traffic, and it's very slow (around 0.4
kb/s)... It doesn't seem the network is the limiting factor, since I get
around 30-40 kb/s upload to the server through sftp.

I'm a bit lost about where to look to optimize this :(
Am I the only one running into this problem ? Maybe it's specific to some
of my postgis settings (but I changed almost nothing from the default
setup).

Any help would be very welcome !

Olivier






2015-01-15 21:26 GMT+00:00 Nyall Dawson <nyall.dawson at gmail.com>:

> On 16 January 2015 at 07:32, Olivier Dalang <olivier.dalang at gmail.com>
> wrote:
> > Dear list,
> >
> >
> > From within QGIS, it seems there are 3 ways to do this :
> > A. from the DB manager, using the "import data" button
> > B. from the browser, by dragging&dropping from one source to another
> > C. from the SPIT plugin
> > But each of them has it's caveats.
>
> Try using the two "Import into PostGIS" algorithms included with
> processing. The "Import Vector into PostGIS database" OGR algorithm
> should be quite fast.
>
> Nyall
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150115/743ef78d/attachment.html>