Добрый день!
Прошу вашей помощи по обновлению версии Postgresql c версии 9.1 до версии 9.6 при помощи pg_upgrade
Вдохновившись инструкцией
pg_upgrade я приступил к действию
Порядок моих действий:
Останавливаю Postgresql 9.1
service postgresql stop
Переименовываю паку с БД
mv /var/lib/pgsql-root/var/lib/pgsql /var/lib/pgsql-root/var/lib/pgsql.old
Копирую папку bin от старого Postgresql 9.1
cp -R /usr/bin /usr/bin91
Устанавливаю свежий Postgresql 9.6
apt-get install postgresql9.6-server postgresql9.6-contrib
Инициализирую новую БД
/etc/init.d/postgresql initdb
Правлю конфиги нового Postgresql 9.6.
Запускаю новый Postgresql 9.6 для проверки
service postgresql start
Останавливаю новый Postgresql
service postgresql stop
Запускаю консоль в режиме пользователя postgres, ибо pg_upgrade работает под этим пользователем
su - postgres -s /bin/bash
Выполняю pg_upgrade
pg_upgrade -b /usr/bin91 -B /usr/bin -d /var/lib/pgsql.old/data -D /var/lib/pgsql/data -c -v
Но в итоге получаю вот это:
Спойлер
-bash-3.2$ pg_upgrade -b /usr/bin91 -B /usr/bin -d /var/lib/pgsql.old/data -D /var/lib/pgsql/data -c -v
Running in verbose mode
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
pg_control values:
First log file ID after reset: 0
First log file segment after reset: 8
pg_control version number: 903
Catalog version number: 201105231
Database system identifier: 6385094122559799295
Latest checkpoint's TimeLineID: 1
Latest checkpoint's NextXID: 0/21786
Latest checkpoint's NextOID: 31711
Latest checkpoint's NextMultiXactId: 1
Latest checkpoint's NextMultiOffset: 0
Latest checkpoint's oldestXID: 1280
Latest checkpoint's oldestXID's DB: 1
Latest checkpoint's oldestActiveXID: 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
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
Current pg_control values:
pg_control version number: 960
Catalog version number: 201608131
Database system identifier: 6385146603478635820
Latest checkpoint's TimeLineID: 1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID: 0:1161
Latest checkpoint's NextOID: 13017
Latest checkpoint's NextMultiXactId: 1
Latest checkpoint's NextMultiOffset: 0
Latest checkpoint's oldestXID: 1154
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
Float4 argument passing: by value
Float8 argument passing: by value
Data page checksum version: 0
Values to be changed:
First log segment after reset: 000000010000000000000002
"/usr/bin91/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/pgsql.old/data" -o "-p 50432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/var/lib/pgsql'" start >> "pg_upgrade_server.log" 2>&1
*failure*
There were problems executing ""/usr/bin91/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/pgsql.old/data" -o "-p 50432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/var/lib/pgsql'" 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 "/var/lib/pgsql/.s.PGSQL.50432"?
could not connect to old postmaster started with the command:
"/usr/bin91/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/pgsql.old/data" -o "-p 50432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/var/lib/pgsql'" start
Failure, exiting
-bash-3.2$ echo $PGPORT
-bash-3.2$
Что я делаю не так? что с этим делать - connections on Unix domain socket "/var/lib/pgsql/.s.PGSQL.50432"?