[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

migracao postgresql com erro



alguém pode me explicar se estou fazendo algo errado:

$ /usr/lib/postgresql/9.4/bin/pg_upgrade -b
/usr/lib/postgresql/9.1/bin/ -B /usr/lib/postgresql/9.4/bin/ -d
/var/lib/postgresql/9.1/main -D /var/lib/postgresql/9.4/main ' -c
/etc/postgresql/9.1/main/postgresql.conf ' ' -c
/etc/postgresql/9.4/main/postgresql.conf '
Performing Consistency Checks
-----------------------------
Checking cluster versions                                   ok

*failure*
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/postgresql/.s.PGSQL.50432"?


could not connect to old postmaster started with the command:
"/usr/lib/postgresql/9.1/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D
"/var/lib/postgresql/9.1/main" -o "-p 50432 -b  -c listen_addresses=''
-c unix_socket_permissions=0700 -c
unix_socket_directory='/var/lib/postgresql'" start
Failure, exiting

$ more  pg_upgrade_server.log

-----------------------------------------------------------------
  pg_upgrade run on Fri May 29 11:27:40 2015
-----------------------------------------------------------------

command: "/usr/lib/postgresql/9.1/bin/pg_ctl" -w -l
"pg_upgrade_server.log" -D "/var/lib/postgresql/9.1/mai
n" -o "-p 50432 -b  -c listen_addresses='' -c
unix_socket_permissions=0700 -c unix_socket_directory='/var/l
ib/postgresql'" start >> "pg_upgrade_server.log" 2>&1
esperando o servidor iniciar....postgres não pode acessar o arquivo de
configuração do servidor "/var/lib/post
gresql/9.1/main/postgresql.conf": Arquivo ou diretório não encontrado
....parou de esperar
pg_ctl: não pode iniciar o servidor
Examine o arquivo de log.



-----------------------------------------------------------------
  pg_upgrade run on Fri May 29 11:37:02 2015
-----------------------------------------------------------------

command: "/usr/lib/postgresql/9.1/bin/pg_ctl" -w -l
"pg_upgrade_server.log" -D "/var/lib/postgresql/9.1/mai
n" -o "-p 50432 -b  -c listen_addresses='' -c
unix_socket_permissions=0700 -c unix_socket_directory='/var/l
ib/postgresql'" start >> "pg_upgrade_server.log" 2>&1
waiting for server to start....postgres cannot access the server
configuration file "/var/lib/postgresql/9.
1/main/postgresql.conf": No such file or directory
.... stopped waiting
pg_ctl: could not start server
Examine the log output.


procurando este tal /var/lib/postgresql/9.1/main/postgresql.conf

# find / -name postgresql.conf
/usr/lib/tmpfiles.d/postgresql.conf
/etc/postgresql/9.4/main/postgresql.conf
/etc/postgresql/9.1/main/postgresql.conf


Reply to: