Re: [GENERAL] error migrating database from 8.4 to 8.3
> Export/import is the only option. Or upgrade PostgreSQL to 8.4 on the downgraded server. -- Scott Ribe scott_r...@killerbytes.com http://www.killerbytes.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] error migrating database from 8.4 to 8.3
On 9 February 2010 02:55, Marc Lustig wrote: > 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 > > 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. In addition to Filip's note: this "copy of datafiles" ONLY works with a) same architecture and b) same postgres major version that's 8.X.y, where 8.x comprises the "major". So 8.4 to 8.3 isn't going to fly. Export/import is the only option. Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] error migrating database from 8.4 to 8.3
2010/2/8 Marc Lustig > 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Filip Rembiałkowski JID,mailto:filip.rembialkow...@gmail.com http://filip.rembialkowski.net/
