Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_upgrade / postgis issue - Mailing list pgsql-admin

From Sergey Konoplev
Subject Re: pg_upgrade / postgis issue
Date
Msg-id CAL_0b1ve8rmo+m0P7gqA+pJC4Wkz1LA1LdPs62ODqo=PddM--A@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade / postgis issue  (Marcos Cano <mcano@stsa.info>)
Responses Re: pg_upgrade / postgis issue  (Marcos Cano <mcano@stsa.info>)
List pgsql-admin
Tree view 
On Mon, Jul 1, 2013 at 9:20 AM, Marcos Cano <mcano@stsa.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.ru@gmail.com

pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: pg_dump, pg_restore from 9.2 on 8.4 server
Next
From: Marcos Cano
Date:
Subject: Re: pg_upgrade / postgis issue