pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedsuggestion for admin "If you are upgrading"
6+ messages / 3 participants
[nested] [flat]
* suggestion for admin "If you are upgrading"
@ 2001-03-16 21:04 Philip Crotwell <crotwell@seis.sc.edu>
0 siblings, 2 replies; 6+ messages in thread
From: Philip Crotwell @ 2001-03-16 21:04 UTC (permalink / raw)
To: pgsql-docs; +Cc: Philip Crotwell <crotwell@seis.sc.edu>
Hi
It might be nice to add a line saying that pgdumpall doesn't do large
objects to section 1.4 of admin, so that when people upgrade from 7.0 to
7.1 they don't accidentally lose their large objects. Perhaps something
like:
pgdumpall doesn't dump large objects by default. If your database uses
large objects, please see section 8.1.4 Caveats.
thanks,
Philip
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: suggestion for admin "If you are upgrading"
@ 2001-03-19 14:44 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Philip Crotwell <crotwell@seis.sc.edu>
1 sibling, 1 reply; 6+ messages in thread
From: Bruce Momjian @ 2001-03-19 14:44 UTC (permalink / raw)
To: Philip Crotwell <crotwell@seis.sc.edu>; +Cc: pgsql-docs
I think 7.1 does do them.
>
> Hi
>
> It might be nice to add a line saying that pgdumpall doesn't do large
> objects to section 1.4 of admin, so that when people upgrade from 7.0 to
> 7.1 they don't accidentally lose their large objects. Perhaps something
> like:
>
> pgdumpall doesn't dump large objects by default. If your database uses
> large objects, please see section 8.1.4 Caveats.
>
> thanks,
> Philip
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: suggestion for admin "If you are upgrading"
@ 2001-03-19 15:14 Philip Crotwell <crotwell@seis.sc.edu>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 2 replies; 6+ messages in thread
From: Philip Crotwell @ 2001-03-19 15:14 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-docs
Right, but pg_dump from 7.0 doesn't. And to upgrade from 7.0 to 7.1, you
have to use the pg_dumpall from 7.0, not the one from 7.1. So if you
follow the upgrade instructions in the 7.1 admin manual, the large objects
will not be transfered.
So maybe it should say:
The implementations of pg_dump and pg_dumpall from versions prior to 7.1
do not dump large objects by default. If you are upgrading from a version
prior to 7.1 and your database uses large objects, please see the
documentation for pg_dump and pg_dumpall for that version.
thanks,
Philip
On Mon, 19 Mar 2001, Bruce Momjian wrote:
> I think 7.1 does do them.
>
> >
> > Hi
> >
> > It might be nice to add a line saying that pgdumpall doesn't do large
> > objects to section 1.4 of admin, so that when people upgrade from 7.0 to
> > 7.1 they don't accidentally lose their large objects. Perhaps something
> > like:
> >
> > pgdumpall doesn't dump large objects by default. If your database uses
> > large objects, please see section 8.1.4 Caveats.
> >
> > thanks,
> > Philip
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://www.postgresql.org/search.mpl
> >
>
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: suggestion for admin "If you are upgrading"
@ 2001-03-19 15:20 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Philip Crotwell <crotwell@seis.sc.edu>
1 sibling, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2001-03-19 15:20 UTC (permalink / raw)
To: Philip Crotwell <crotwell@seis.sc.edu>; +Cc: pgsql-docs
Good point.
>
> Right, but pg_dump from 7.0 doesn't. And to upgrade from 7.0 to 7.1, you
> have to use the pg_dumpall from 7.0, not the one from 7.1. So if you
> follow the upgrade instructions in the 7.1 admin manual, the large objects
> will not be transfered.
>
> So maybe it should say:
>
> The implementations of pg_dump and pg_dumpall from versions prior to 7.1
> do not dump large objects by default. If you are upgrading from a version
> prior to 7.1 and your database uses large objects, please see the
> documentation for pg_dump and pg_dumpall for that version.
>
> thanks,
> Philip
>
> On Mon, 19 Mar 2001, Bruce Momjian wrote:
>
> > I think 7.1 does do them.
> >
> > >
> > > Hi
> > >
> > > It might be nice to add a line saying that pgdumpall doesn't do large
> > > objects to section 1.4 of admin, so that when people upgrade from 7.0 to
> > > 7.1 they don't accidentally lose their large objects. Perhaps something
> > > like:
> > >
> > > pgdumpall doesn't dump large objects by default. If your database uses
> > > large objects, please see section 8.1.4 Caveats.
> > >
> > > thanks,
> > > Philip
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 6: Have you searched our list archives?
> > >
> > > http://www.postgresql.org/search.mpl
> > >
> >
> >
> > --
> > Bruce Momjian | http://candle.pha.pa.us
> > pgman@candle.pha.pa.us | (610) 853-3000
> > + If your life is a hard drive, | 830 Blythe Avenue
> > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
> >
>
>
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: suggestion for admin "If you are upgrading"
@ 2001-03-19 16:29 Peter Eisentraut <peter_e@gmx.net>
parent: Philip Crotwell <crotwell@seis.sc.edu>
1 sibling, 0 replies; 6+ messages in thread
From: Peter Eisentraut @ 2001-03-19 16:29 UTC (permalink / raw)
To: Philip Crotwell <crotwell@seis.sc.edu>; +Cc: pgsql-docs
Philip Crotwell writes:
> It might be nice to add a line saying that pgdumpall doesn't do large
> objects to section 1.4 of admin, so that when people upgrade from 7.0 to
> 7.1 they don't accidentally lose their large objects. Perhaps something
> like:
>
> pgdumpall doesn't dump large objects by default. If your database uses
> large objects, please see section 8.1.4 Caveats.
Done.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: suggestion for admin "If you are upgrading"
@ 2001-03-19 17:34 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Philip Crotwell <crotwell@seis.sc.edu>
1 sibling, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2001-03-19 17:34 UTC (permalink / raw)
To: Philip Crotwell <crotwell@seis.sc.edu>; +Cc: pgsql-docs
This change has been made. Thanks.
>
> Right, but pg_dump from 7.0 doesn't. And to upgrade from 7.0 to 7.1, you
> have to use the pg_dumpall from 7.0, not the one from 7.1. So if you
> follow the upgrade instructions in the 7.1 admin manual, the large objects
> will not be transfered.
>
> So maybe it should say:
>
> The implementations of pg_dump and pg_dumpall from versions prior to 7.1
> do not dump large objects by default. If you are upgrading from a version
> prior to 7.1 and your database uses large objects, please see the
> documentation for pg_dump and pg_dumpall for that version.
>
> thanks,
> Philip
>
> On Mon, 19 Mar 2001, Bruce Momjian wrote:
>
> > I think 7.1 does do them.
> >
> > >
> > > Hi
> > >
> > > It might be nice to add a line saying that pgdumpall doesn't do large
> > > objects to section 1.4 of admin, so that when people upgrade from 7.0 to
> > > 7.1 they don't accidentally lose their large objects. Perhaps something
> > > like:
> > >
> > > pgdumpall doesn't dump large objects by default. If your database uses
> > > large objects, please see section 8.1.4 Caveats.
> > >
> > > thanks,
> > > Philip
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 6: Have you searched our list archives?
> > >
> > > http://www.postgresql.org/search.mpl
> > >
> >
> >
> > --
> > Bruce Momjian | http://candle.pha.pa.us
> > pgman@candle.pha.pa.us | (610) 853-3000
> > + If your life is a hard drive, | 830 Blythe Avenue
> > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
> >
>
>
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2001-03-19 17:34 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-16 21:04 suggestion for admin "If you are upgrading" Philip Crotwell <crotwell@seis.sc.edu>
2001-03-19 14:44 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-03-19 15:14 ` Philip Crotwell <crotwell@seis.sc.edu>
2001-03-19 15:20 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-03-19 17:34 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-03-19 16:29 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox