Thread: Error Upgrade PostgreSQL 9.4 to 9.5 in Debian
Good night I'm trying to Upgrade PostgreSQL to 9.4 9.5 in Debian 8, I am getting the below error, what could be wrong? Command that I used to do the pg_upgrade /usr/lib/postgresql/9.5/bin/pg_upgrade -b /usr/lib/postgresql/9.4/bin/ \-B /usr/lib/postgresql/9.5/bin/ \-d /var/lib/postgresql/9.4/main \-D /var/lib/postgresql/9.5/main \-o ‘ -c config_file=/etc/postgresql/9.4/main/postgresql.conf’ \-O ‘ -c config_file=/etc/postgresql/9.5/main/postgresql.conf ----------------------------------------------------------------- pg_upgrade run on Sat Aug 27 23:22:27 2016 ----------------------------------------------------------------- command: "/usr/lib/postgresql/9.4/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/postgresql/9.4/main" -o "-p 50432 -b ‘ -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/home/lidorio/edinho/lixo'" start >> "pg_upgrade_server.log" 2>&1 esperando o servidor iniciar....postgres: argumento é inválido: "‘" Tente "postgres --help" para obter informações adicionais. parou de esperar pg_ctl: não pode iniciar o servidor Examine o arquivo de log.
Edson Analista <edson@openmailbox.org> writes: > I'm trying to Upgrade PostgreSQL to 9.4 9.5 in Debian 8, I am getting > the below error, what could be wrong? I think your problem is that you're using fancy quotes instead of plain ASCII single quotes in your pg_upgrade command line. Those are getting taken as arguments, not quotes. regards, tom lane
Em 28-08-2016 00:08, Tom Lane escreveu: > Edson Analista <edson@openmailbox.org> writes: >> I'm trying to Upgrade PostgreSQL to 9.4 9.5 in Debian 8, I am getting >> the below error, what could be wrong? > > I think your problem is that you're using fancy quotes instead of plain > ASCII single quotes in your pg_upgrade command line. Those are getting > taken as arguments, not quotes. > > regards, tom lane > Solved Thank you The problem was even quotes. The correct command went like this: /usr/lib/postgresql/9.5/bin/pg_upgrade -b /usr/lib/postgresql/9.4/bin/ \-B /usr/lib/postgresql/9.5/bin/ \-d /var/lib/postgresql/9.4/main \-D /var/lib/postgresql/9.5/main \-o ' -c config_file=/etc/postgresql/9.4/main/postgresql.conf' \-O ' -c config_file=/etc/postgresql/9.5/main/postgresql.conf'