Στις Monday 20 June 2011 18:46:33 ο/η Kevin Grittner έγραψε: > Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> wrote: > > > is there any quick and dirty (or otherwise easy way) to have a > > smooth procedure to load into a 8.3 server data dumped by an 9.0 > > server ? > > > > I tried with pg_dump -i from the 8.3 server without good results. > > Your best bet might be to dump using the 9.0 pg_dump and then see > where the errors are on the load attempt, and edit the file as > needed. > Thanx, unfortunately the dump is 310GB, and that rather forces me to go to the "migration" direction. Currently we run a central master system, (which i try to upgrade) and ~ 65 slaves in remote locations (very few of them have TCP/IP connectivity). I thought of migrating only the central system and leave the slaves at 8.3 but this possibility seems rather weak. > -Kevin > -- Achilleas Mantzios -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
