It works.. ;)
On 13 November 2013 12:06, Paulo Frias <[email protected]> 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 <[email protected]> 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 >> [email protected] >> 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
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
