Re: migracao postgresql com erro
On 29-05-2015 18:28, Fred Maranhão wrote: É um tiro no escuro, mas talvez possa ser isso: https://wiki.postgresql.org/wiki/May_2015_Fsync_Permissions_Bug -- To UNSUBSCRIBE, email to debian-user-portuguese-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: https://lists.debian.org/5568e010.2020...@gmail.com
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 21 esperando o servidor iniciarpostgres 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 21 waiting for server to startpostgres 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 -- To UNSUBSCRIBE, email to debian-user-portuguese-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: https://lists.debian.org/capr829kwecdltqvehwjnnnoxp2jqrpztqdhtdsbmf8oscwz...@mail.gmail.com