-
-
Save RyanTG/156e9b8f6fa4456394936b55fd573848 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[postgres@MasterControlUnit tmp]$ /usr/bin/pg_upgrade -b /opt/pgsql-12/bin -B /usr/bin -d /home/postgres/olddata -D /home/postgres/data -v -c | |
Running in verbose mode | |
Performing Consistency Checks | |
----------------------------- | |
Checking cluster versions ok | |
Current pg_control values: | |
pg_control version number: 1201 | |
Catalog version number: 201909212 | |
Database system identifier: 6769081269480364455 | |
Latest checkpoint's TimeLineID: 1 | |
Latest checkpoint's full_page_writes: on | |
Latest checkpoint's NextXID: 0:283349 | |
Latest checkpoint's NextOID: 2948402 | |
Latest checkpoint's NextMultiXactId: 1 | |
Latest checkpoint's NextMultiOffset: 0 | |
Latest checkpoint's oldestXID: 561 | |
Latest checkpoint's oldestXID's DB: 16500 | |
Latest checkpoint's oldestActiveXID: 0 | |
Latest checkpoint's oldestMultiXid: 1 | |
Latest checkpoint's oldestMulti's DB: 16500 | |
Latest checkpoint's oldestCommitTsXid:0 | |
Latest checkpoint's newestCommitTsXid:0 | |
Maximum data alignment: 8 | |
Database block size: 8192 | |
Blocks per segment of large relation: 131072 | |
WAL block size: 8192 | |
Bytes per WAL segment: 16777216 | |
Maximum length of identifiers: 64 | |
Maximum columns in an index: 32 | |
Maximum size of a TOAST chunk: 1996 | |
Size of a large-object chunk: 2048 | |
Date/time type storage: 64-bit integers | |
Float4 argument passing: by value | |
Float8 argument passing: by value | |
Data page checksum version: 0 | |
Values to be changed: | |
First log segment after reset: 00000001000000300000005B | |
Current pg_control values: | |
pg_control version number: 1300 | |
Catalog version number: 202007201 | |
Database system identifier: 6911813593326985747 | |
Latest checkpoint's TimeLineID: 1 | |
Latest checkpoint's full_page_writes: on | |
Latest checkpoint's NextXID: 0:485 | |
Latest checkpoint's NextOID: 13446 | |
Latest checkpoint's NextMultiXactId: 1 | |
Latest checkpoint's NextMultiOffset: 0 | |
Latest checkpoint's oldestXID: 478 | |
Latest checkpoint's oldestXID's DB: 1 | |
Latest checkpoint's oldestActiveXID: 0 | |
Latest checkpoint's oldestMultiXid: 1 | |
Latest checkpoint's oldestMulti's DB: 1 | |
Latest checkpoint's oldestCommitTsXid:0 | |
Latest checkpoint's newestCommitTsXid:0 | |
Maximum data alignment: 8 | |
Database block size: 8192 | |
Blocks per segment of large relation: 131072 | |
WAL block size: 8192 | |
Bytes per WAL segment: 16777216 | |
Maximum length of identifiers: 64 | |
Maximum columns in an index: 32 | |
Maximum size of a TOAST chunk: 1996 | |
Size of a large-object chunk: 2048 | |
Date/time type storage: 64-bit integers | |
Float8 argument passing: by value | |
Data page checksum version: 0 | |
Values to be changed: | |
First log segment after reset: 000000010000000000000002 | |
"/opt/pgsql-12/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/home/postgres/olddata" -o "-p 50432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/home/postgres/tmp'" start >> "pg_upgrade_server.log" 2>&1 | |
*failure* | |
There were problems executing ""/opt/pgsql-12/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/home/postgres/olddata" -o "-p 50432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/home/postgres/tmp'" start >> "pg_upgrade_server.log" 2>&1" | |
Consult the last few lines of "pg_upgrade_server.log" for | |
the probable cause of the failure. | |
connection to database failed: could not connect to server: No such file or directory | |
Is the server running locally and accepting | |
connections on Unix domain socket "/home/postgres/tmp/.s.PGSQL.50432"? | |
could not connect to source postmaster started with the command: | |
"/opt/pgsql-12/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/home/postgres/olddata" -o "-p 50432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/home/postgres/tmp'" start | |
Failure, exiting |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment