  Date: Sunday, October 15, 2000 @ 23:34:47
Author: pjw

Update of /home/projects/pgsql/cvsroot/pgsql/doc/src/sgml/ref
     from hub.org:/home/users/p/pjw/work/pgsql/doc/src/sgml/ref

Modified Files:
	allfiles.sgml 

-----------------------------  Log Message  -----------------------------

Added pg_restore to allfiles.sgml


Sun, 15 Oct 2000 23:34:47 -0400 (EDT)
Philip Warner - CVS <pjw@postgresql.org>
pgsql/doc/src/sgml/ref (allfiles.sgml)
Philip Warner <pjw@rhyme.com.au> writes:
> As a result do people have any objection to changing pg_restore to
> pg_undump? Or pg_load?

Out of those two names, I'd vote for pg_load ...

			regards, tom lane

Mon, 16 Oct 2000 00:27:39 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Backup, restore & pg_dump 

Since we may have a workable backup/restore based on WAL available in 7.1,
I am now wondering at the wisdom of creating 'pg_restore', which reads the
new pg_dump archive files. It is probably better to have pg_backup &
pg_restore as the backup/restore utilities.

As a result do people have any objection to changing pg_restore to
pg_undump? Or pg_load?

Any other suggestions would also be welcome.


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/

Mon, 16 Oct 2000 14:44:15 +1000
Philip Warner <pjw@rhyme.com.au>
Backup, restore & pg_dump
What was the matter with the name pg_restore?

> 
> Since we may have a workable backup/restore based on WAL available in 7.1,
> I am now wondering at the wisdom of creating 'pg_restore', which reads the
> new pg_dump archive files. It is probably better to have pg_backup &
> pg_restore as the backup/restore utilities.
> 
> As a result do people have any objection to changing pg_restore to
> pg_undump? Or pg_load?
> 
> Any other suggestions would also be welcome.
> 
> 
> ----------------------------------------------------------------
> Philip Warner                    |     __---_____
> Albatross Consulting Pty. Ltd.   |----/       -  \
> (A.B.N. 75 008 659 498)          |          /(@)   ______---_
> Tel: (+61) 0500 83 82 81         |                 _________  \
> Fax: (+61) 0500 83 82 82         |                 ___________ |
> Http://www.rhyme.com.au          |                /           \|
>                                  |    --________--
> PGP key available upon request,  |  /
> and from pgp5.ai.mit.edu:11371   |/
> 


-- 
  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

Mon, 16 Oct 2000 00:45:50 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Backup, restore & pg_dump
On Mon, 16 Oct 2000, Bruce Momjian wrote:

> What was the matter with the name pg_restore?

I didn't wanna be the one to ask, but I was kinda confused on that point
too ...

> > Since we may have a workable backup/restore based on WAL available in 7.1,
> > I am now wondering at the wisdom of creating 'pg_restore', which reads the
> > new pg_dump archive files. It is probably better to have pg_backup &
> > pg_restore as the backup/restore utilities.
> > 
> > As a result do people have any objection to changing pg_restore to
> > pg_undump? Or pg_load?
> > 
> > Any other suggestions would also be welcome.
> > 
> > 
> > ----------------------------------------------------------------
> > Philip Warner                    |     __---_____
> > Albatross Consulting Pty. Ltd.   |----/       -  \
> > (A.B.N. 75 008 659 498)          |          /(@)   ______---_
> > Tel: (+61) 0500 83 82 81         |                 _________  \
> > Fax: (+61) 0500 83 82 82         |                 ___________ |
> > Http://www.rhyme.com.au          |                /           \|
> >                                  |    --________--
> > PGP key available upon request,  |  /
> > and from pgp5.ai.mit.edu:11371   |/
> > 
> 
> 
> -- 
>   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
> 
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Mon, 16 Oct 2000 01:56:46 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: Backup, restore & pg_dump
Don't go changing yet.  When Vadim has something, we can decide.  I
think we may have unique commands for logging control and stuff, so
let's see how it plays out.

> At 00:45 16/10/00 -0400, Bruce Momjian wrote:
> >What was the matter with the name pg_restore?
> 
> The fact that we will have a 'proper' backup/restore with the WAL changes,
> and it seems more appropriate that the new utilities should be called
> pg_backup & pg_restore. This leaves the 'undump' part of pg_dump without a
> name. So I will most likely call it pg_load since dump & load are commonly
> associated as verbs.
> 
> 
> ----------------------------------------------------------------
> Philip Warner                    |     __---_____
> Albatross Consulting Pty. Ltd.   |----/       -  \
> (A.B.N. 75 008 659 498)          |          /(@)   ______---_
> Tel: (+61) 0500 83 82 81         |                 _________  \
> Fax: (+61) 0500 83 82 82         |                 ___________ |
> Http://www.rhyme.com.au          |                /           \|
>                                  |    --________--
> PGP key available upon request,  |  /
> and from pgp5.ai.mit.edu:11371   |/
> 


-- 
  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

Mon, 16 Oct 2000 01:01:03 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Backup, restore & pg_dump
At 00:45 16/10/00 -0400, Bruce Momjian wrote:
>What was the matter with the name pg_restore?

The fact that we will have a 'proper' backup/restore with the WAL changes,
and it seems more appropriate that the new utilities should be called
pg_backup & pg_restore. This leaves the 'undump' part of pg_dump without a
name. So I will most likely call it pg_load since dump & load are commonly
associated as verbs.


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/

Mon, 16 Oct 2000 15:53:29 +1000
Philip Warner <pjw@rhyme.com.au>
Re: Backup, restore & pg_dump