Postgres Pro
Downloads
Home   >   mailing lists

pg_upgrade failing with error pg_resetxlog no such file - Mailing list pgsql-admin

From Debraj Manna
Subject pg_upgrade failing with error pg_resetxlog no such file
Date
Msg-id CAF6DVKPU-G7o_cT_NzhbQh48o+iRhUPOZPkJb0EygFeH-ci10w@mail.gmail.com
Whole thread Raw
Responses Re: pg_upgrade failing with error pg_resetxlog no such file  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
Tree view
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@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,

pgsql-admin by date:

Previous
From: AYahorau@ibagroup.eu
Date:
Subject: Re: Logical replication monitoring
Next
From: Bruce Momjian
Date:
Subject: Re: How to revoke privileged from PostgreSQL's superuser