From:
Andrew Dunstan <andrew(at)dunslane(dot)net>
To:
Zoltán Böszörményi <zb(at)cybertec(dot)at>
Cc:
Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>, 'Craig Ringer' <craig(at)2ndQuadrant(dot)com>, 'Hans-Jürgen Schönig' <hs(at)cybertec(dot)at>, 'Ants Aasma' <ants(at)cybertec(dot)at>, 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 'PostgreSQL Hackers' <pgsql-hackers(at)postgresql(dot)org>, 'Amit kapila' <amit(dot)kapila(at)huawei(dot)com>
Subject:
Re: Strange Windows problem, lock_timeout test request
Date:
2013-01-31 15:38:04
Message-ID:
510A8FDC.2050700@dunslane.net (view raw or flat )
Thread:
2013-01-18 22:43:15 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-19 00:13:07 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-01-19 07:36:04 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-19 20:15:31 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-01-23 13:31:06 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-24 18:44:09 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2013-01-24 19:41:18 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-01-24 20:08:14 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-01-25 01:44:28 from Craig Ringer <craig(at)2ndQuadrant(dot)com>
2013-01-26 16:04:35 from james <james(at)mansionfamily(dot)plus(dot)com>
2013-01-26 23:38:11 from Craig Ringer <craig(at)2ndQuadrant(dot)com>
2013-01-25 00:55:17 from Craig Ringer <craig(at)2ndQuadrant(dot)com>
2013-01-19 07:51:00 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-19 23:15:39 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-01-23 13:28:25 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-19 05:52:41 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-19 07:36:48 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-28 14:20:33 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-30 14:29:04 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-30 14:45:42 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-30 15:06:36 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-30 16:45:54 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-31 13:55:14 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-31 14:22:46 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-31 14:55:46 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-31 15:38:04 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-01-31 15:39:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-31 17:27:22 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-31 18:38:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-31 21:12:01 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-02-12 18:32:48 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-12 18:35:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-02-12 18:41:42 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-12 18:45:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-02-12 18:51:45 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-12 18:55:37 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-02-12 18:56:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-02-12 18:58:12 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-02-12 19:00:13 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-23 01:55:23 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-23 18:15:06 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-24 02:23:29 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-24 08:27:01 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-24 14:03:44 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-24 15:14:41 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-25 08:23:34 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-25 14:05:24 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-27 18:07:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-02-27 18:28:46 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-27 18:38:44 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-27 19:06:34 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-27 19:38:29 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-28 08:22:18 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-15 17:53:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-16 15:59:27 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-16 16:42:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-16 17:17:00 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-16 17:48:35 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-03-16 18:04:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-16 18:26:34 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-03-17 00:35:40 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-03-17 03:53:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-17 03:48:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-17 08:00:50 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-17 15:07:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-17 19:06:13 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-18 02:52:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-18 05:22:42 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-18 05:29:37 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-18 05:47:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-18 10:40:48 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-18 14:09:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-21 18:24:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-03-22 00:16:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-22 14:29:15 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-03-22 16:49:29 from Greg Stark <stark(at)mit(dot)edu>
2013-02-24 03:07:13 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-02-24 03:15:08 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-24 08:44:54 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-02-24 14:08:34 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-24 17:39:38 from Claudio Freire <klaussfreire(at)gmail(dot)com>
2013-02-24 19:42:02 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-02-24 21:31:44 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-25 12:56:40 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-02-25 14:11:27 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-25 14:17:25 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-02-25 14:25:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-02-25 14:38:12 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-25 16:48:08 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-25 16:39:12 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-24 20:08:33 from Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
2013-02-24 12:30:15 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-27 03:06:44 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-27 09:40:16 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-27 13:58:15 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-03-04 03:28:36 from Craig Ringer <craig(at)2ndquadrant(dot)com>
2013-03-04 03:34:49 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-03-06 18:23:24 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-03-06 18:53:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-06 18:58:06 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
Lists:
pgsql-hackers
On 01/31/2013 09:55 AM, Zoltán Böszörményi wrote:
> 2013-01-31 15:22 keltezéssel, Alvaro Herrera írta:
>> Zoltán Böszörményi wrote:
>>
>>> I have found a little time to look into this problem and
>>> found a way to make pg_regress use prepared_xacts_1.out.
>>> I had to change line 2193 in pg_regress.c from
>>>
>>> fputs("max_prepared_transactions = 2\n", pg_conf);
>>>
>>> to
>>>
>>> fputs("max_prepared_transactions = 0\n", pg_conf);
>>>
>>> The patch now passed "make check" in both cases.
>> That sounds a lot more difficult than just using "make installcheck" and
>> configure the running server with zero prepared xacts ...
>
> It didn't occur to me to use "make installcheck" for this one.
>
> What is strange though is why prepared_xacts_1.out exists
> at all, since pg_regress.c / make check seems to set
> max_prepared_transactions on Windows, too.
>
> Is there a way to specify such settings in REGRESS_OPTS?
>
>
You can use the temp_config option to specify a file with non-standard
settings that will be appended to the installed postgresql.conf.
cheers
andrew
In response to
pgsql-hackers by date
Next :From: Tom LaneDate: 2013-01-31 15:39:38Subject : Re: Strange Windows problem, lock_timeout test requestPrevious :From : Zoltán BöszörményiDate : 2013-01-31 14:55:46Subject : Re: Strange Windows problem, lock_timeout test request
