[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] database backup with postgis extension
From: Paulo Frias <pfrias82 () gmail ! com>
Date: 2013-11-13 12:34:21
Message-ID: CA+PD0U3J3jNigCO+2S-cVdf19umi0dmr56ffkwnHFRFn=0BXQQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Thanks..
On 13 November 2013 12:34, Paulo Frias <pfrias82@gmail.com> wrote:
> It works.. ;)
>
>
>
> On 13 November 2013 12:06, Paulo Frias <pfrias82@gmail.com> wrote:
>
>> The errors are:
>>
>> pg_restore: [archiver (db)] Error from TOC entry 3978; 1259 35665 INDEX
>> intertidal_line_apt_geom_gist postgres
>> pg_restore: [archiver (db)] could not execute query: ERROR: relation
>> "intertidal_line_apt_geom_gist" already exists
>>
>> and the same for the other data which have geometry.
>>
>> I just have created the new database with:
>>
>> $ createdb -T template0 newdb
>>
>> I didn't add the postgis extension in this new database.
>>
>> ------------------
>>
>> but now... I tried with the postgis extension and it gave me the
>> following error:
>>
>> pg_restore: [archiver (db)] Error while PROCESSING TOC:
>> pg_restore: [archiver (db)] Error from TOC entry 7; 2615 34094 SCHEMA
>> topology postgres
>> pg_restore: [archiver (db)] could not execute query: ERROR: schema
>> "topology" already exists
>> Command was: CREATE SCHEMA topology;
>>
>>
>> any idea?
>>
>>
>> On 13 November 2013 11:45, Devrim GÜNDÜZ <devrim@gunduz.org> wrote:
>>
>>>
>>> Hi,
>>>
>>> On Wed, 2013-11-13 at 11:39 +0000, Paulo Frias wrote:
>>> > I'm trying to backup my database (which have postgis extension) into a
>>> > new one with pg_dump.
>>> > When I do the pg_restore it gave me a lot of errors and the new
>>> > created database was empty.
>>>
>>> What are the errors? Did you install PostGIS extension to the new
>>> database prior to restore?
>>>
>>> Regards,
>>>
>>> --
>>> Devrim GÜNDÜZ
>>> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
>>> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
>>> Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
>>> http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users@lists.osgeo.org
>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>
>>
>>
>>
>> --
>> *Paulo Frias*
>> Marine Biologist
>> CCMAR - Centre of Marine Sciences
>> ISPA - Instituto Superior de Psicologia Aplicada
>>
>>
>>
>>
>
>
> --
> *Paulo Frias*
> Marine Biologist
> CCMAR - Centre of Marine Sciences
> ISPA - Instituto Superior de Psicologia Aplicada
>
>
>
>
--
*Paulo Frias*
Marine Biologist
CCMAR - Centre of Marine Sciences
ISPA - Instituto Superior de Psicologia Aplicada
[Attachment #5 (text/html)]
<div dir="ltr">Thanks.. </div><div class="gmail_extra"><br><br><div \
class="gmail_quote">On 13 November 2013 12:34, Paulo Frias <span dir="ltr"><<a \
href="mailto:pfrias82@gmail.com" target="_blank">pfrias82@gmail.com</a>></span> \
wrote:<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"><div dir="ltr"><div>It works.. ;)</div><div> \
</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br> \
<br><div class="gmail_quote">On 13 November 2013 12:06, Paulo Frias <span \
dir="ltr"><<a href="mailto:pfrias82@gmail.com" \
target="_blank">pfrias82@gmail.com</a>></span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"><div \
dir="ltr"><div>The errors are:</div><div> </div><div>
pg_restore: [archiver (db)] Error from TOC entry 3978; 1259 35665 INDEX \
intertidal_line_apt_geom_gist postgres</div> <div>pg_restore: [archiver (db)] could \
not execute query: ERROR: relation "intertidal_line_apt_geom_gist" already \
exists</div> <div> </div><div>and the same for the other data which have \
geometry.</div><div> </div><div>I just have created the new database \
with:</div><div> </div><div>$ createdb -T template0 newdb</div><div> </div><div>I \
didn't add the postgis extension in this new database.</div>
<div> </div><div>------------------</div><div> </div><div>but now... I tried with \
the postgis extension and it gave me the following error:</div><div> \
</div><div>pg_restore: [archiver (db)] Error while PROCESSING TOC:</div>
<div>pg_restore: [archiver (db)] Error from TOC entry 7; <a href="tel:2615%2034094" \
target="_blank" value="+351261534094">2615 34094</a> SCHEMA topology \
postgres</div><div>pg_restore: [archiver (db)] could not execute query: ERROR: schema \
"topology" already exists</div>
<div> Command was: CREATE SCHEMA topology;</div>
<div> </div><div> </div><div>any idea?</div></div><div \
class="gmail_extra"><br><br><div class="gmail_quote"><div><div>On 13 November 2013 \
11:45, Devrim GÜNDÜZ <span dir="ltr"><<a href="mailto:devrim@gunduz.org" \
target="_blank">devrim@gunduz.org</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"><div><div><br>
Hi,<br>
<div><br>
On Wed, 2013-11-13 at 11:39 +0000, Paulo Frias wrote:<br>
> I'm trying to backup my database (which have postgis extension) into a<br>
> new one with pg_dump.<br>
> When I do the pg_restore it gave me a lot of errors and the new<br>
> created database was empty.<br>
<br>
</div>What are the errors? Did you install PostGIS extension to the new<br>
database prior to restore?<br>
<br>
Regards,<br>
<span><font color="#888888"><br>
--<br>
Devrim GÜNDÜZ<br>
Principal Systems Engineer @ EnterpriseDB: <a href="http://www.enterprisedb.com" \
target="_blank">http://www.enterprisedb.com</a><br> PostgreSQL \
Danışmanı/Consultant, Red Hat Certified Engineer<br>
Community: devrim~PostgreSQL.org, devrim.gunduz~<a href="http://linux.org.tr" \
target="_blank">linux.org.tr</a><br> <a href="http://www.gunduz.org" \
target="_blank">http://www.gunduz.org</a> Twitter: <a \
href="http://twitter.com/devrimgunduz" \
target="_blank">http://twitter.com/devrimgunduz</a><br> \
</font></span><br></div></div>_______________________________________________<br> \
postgis-users mailing list<br> <a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> <a \
href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><span><font \
color="#888888"><br></font></span></blockquote> </div><span><font \
color="#888888"><br><br clear="all"><br>-- <br><div dir="ltr"> <div><font face="arial \
narrow,sans-serif"><b><span style="font-family:verdana,sans-serif">Paulo \
Frias</span></b><br style="font-family:verdana,sans-serif"><span \
style="font-family:verdana,sans-serif"><font size="1">Marine \
Biologist</font></span><br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif"><font size="1">CCMAR - Centre of Marine \
Sciences</font></span></font></div><div><font face="arial narrow,sans-serif"><span \
style="font-family:verdana,sans-serif"><font size="1">ISPA - Instituto Superior de \
Psicologia Aplicada</font></span><br style="font-family:verdana,sans-serif">
<br style="font-family:verdana,sans-serif"></font><br><br></div></div>
</font></span></div>
</blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr"><div><font \
face="arial narrow,sans-serif"><b><span style="font-family:verdana,sans-serif">Paulo \
Frias</span></b><br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif"><font size="1">Marine \
Biologist</font></span><br style="font-family:verdana,sans-serif"><span \
style="font-family:verdana,sans-serif"><font size="1">CCMAR - Centre of Marine \
Sciences</font></span></font></div>
<div><font face="arial narrow,sans-serif"><span \
style="font-family:verdana,sans-serif"><font size="1">ISPA - Instituto Superior de \
Psicologia Aplicada</font></span><br style="font-family:verdana,sans-serif"><br \
style="font-family:verdana,sans-serif">
</font><br><br></div></div>
</div>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><div \
dir="ltr"><div><font face="arial narrow,sans-serif"><b><span \
style="font-family:verdana,sans-serif">Paulo Frias</span></b><br \
style="font-family:verdana,sans-serif"> <span \
style="font-family:verdana,sans-serif"><font size="1">Marine \
Biologist</font></span><br style="font-family:verdana,sans-serif"><span \
style="font-family:verdana,sans-serif"><font size="1">CCMAR - Centre of Marine \
Sciences</font></span></font></div> <div><font face="arial narrow,sans-serif"><span \
style="font-family:verdana,sans-serif"><font size="1">ISPA - Instituto Superior de \
Psicologia Aplicada</font></span><br style="font-family:verdana,sans-serif"><br \
style="font-family:verdana,sans-serif"> </font><br><br></div></div>
</div>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic