From:
Stephen Frost <sfrost(at)snowman(dot)net>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Andrew Dunstan <andrew(at)dunslane(dot)net>, Bruce Momjian <bruce(at)momjian(dot)us>,Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: pg_upgrade problem with invalid indexes
Date:
2012-12-07 03:27:48
Message-ID:
20121207032748.GH12354@tamriel.snowman.net (view raw or flat )
Thread:
2012-12-07 00:28:33 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 00:31:46 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-12-07 00:58:03 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-12-07 01:05:56 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-12-07 01:37:28 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-12-07 00:35:19 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-12-07 00:38:36 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 00:53:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-07 01:16:36 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 02:10:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-07 02:23:14 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 02:41:00 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-12-07 02:45:11 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-07 03:06:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-07 03:08:11 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 03:35:40 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-07 03:27:48 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-07 03:07:02 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 03:27:21 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-07 14:21:58 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 14:24:46 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-07 14:27:39 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 14:32:51 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-07 14:44:18 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 15:29:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-07 16:08:28 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 16:46:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-07 16:57:34 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 19:24:49 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 03:06:17 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 04:02:26 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-12-07 09:16:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-12-07 14:23:09 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 13:58:04 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 14:12:36 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-12-07 18:22:12 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-12-07 18:27:08 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-07 18:44:53 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-12-07 18:49:14 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-07 18:54:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-07 19:07:18 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-07 18:57:35 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 18:59:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-07 19:10:04 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-07 21:21:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-07 21:30:36 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-07 21:37:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-07 21:38:39 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-07 21:49:19 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-11 20:12:37 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-11 20:19:34 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-11 20:24:28 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-14 18:41:21 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-hackers
* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> Stephen Frost <sfrost(at)snowman(dot)net> writes:
> > Or preserve it as-is.
>
> To do that, we would have to add an option to CREATE INDEX to create it
> in an invalid state. Which is stupid...
Only in a binary-upgrade mode.
Thanks,
Stephen
In response to
pgsql-hackers by date
Next :From: Stephen FrostDate: 2012-12-07 03:34:25Subject : Re: Commits 8de72b and 5457a1 (COPY FREEZE)Previous :From : Stephen FrostDate : 2012-12-07 03:27:21Subject : Re: pg_upgrade problem with invalid indexes
