Darrel
> On one of my databases I do get a new (presumably trivial) error:
> pg_restore: processing data for table "spatial_ref_sys"
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 3303; 0 35941 TABLE
DATA > spatial_ref_sys postgres
> pg_
Discussion
Subject: RE: [postgis-users] restore problem
Dear Regina,
Many thanks again for this detailed explanation – this really does help me
understand what is happening. I did not have the clean flag set BUT when I
tried this again this morning it has worked ☺. I have tried this on two
geo.org] On Behalf Of
Richard Greenwood
Sent: Wednesday, November 11, 2015 5:41 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] restore problem
Darrel,
A couple people have already pointed out that creating the postgis extension in
the target database before you restore is advisable. Goin
users-boun...@lists.osgeo.org] On Behalf Of
Darrel Maddy
Sent: Wednesday, November 11, 2015 2:03 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] restore problem
Dear Regina and Rich,
I tried to follow your instructions by doing the following:
1. I redid the backup of m
functions? (I think there are 16 of them)
Hopefully I am making progress.
Darrel
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Richard Greenwood
Sent: 11 November 2015 22:41
To: PostGIS Users Discussion
Subject: Re: [postgis-users] restore problem
Darrel,
* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *On
> Behalf Of *Paragon Corporation
> *Sent:* 11 November 2015 21:43
>
> *To:* 'PostGIS Users Discussion'
> *Subject:* Re: [postgis-users] restore problem
>
>
>
> Darrel,
>
>
>
> Sadly you
ssion'
Subject: Re: [postgis-users] restore problem
Darrel,
Sadly you are not the only one.
I have the issue documented here:
https://trac.osgeo.org/postgis/ticket/2485
and I haven't come up with a generic enough fix I feel comfortable including
in PostGIS code.
The work-around is
Wednesday, November 11, 2015 2:03 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] restore problem
OK can I come at this from a different direction? Are there any backup options
I should be selecting to eliminate this problem?
I am really struggling to understand why I cannot backup a
ers [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Darrel Maddy
Sent: 10 November, 2015 10:25 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] restore problem
The default appears to be custom. I did not change anything when I did this. I
just accepted the defaults.
Darrel
F
rg>>
Subject: Re: [postgis-users] restore problem
Given that the core problem has to do with the restore process' search_path, no
amount of advice will help you get around the restrictions in place with the
restore process without jumping into that process.
In pgAdmin, you can check t
the raster table (dems) is empty.
>
>
>
> Darrel
>
>
>
> *From:* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *On
> Behalf Of *Bborie Park
> *Sent:* 10 November 2015 21:57
>
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] rest
the same error and
the raster table (dems) is empty.
Darrel
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Bborie Park
Sent: 10 November 2015 21:57
To: PostGIS Users Discussion
Subject: Re: [postgis-users] restore problem
Given that the core problem has to do
w to follow your instructions L
>
>
>
> Anyone care to give me an idiots guide?
>
>
>
> Sorry
>
>
>
> Darrel
>
>
>
>
>
> *From:* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *On
> Behalf Of *Bborie Park
> *Sent:* 10 Novem
Discussion
Subject: Re: [postgis-users] restore problem
Hi
On 10 Nov 2015, at 23:33, Darrel Maddy
mailto:darrel.ma...@newcastle.ac.uk>> wrote:
Hi Tim,
I am on windows and using the latest version 2.2 of postgis (and postgresql
9.4). My original databases do not have pg_raster as an extension
-users-boun...@lists.osgeo.org>] On Behalf Of Tim Sutton
> Sent: 10 November 2015 21:30
> To: PostGIS Users Discussion <mailto:postgis-users@lists.osgeo.org>>
> Subject: Re: [postgis-users] restore problem
>
> Hi
>
> On 10 Nov 2015, at 23:26, Darrel Maddy <mailto
Sent: 10 November 2015 21:30
To: PostGIS Users Discussion
Subject: Re: [postgis-users] restore problem
Hi
On 10 Nov 2015, at 23:26, Darrel Maddy
mailto:darrel.ma...@newcastle.ac.uk>> wrote:
Dear Tim,
Thanks for this suggestion. I had assumed that the extensions were part of the
backup a
f Of Tim Sutton
> Sent: 10 November 2015 21:15
> To: PostGIS Users Discussion <mailto:postgis-users@lists.osgeo.org>>
> Subject: Re: [postgis-users] restore problem
>
> Hi
> On 10 Nov 2015, at 23:11, Darrel Maddy <mailto:darrel.ma...@newcastle.ac.uk>> wrote:
?
Sorry
Darrel
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Bborie Park
Sent: 10 November 2015 21:22
To: PostGIS Users Discussion
Subject: Re: [postgis-users] restore problem
This problem arises because PostgreSQL sets the search path during the restore
same error.
Darrel
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Tim Sutton
Sent: 10 November 2015 21:15
To: PostGIS Users Discussion
Subject: Re: [postgis-users] restore problem
Hi
On 10 Nov 2015, at 23:11, Darrel Maddy
mailto:darrel.ma...@newcastle.ac.uk
This problem arises because PostgreSQL sets the search path during the
restore process. Unfortunately, the search path is quite restrictive.
You should be able to do your restore in three sections using pg_restore's
--section flag.
The error looks like it has to be the post-data section, which yo
Hi
> On 10 Nov 2015, at 23:11, Darrel Maddy wrote:
>
> Dear all,
>
> Like many here I suspect I want to keep a copy of my main databases held on
> my workstation, on my laptop. I used PgAdmin to backup the databases
> concerned (the backup files look about the size I was expecting) but restor
Dear all,
Like many here I suspect I want to keep a copy of my main databases held on my
workstation, on my laptop. I used PgAdmin to backup the databases concerned
(the backup files look about the size I was expecting) but restore on my
laptop did not successfully complete. All my shp file t
22 matches
Mail list logo