Re: Error Upgrade PostgreSQL 9.4 to 9.5 in Debian - Solved

From: Edson Analista <edson(at)openmailbox(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error Upgrade PostgreSQL 9.4 to 9.5 in Debian - Solved
Date: 2016-08-28 03:19:08
Message-ID: d455955d-de99-9299-7de6-218b9cb47e56@openmailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Em 28-08-2016 00:08, Tom Lane escreveu:
> Edson Analista <edson(at)openmailbox(dot)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'

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2016-08-28 23:59:34 Re: a column definition list is required for functions returning "record"
Previous Message Tom Lane 2016-08-28 03:08:09 Re: Error Upgrade PostgreSQL 9.4 to 9.5 in Debian