pgsql: Fix assorted inconsistent function declarations.

Fix assorted inconsistent function declarations.

While gcc doesn't complain if you declare a function "static" and then
define it not-static, other compilers do; and in any case the code is
highly misleading this way.  Add the missing "static" keywords to a
couple of recent patches.  Per buildfarm member pademelon.

Branch
------
REL9_0_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/248c096b265d1169a45f91c99fcc74b34544f290

Modified Files
--------------
contrib/pg_upgrade/pg_upgrade.c     |    2 +-
src/bin/pg_resetxlog/pg_resetxlog.c |    2 +-
2 files changed, 2 insertions(+), 2 deletions(-)