Re: error migrating database from 8.4 to 8.3

2010/2/8 Marc Lustig <ml(at)marclustig(dot)com>

> Due to a server issue we needed a reinstallation of Ubuntu along with a
> downgrade to Ubuntu Hardy.
>
>
> So this is what we did:
>
> - copied all from /var/lib/postgresql/8.4/main/ to the new server
> /var/lib/postgresql/8.3/main/
> - edited /var/lib/postgresql/8.3/main/postmaster.opts to correct the path
>

No, that will not work. On-disk formats are not binary compatible.
You have to make backups from 8.4 and restore them on empty 8.3.

See "Notes" in http://www.postgresql.org/docs/8.4/static/app-pgdump.html

> Now trying to start the server results in
>
> * Error: The server must be started under the locale : which does not exist
> any more.
>
> I googled and found that people ran into this problem due to different
> architectures (32 vs 64 bit).
> In this case, the architecture is definiately the same.
>
> The only difference is that the database comes from a 8.4 installation and
> the server is 8.3
>
> Please help solving this locale issue.
>
> thanks!
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/