Thread: pg_upgrade log files

pg_upgrade log files

From
Alvaro Herrera
Date:
Right now, the pg_upgrade output files contain the output of the
commands it runs.  However, it does not contain the actual commands
being run ... so if you want to figure out what is happening, you have
to trace the pg_upgrade source while reading the log file.

This is, to say the least, suboptimal.

I propose this patch which echoes the commands to the respective log
files.  I would backpatch this to 9.2.

As a note, I find the exec_prog() function rather bizarre.  It would be
better if the caller did not have to manually specify a redirection, for
instance.

--
Álvaro Herrera <alvherre@alvh.no-ip.org>

Attachment

Re: pg_upgrade log files

From
Tom Lane
Date:
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> I propose this patch which echoes the commands to the respective log
> files.  I would backpatch this to 9.2.

OK, but the fflush just before fclose seems a bit pointless; fclose
will do that anyway no?
        regards, tom lane


Re: pg_upgrade log files

From
Alvaro Herrera
Date:
Excerpts from Tom Lane's message of vie jun 29 01:04:13 -0400 2012:
> Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> > I propose this patch which echoes the commands to the respective log
> > files.  I would backpatch this to 9.2.
>
> OK, but the fflush just before fclose seems a bit pointless; fclose
> will do that anyway no?

Bah, yes, thanks.  Pushed with that change.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support