From:
Simon Riggs <simon(at)2ndquadrant(dot)com>
To:
Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc:
Bruce Momjian <bruce(at)momjian(dot)us>, Dave Page <dpage(at)pgadmin(dot)org>,
List pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject:
Re: [HACKERS] odd output in restore mode
Date:
2008-07-01 08:39:08
Message-ID:
1214901548.3845.544.camel@ebony.site (view raw or flat )
Thread:
2008-05-12 20:57:01 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-05-12 22:14:00 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-05-12 22:58:37 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-05-12 23:37:53 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-05-13 01:15:55 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-05-13 01:38:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-05-13 03:03:25 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-05-13 05:44:35 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-05-13 07:42:26 from "Dave Page" <dpage(at)pgadmin(dot)org>
2008-05-13 08:32:55 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-05-13 12:00:29 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-05-13 12:26:35 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-05-13 15:08:52 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-05-13 16:05:58 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-05-13 16:11:30 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-05-13 16:15:12 from "Dave Page" <dpage(at)pgadmin(dot)org>
2008-05-18 12:38:12 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-05-18 21:16:17 from "Dave Page" <dpage(at)pgadmin(dot)org>
2008-06-30 22:13:12 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-06-30 23:29:03 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-07-01 08:39:08 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-07-01 10:44:22 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
2008-07-01 11:49:47 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-07-01 15:20:43 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-07-23 00:19:16 from Martin Zaun <Martin(dot)Zaun(at)Sun(dot)COM>
2008-07-23 07:09:28 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-07-23 10:59:43 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-07-23 18:38:56 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
2008-07-23 19:11:06 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-07-23 21:01:18 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-07-28 07:28:06 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
2008-07-28 13:09:40 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-07-28 13:46:14 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
2008-07-28 15:59:12 from Greg Smith <gsmith(at)gregsmith(dot)com>
2008-07-28 16:06:17 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-07-29 14:27:23 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
2008-07-30 16:51:34 from Martin Zaun <Martin(dot)Zaun(at)Sun(dot)COM>
2008-07-31 16:05:16 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
2008-07-31 16:32:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-08-02 10:07:49 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-08-02 14:27:21 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-11-11 22:24:41 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-11-11 23:09:09 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-12-15 22:18:32 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-07-23 23:05:56 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-07-25 19:46:18 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-07-25 20:31:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-07-25 20:53:02 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-07-25 20:58:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-07-25 21:25:01 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-12-15 21:15:51 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-12-15 22:08:14 from Magnus Hagander <magnus(at)hagander(dot)net>
2008-12-15 22:10:46 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-12-15 22:30:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2008-12-15 22:08:12 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-05-13 01:06:26 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2008-05-13 02:40:38 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-05-13 05:37:24 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-06-30 22:11:02 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-hackers pgsql-patches
On Mon, 2008-06-30 at 19:29 -0400, Andrew Dunstan wrote:
>
> Bruce Momjian wrote:
> > Dave Page wrote:
> >
> >> On Sun, May 18, 2008 at 1:38 PM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
> >>
> >>> I don't know how you tested,
> >>>
> >> Copy a large file across a relatively slow network, and check the size
> >> on the destination drive before it finishes.
> >>
> >>
> >>> but could you please repeat the test with
> >>> GnuWin32's cp.exe? If it doesn't preallocate the space then I think our way
> >>> forward is reasonably clear:
> >>>
> >> It does not pre-allocate.
> >>
> >>
> >>> . we recommend its use for Windows archive_command settings
> >>> . we provide the delay kluge as switchable behaviour on Windows instead of
> >>> having it always on.
> >>>
> >> Sounds reasonable to me.
> >>
> >
> > Are there any changes we need to make here?
> >
> >
>
> Yes. Simon has promised a patch to do the above.
Patch implements
* recommendation to use GnuWin32 cp on Windows
* provide "holdtime" delay, default 0 (on all platforms)
* default stays same on Windows="copy" to ensure people upgrading don't
get stung
Patch should be backpatched to 8.3, plus to CVS HEAD.
We should recommend in next 8.3 release notes that people use "-p" or
"-l" rather than just letting it default.
Will add permalink to Wiki when patch appears in archives.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
In response to
Responses
pgsql-hackers by date
Next :From: Gregory StarkDate: 2008-07-01 09:11:09Subject : Re: Planned obsolescence in identify_system_timezone()Previous :From : Richard HuxtonDate : 2008-07-01 07:45:44Subject : Re: Does anything dump per-database config settings? (was Re:
ALTER DATABASE vs pg_dump)
pgsql-patches by date
Next :From: Heikki LinnakangasDate: 2008-07-01 10:33:24Subject : Re: extend VacAttrStats to allow stavalues of different typesPrevious :From : Simon RiggsDate : 2008-07-01 07:41:34Subject : Re: VACUUM Improvements - WIP Patch
