This doc sentence about pg_upgrade is now inaccurate:
If doing <option>--check</> with a running old server of a pre-9.1 version,
and the old server is using a Unix-domain socket directory that is
different from the default built into the new <productname>PostgreSQL</>
installation, set <envar>PGHOST</> to point to the socket location of the
old server. (This is not relevant on Windows.)
The new detail is that this also affects non-live check and non-check
upgrades because pg_ctl -w doesn't work for pre-9.1 servers with the
socket in the current directory --- that was not known when this
documentation paragraph was written.
Applied doc patch attached. The wording became pretty complex so I
tried to simplify it.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
diff --git a/doc/src/sgml/pgupgrade.sgml b/doc/src/sgml/pgupgrade.sgml
new file mode 100644
index 9e43f3c..301222c
*** a/doc/src/sgml/pgupgrade.sgml
--- b/doc/src/sgml/pgupgrade.sgml
*************** psql --username postgres --file script.s
*** 520,530 ****
</para>
<para>
! If doing <option>--check</> with a running old server of a pre-9.1 version,
! and the old server is using a Unix-domain socket directory that is
! different from the default built into the new <productname>PostgreSQL</>
! installation, set <envar>PGHOST</> to point to the socket location of the
! old server. (This is not relevant on Windows.)
</para>
<para>
--- 520,529 ----
</para>
<para>
! If using a pre-9.1 old server that is using a non-default Unix-domain
! socket directory or a default that differs from the default of the
! new cluster, set <envar>PGHOST</> to point to the old server's socket
! location. (This is not relevant on Windows.)
</para>
<para>
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
