[prev in list] [next in list] [prev in thread] [next in thread] 

List:       qgis-user
Subject:    Re: [Qgis-user] PostGIS change Server
From:       Charles Dixon-Paver <charles () kartoza ! com>
Date:       2021-09-25 20:09:43
Message-ID: CAK2Kqie+0XpavL7G_g13tjHWJAFHWTef7mk0Ex+mP+AixwLsHw () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Restoring a database dump is probably the best approach, especially if you
want to retain certain metadata, relations, and ownership information etc.

If it's just the data itself you want to migrate and you're not 100%
comfortable with database administration, an easy option is to connect to
both databases from the qgis browser and then just drag and drop the
tables/ layers from the old schema to the new one, then qgis will handle
loading the data for you.

On Sat, 25 Sep 2021, 19:16 chris hermansen, <clhermansen@gmail.com> wrote:

> L.W. and list
>
> On Sat, Sep 25, 2021, 09:59 L.W. <eaglelw@gmx.de> wrote:
>
>> Ok, I forgot the auto-find feature.
>>
>> Next I have to find out the best way to get the tables from old to new
>> server ...
>>
>
> pg_dump will turn your old database into a script that you can run on your
> new server with psql to recreate the database there.
>
>>
>> _______________________________________________
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>

[Attachment #5 (text/html)]

<div dir="auto">Restoring a database dump is probably the best approach, especially \
if you want to retain certain metadata, relations, and ownership information etc.<div \
dir="auto"><br></div><div dir="auto">If it&#39;s just the data itself you want to \
migrate and you&#39;re not 100% comfortable with database administration, an easy \
option is to connect to both databases from the qgis browser and then just drag and \
drop the tables/ layers from the old schema to the new one, then qgis will handle \
loading the data for you.</div></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Sat, 25 Sep 2021, 19:16 chris hermansen, &lt;<a \
href="mailto:clhermansen@gmail.com">clhermansen@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto"><div>L.W. and \
list<br><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Sep \
25, 2021, 09:59 L.W. &lt;<a href="mailto:eaglelw@gmx.de" target="_blank" \
rel="noreferrer">eaglelw@gmx.de</a>&gt; wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">  
    
  
  <div>
    <p>Ok, I forgot the auto-find feature.</p>
    <p>Next I have to find out the best way to get the tables from old
      to new server ...</p></div></blockquote></div></div><div \
dir="auto"><br></div><div dir="auto">pg_dump will turn your old database into a \
script that you can run on your new server with psql to recreate the database \
there.</div><div dir="auto"><div class="gmail_quote"><blockquote class="gmail_quote" \
style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div><p><br></p></div> </blockquote></div></div></div>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank" \
rel="noreferrer">Qgis-user@lists.osgeo.org</a><br> List info: <a \
href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer" \
                target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
                
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" \
rel="noreferrer noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br> \
</blockquote></div>



_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


[prev in list] [next in list] [prev in thread] [next in thread]