-
Notifications
You must be signed in to change notification settings - Fork 126
Open
Description
Hi! I'm looking for help in upgrading 17 to 18:
> find /mnt/Apps-SSD-NoRedund/redacted_dir -mindepth 2 -maxdepth 2
/redacted_dir/18/docker
/redacted_dir/17/docker
> docker run --rm --mount 'type=bind,src=/redacted_dir,dst=/var/lib/postgresql' \
--env 'PGDATAOLD=/var/lib/postgresql/17/docker' \
--env 'PGDATANEW=/var/lib/postgresql/18/docker' \
tianon/postgres-upgrade:17-to-18 \
--link
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are enabled.
fixing permissions on existing directory /var/lib/postgresql/18/docker ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default "max_connections" ... 100
selecting default "shared_buffers" ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
Success. You can now start the database server using:
pg_ctl -D /var/lib/postgresql/18/docker -l logfile start
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
old cluster does not use data checksums but the new one does
Failure, exiting
Metadata
Metadata
Assignees
Labels
No labels