pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRES: 20110408pg upgrade fix: How do I know if I am being affected before errors occur
2+ messages / 2 participants
[nested] [flat]
* RES: 20110408pg upgrade fix: How do I know if I am being affected before errors occur
@ 2011-04-14 19:07 Carlos Sotto Maior (SIM) <csotto@sistemassim.com.br>
0 siblings, 1 reply; 2+ messages in thread
From: Carlos Sotto Maior \(SIM\) @ 2011-04-14 19:07 UTC (permalink / raw)
To: pgsql-admin
Hi,
I just noticed this thread today.
I am running 9.0.3. I Read the 20110408 upgrade fix announcement, checked
pg_clog/ and noticed that it show only a single 0000 file.
I understand I may be hit by the mentioned problem.
Yes, I do have all tar archives available, but since my Database is
relatively small I can afford dumping / recreating and restoring this night
which is great.
My questions are:
Having a single 0000 in the pg_clog directory is indicative that my database
has been hit ?
If I run a database wise 'vacuum freeze' and all goes well does it means I
do not have to take any action?
Dumping and recreating the data base would be my best option to get rid of
this potential problem. Correct ?
Thanks,
Carlos Sotto Maior
+55 11 8244-7899
csotto@sistemassim.com.br
Sistemas Sim Serviços e Tecnologia Ltda.
+55 11 5041-3086
Rua Tenente Gomes Ribeiro, 78
Vila Clementino (Próximo ao Metro Santa Cruz)
São Paulo - SP
04038-040
-----Mensagem original-----
De: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] Em nome de Stephen Frost
Enviada em: sábado, 9 de abril de 2011 11:32
Para: Erwin Brandstetter
Cc: pgsql-admin@postgresql.org
Assunto: Re: [ADMIN] 20110408pg upgrade fix: How do I know if I am being
affected before errors occur
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: RES: 20110408pg upgrade fix: How do I know if I am being affected before errors occur
@ 2011-04-14 21:24 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Carlos Sotto Maior (SIM) <csotto@sistemassim.com.br>
0 siblings, 0 replies; 2+ messages in thread
From: Kevin Grittner @ 2011-04-14 21:24 UTC (permalink / raw)
To: pgsql-admin; Carlos Sotto Maior (SIM) <csotto@sistemassim.com.br>
"Carlos Sotto Maior (SIM)" <csotto@sistemassim.com.br> wrote:
> If I run a database wise 'vacuum freeze' and all goes well does it
> means I do not have to take any action?
If you run it in all databases except template0, and it doesn't
generate any errors, you are good.
> Dumping and recreating the data base would be my best option to
> get rid of this potential problem. Correct ?
If you're in a state where a simple VACUUM FREEZE won't fix it, the
pg_dump won't run without error, and won't contain all your data.
-Kevin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-04-14 21:24 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-04-14 19:07 RES: 20110408pg upgrade fix: How do I know if I am being affected before errors occur Carlos Sotto Maior (SIM) <csotto@sistemassim.com.br>
2011-04-14 21:24 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
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