Zdenek Kotala wrote:
> 2) pg_upgrade.sh
> http://archives.postgresql.org/pgsql-hackers/2008-12/msg00248.php
>
> Pg_upgrade.sh is shell script for catalog conversion. It works for
> 8.3->8.4 upgrade.
What's the reason this script uses a postmaster? It seems it would be
easier to control if you used a standalone backend (--single) for each
time you are piping stuff to psql. That would reduce the need to
configure authentication, hostnames, etc etc.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support