pg_upgrade "configdir" vs "datadir"

Started by PG Bug reporting formalmost 7 years ago2 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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.

#2Bruce Momjian
bruce@momjian.us
In reply to: PG Bug reporting form (#1)
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 +