Thread: 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 |/
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
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, Pennsylvania19026
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
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, Pennsylvania19026
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 |/