Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_dump 7.3rc1 with 7.2 server.

pg_dump 7.3rc1 with 7.2 server.

From
Date:

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/

Re: pg_dump 7.3rc1 with 7.2 server.

From
Robert Treat
Date:
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

Re: pg_dump 7.3rc1 with 7.2 server.

From
Tom Lane
Date:
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

Re: pg_dump 7.3rc1 with 7.2 server.

From
"Rajesh Kumar Mallah."
Date:
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.