[postgis-users] database backup with postgis extension

[Paulo Frias]

It works.. ;)



On 13 November 2013 12:06, Paulo Frias <pfrias82 at 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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131113/5c289219/attachment.html>