Thread: Pg_upgrade problem.
When I am trying to upgrade 9.6 to 10 . I'M getting this error , please help me out
pg_upgrade check for "/opt/postgresql/10/bin/passwd" failed: no such file or directory failure, exiting
On 4/15/21 9:43 AM, obi reddy wrote: > When I am trying to upgrade 9.6 to 10 . I'M getting this error , please > help me out What OS and version? Where did you install Postgres from? > > pg_upgrade check for "/opt/postgresql/10/bin/passwd" failed: no such > file or directory failure, exiting AFAIK, passwd is not a regular binary in the community edition. Have you installed an extension in the 9.6 instance that you have not installed in the 10 instance? Or something else along that line? -- Adrian Klaver adrian.klaver@aklaver.com
Yeah I have installed 10 and OS version is 6.4.
> When I am trying to upgrade 9.6 to 10 . I'M getting this error , please
> help me out
What OS and version?
Where did you install Postgres from?
>
> pg_upgrade check for "/opt/postgresql/10/bin/passwd" failed: no such
> file or directory failure, exiting
AFAIK, passwd is not a regular binary in the community edition. Have you
installed an extension in the 9.6 instance that you have not installed
in the 10 instance? Or something else along that line?
--
Adrian Klaver
adrian.klaver@aklaver.com
On 4/15/21 10:33 AM, obi reddy wrote: > Yeah I have installed 10 and OS version is 6.4. What is the actual OS? Where did you install 9.6 and 10 from? > > > When I am trying to upgrade 9.6 to 10 . I'M getting this error , > please > > help me out > > What OS and version? > > Where did you install Postgres from? > > > > > pg_upgrade check for "/opt/postgresql/10/bin/passwd" failed: no such > > file or directory failure, exiting > > AFAIK, passwd is not a regular binary in the community edition. Have > you > installed an extension in the 9.6 instance that you have not installed > in the 10 instance? Or something else along that line? > > > -- > Adrian Klaver > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > -- Adrian Klaver adrian.klaver@aklaver.com
I have instal 10.0 side and OS is centos 6.4 64 bit
What is the actual OS?
Where did you install 9.6 and 10 from?
>
> > When I am trying to upgrade 9.6 to 10 . I'M getting this error ,
> please
> > help me out
>
> What OS and version?
>
> Where did you install Postgres from?
>
> >
> > pg_upgrade check for "/opt/postgresql/10/bin/passwd" failed: no such
> > file or directory failure, exiting
>
> AFAIK, passwd is not a regular binary in the community edition. Have
> you
> installed an extension in the 9.6 instance that you have not installed
> in the 10 instance? Or something else along that line?
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
On 4/15/21 10:49 AM, obi reddy wrote:
> I have instal 10.0 side and OS is centos 6.4 64 bit
What was the source for the installs of the 9.6 and 10 instances of
Postgres?:
1) RPM
If so from what repo?
2) Other
If so what and from where?
>
>
>
>
> What is the actual OS?
>
> Where did you install 9.6 and 10 from?
>
> >
> > > When I am trying to upgrade 9.6 to 10 . I'M getting
> this error ,
> > please
> > > help me out
> >
> > What OS and version?
> >
> > Where did you install Postgres from?
> >
> > >
> > > pg_upgrade check for "/opt/postgresql/10/bin/passwd"
> failed: no such
> > > file or directory failure, exiting
> >
> > AFAIK, passwd is not a regular binary in the community
> edition. Have
> > you
> > installed an extension in the 9.6 instance that you have not
> installed
> > in the 10 instance? Or something else along that line?
> >
> >
> > --
> > Adrian Klaver
> > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
> >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
It's a "oneclic "
What was the source for the installs of the 9.6 and 10 instances of
Postgres?:
1) RPM
If so from what repo?
2) Other
If so what and from where?
>
>
>
>
> What is the actual OS?
>
> Where did you install 9.6 and 10 from?
>
> >
> > > When I am trying to upgrade 9.6 to 10 . I'M getting
> this error ,
> > please
> > > help me out
> >
> > What OS and version?
> >
> > Where did you install Postgres from?
> >
> > >
> > > pg_upgrade check for "/opt/postgresql/10/bin/passwd"
> failed: no such
> > > file or directory failure, exiting
> >
> > AFAIK, passwd is not a regular binary in the community
> edition. Have
> > you
> > installed an extension in the 9.6 instance that you have not
> installed
> > in the 10 instance? Or something else along that line?
> >
> >
> > --
> > Adrian Klaver
> > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
> >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
On 4/15/21 2:00 PM, obi reddy wrote: > It's a "oneclic " From here?: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads To get an answer you will need to provide as much basic information as you can. So in addition to what you have provided we need: 1) Is the 9.6 instance also from EDB(enterprisedb.com)? 2) Have you created any extensions in the 9.6 instance and if so what? 3) Is there a '/opt/postgresql/96/bin/passwd'? 4) Is there a '/opt/postgresql/10/bin/passwd'? 5) What is the complete pg_upgrade command you are using? > > > What was the source for the installs of the 9.6 and 10 instances of > Postgres?: > > 1) RPM > If so from what repo? > > 2) Other > If so what and from where? > > > > > > > > > > > What is the actual OS? > > > > Where did you install 9.6 and 10 from? > > > > > > > > > When I am trying to upgrade 9.6 to 10 . I'M getting > > this error , > > > please > > > > help me out > > > > > > What OS and version? > > > > > > Where did you install Postgres from? > > > > > > > > > > > pg_upgrade check for "/opt/postgresql/10/bin/passwd" > > failed: no such > > > > file or directory failure, exiting > > > > > > AFAIK, passwd is not a regular binary in the community > > edition. Have > > > you > > > installed an extension in the 9.6 instance that you > have not > > installed > > > in the 10 instance? Or something else along that line? > > > > > > > > > -- > > > Adrian Klaver > > > adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com> <mailto:adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com>> > > <mailto:adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com> <mailto:adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com>>> > > > > > > > > > -- > > Adrian Klaver > > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> > > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > -- Adrian Klaver adrian.klaver@aklaver.com
Thank you for your response. Problem is resolved. I tried another way its working fine.
Thank you so much
OBIREDDY. G
> It's a "oneclic "
From here?:
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
To get an answer you will need to provide as much basic information as
you can. So in addition to what you have provided we need:
1) Is the 9.6 instance also from EDB(enterprisedb.com)?
2) Have you created any extensions in the 9.6 instance and if so what?
3) Is there a '/opt/postgresql/96/bin/passwd'?
4) Is there a '/opt/postgresql/10/bin/passwd'?
5) What is the complete pg_upgrade command you are using?
>
>
> What was the source for the installs of the 9.6 and 10 instances of
> Postgres?:
>
> 1) RPM
> If so from what repo?
>
> 2) Other
> If so what and from where?
>
> >
> >
> >
> >
> > What is the actual OS?
> >
> > Where did you install 9.6 and 10 from?
> >
> > >
> > > > When I am trying to upgrade 9.6 to 10 . I'M getting
> > this error ,
> > > please
> > > > help me out
> > >
> > > What OS and version?
> > >
> > > Where did you install Postgres from?
> > >
> > > >
> > > > pg_upgrade check for "/opt/postgresql/10/bin/passwd"
> > failed: no such
> > > > file or directory failure, exiting
> > >
> > > AFAIK, passwd is not a regular binary in the community
> > edition. Have
> > > you
> > > installed an extension in the 9.6 instance that you
> have not
> > installed
> > > in the 10 instance? Or something else along that line?
> > >
> > >
> > > --
> > > Adrian Klaver
> > > adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com> <mailto:adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>>
> > <mailto:adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com> <mailto:adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>>>
> > >
> >
> >
> > --
> > Adrian Klaver
> > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
> >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com