| From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
|---|---|
| To: | Marcos Cano <mcano(at)stsa(dot)info> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: pg_upgrade / postgis issue |
| Date: | 2013-07-04 01:12:43 |
| Message-ID: | CAL_0b1ve8rmo+m0P7gqA+pJC4Wkz1LA1LdPs62ODqo=PddM--A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Jul 1, 2013 at 9:20 AM, Marcos Cano <mcano(at)stsa(dot)info> wrote:
> content of the file tables_using_names.txt:
> Database: dev
> public.geography_columns.f_table_schema
> public.geography_columns.f_table_name
> public.geography_columns.f_geography_column
Hm... have you performed soft upgrade to PostGIS 1.5.8?
If so then try to pg_dump the geography_columns table, then drop it,
do pg_upgrade, and restore the dump of geography_columns. It is just
my guess but it could help.
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray(dot)ru(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcos Cano | 2013-07-04 14:12:41 | Re: pg_upgrade / postgis issue |
| Previous Message | Guillaume Lelarge | 2013-07-03 20:50:56 | Re: pg_dump, pg_restore from 9.2 on 8.4 server |