pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed20110408pg upgrade fix: How do I know if I am being affected before errors occur
3+ messages / 2 participants
[nested] [flat]
* 20110408pg upgrade fix: How do I know if I am being affected before errors occur
@ 2011-04-09 14:21 Erwin Brandstetter <brsaweda@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Erwin Brandstetter @ 2011-04-09 14:21 UTC (permalink / raw)
To: pgsql-admin
Hello!
In connection with the recently discovered bug with pg_upgrade:
http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix
If I an not sure whether pg_upgrade or pg_migrate has been applied on
certain databases in the past:
- How do I know if I am being affected by the bug _before_ errors
occur?
- Can applying the proposed fix break anything if the db wasn't
affected to begin with?
Information as to that is missing in the mail to pgsql-
announce@postgresql.org as well as on the wiki-page.
Thank You! Regards
Erwin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 20110408pg upgrade fix: How do I know if I am being affected before errors occur
@ 2011-04-09 14:31 Stephen Frost <sfrost@snowman.net>
parent: Erwin Brandstetter <brsaweda@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Stephen Frost @ 2011-04-09 14:31 UTC (permalink / raw)
To: Erwin Brandstetter <brsaweda@gmail.com>; +Cc: pgsql-admin
Erwin,
* Erwin Brandstetter (brsaweda@gmail.com) wrote:
> - Can applying the proposed fix break anything if the db wasn't
> affected to begin with?
Running a database-wide 'vacuum freeze;' will either succeed (and all
will be well), or it'll generate the errors in the message (in which
case you'll need to restore the CLOG files, as at the wiki page, and
then re-run the 'vacuum freeze;').
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 20110408pg upgrade fix: How do I know if I am being affected before errors occur
@ 2011-04-11 00:43 Erwin Brandstetter <brsaweda@gmail.com>
parent: Stephen Frost <sfrost@snowman.net>
0 siblings, 0 replies; 3+ messages in thread
From: Erwin Brandstetter @ 2011-04-11 00:43 UTC (permalink / raw)
To: pgsql-admin
On Apr 9, 4:31 pm, sfr...@snowman.net (Stephen Frost) wrote:
> Running a database-wide 'vacuum freeze;' will either succeed (and all
> will be well), or it'll generate the errors in the message (in which
> case you'll need to restore the CLOG files, as at the wiki page, and
> then re-run the 'vacuum freeze;').
Thank you! My DBs seem to be in the clear. :)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-04-11 00:43 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-04-09 14:21 20110408pg upgrade fix: How do I know if I am being affected before errors occur Erwin Brandstetter <brsaweda@gmail.com>
2011-04-09 14:31 ` Stephen Frost <sfrost@snowman.net>
2011-04-11 00:43 ` Erwin Brandstetter <brsaweda@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox