pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_upgrade "configdir" vs "datadir"
2+ messages / 2 participants
[nested] [flat]
* pg_upgrade "configdir" vs "datadir"
@ 2019-07-26 21:23 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2019-07-26 21:23 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: gregory@arenius.com
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_upgrade "configdir" vs "datadir"
@ 2019-07-30 00:42 Bruce Momjian <bruce@momjian.us>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2019-07-30 00:42 UTC (permalink / raw)
To: gregory@arenius.com; pgsql-docs@lists.postgresql.org
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 +
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-07-30 00:42 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-07-26 21:23 pg_upgrade "configdir" vs "datadir" PG Doc comments form <noreply@postgresql.org>
2019-07-30 00:42 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox