Обсуждение: pg_dump 7.3rc1 with 7.2 server.
hi, lately i realized that my new rc1 installation pg_dump had been backing up my old 7.2.1 production server. is it producing a safe backup of my server restorable thru pg_restore 7.3rc1? regds mallah. ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/
I've not tested it, so I can say 100% for sure, but if I had to guess I'd say that those dumps wont work if you try to restore to 7.2.1 so you need to switch back to the proper version asap. (Things like opaque functions getting rewritten to new types come to mind) Robert Treat On Tue, 2002-11-26 at 12:25, mallah@trade-india.com wrote: > > > hi, > > lately i realized that my new rc1 installation pg_dump had been > backing up my old 7.2.1 production server. > > is it producing a safe backup of my server > restorable thru pg_restore 7.3rc1? > > regds > mallah. > > > ----------------------------------------- > Get your free web based email at trade-india.com. > "India's Leading B2B eMarketplace.!" > http://www.trade-india.com/ > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly
Robert Treat <xzilla@users.sourceforge.net> writes:
> I've not tested it, so I can say 100% for sure, but if I had to guess
> I'd say that those dumps wont work if you try to restore to 7.2.1 so you
> need to switch back to the proper version asap.
Robert's right: the output of 7.3 pg_dump will not load into older
servers. In general, pg_dump can read from older servers (back to
7.0) but its output will only load into same- or newer-version servers.
Of course, if you *did* have a crash you could install 7.3rc2 and reload
into that ...
regards, tom lane
Thanks very much for the responses. since 7.3 release is due soon i think i need no bother. regds mallah. On Wednesday 27 November 2002 08:54 am, you wrote: > Robert Treat <xzilla@users.sourceforge.net> writes: > > I've not tested it, so I can say 100% for sure, but if I had to guess > > I'd say that those dumps wont work if you try to restore to 7.2.1 so you > > need to switch back to the proper version asap. > > Robert's right: the output of 7.3 pg_dump will not load into older > servers. In general, pg_dump can read from older servers (back to > 7.0) but its output will only load into same- or newer-version servers. > > Of course, if you *did* have a crash you could install 7.3rc2 and reload > into that ... > > regards, tom lane -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.