pg_upgrade failing with error pg_resetxlog no such file

From: Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: pg_upgrade failing with error pg_resetxlog no such file
Date: 2018-08-14 18:50:27
Message-ID: CAF6DVKPU-G7o_cT_NzhbQh48o+iRhUPOZPkJb0EygFeH-ci10w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

I am trying to upgrade to postgres 10 from postgres 9.5.4. But on trying to
run pg_upgrade I am getting the below error

ubuntu(at)vrni-platform:/tmp$ sudo -H -u postgres
/usr/lib/postgresql/10/bin/pg_upgrade -b /usr/lib/postgresql/9.5/bin -B
/usr/lib/postgresql/10/bin -d /var/lib/postgresql/data/postgresql0 -D
/var/lib/postgresql/10/data/postgresql0 -o ' -c
config_file=/etc/postgresql/9.5/main/postgresql.conf' -O ' -c
config_file=/etc/postgresql/10/main/postgresql.conf' --check -k

check for "/usr/lib/postgresql/10/bin/pg_resetxlog" failed: No such file or
directory
Failure, exiting

Can someone let me know what is going wrong and how can I use the pg_upgrade
?

Thanks,

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2018-08-14 19:51:09 Re: How to revoke privileged from PostgreSQL's superuser
Previous Message AYahorau 2018-08-14 13:50:08 Re: Logical replication monitoring