2010/2/8 Marc Lustig <m...@marclustig.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@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/
