Re: pg_upgrade "configdir" vs "datadir"

On Fri, Jul 26, 2019 at 09:23:28PM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/11/pgupgrade.html
> Description:
> 
> pg_upgrade seems to assume that the datadir and the configdir are the same
> but on Debian/Ubuntu they are not the same by default (installing from the
> postgres repository).
> 
> The current documentation:
> 
> -d configdir
> --old-datadir=configdir
> 
>     the old database cluster configuration directory; environment variable
> PGDATAOLD
> 
> -D configdir
> --new-datadir=configdir
> 
>     the new database cluster configuration directory; environment variable
> PGDATANEW
> 
> In order for this to work on Debian/Ubuntu you need to also pass some
> options with the actual configuration directory.  For example:
> 
> -o 'config_file=/etc/postgresql/9.6/main/postgresql.conf'
> -O 'config_file=/etc/postgresql/10/main/postgresql.conf'
> 
> I think the documentation could use some clarification on this point.

Uh, I am confused.  -d and -D are supposed to specify where
postgresql.conf is.  Are you saying that doesn't work.  Can you show us
the file paths, and the errors you see?

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +