Pg_upgrade problem.

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.

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

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 "

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