On 08/05/2013 06:24 AM, Carlos Henrique Reimer wrote:
> Hi,
>
> Yes, I agree with you that it must be upgraded to a supported version
> but as the developer has not homologated the system to some new PG
> versions yet I need to find out some way to fix it with 8.2.
>
> Will try to install PG in another windows box, copying the data
> directories over the network and see if I can at least take a pg_dump
> from the database as it is currently not possible.
>
> Another possibility is to copy the data directory from the windows box
> to a linux with PG 8.2 and start the database there, does this approach
> has any possibility of success?
No. The files are not binary compatible across OS and architectures.
You mentioned that creating indexes on this table fails.
Have you tried reindexing or dropping the index to see if that helps?
>
>
> Thank you!
>
>
>
> Reimer
> 47-3347-1724 47-9183-0547 msn: carlos.reimer@opendb.com.br
> <mailto:carlos.reimer@opendb.com.br>
--
Adrian Klaver
adrian.klaver@gmail.com