Search Postgresql Archives

Re: Odd postgres12 upgrade is changing or munging a password?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Yes same password, I'm using a basic alter command to put the right password back.

I'm doing another upgrade in an hour, and will do some more checks to see if it's trying to use another password or what. I obviously can't read the password from the file , so knowing if it's munged or other, I'm not sure is possible.

Upgrade command i'm running

time /usr/pgsql-12/bin/pg_upgrade --old-bindir /usr/pgsql-9.5/bin/ --new-bindir /usr/pgsql-12/bin/ --old-datadir /pgsql/9.5/data --new-datadir /pgsql/12/data --link 

So it's very odd. and I've not experienced this in other environments, it's just this one. Now it's a bigger data set, but very odd.

I'm also not seeing any other data issues, just seems to be this one password.

Thanks, 

If there are commands I can run on the data before I do an alter, to give someone more info, let me know

Tory

On Thu, May 7, 2020 at 12:08 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 5/7/20 11:55 AM, Tory M Blue wrote:
> Going from 9.5 to 12 and 2 times now, I've had a password either go
> missing or munged. I've had to add an alter statement at the end of the
> upgrade.

What are the commands you are using?

Is it the same password?

>
> The DB is functioning fine, shut it down, do the upgrade and the
> password is munged. Seems like an odd occurrence, we have not noted any
> other weird issues.
>
> Anyone else see or hear of this?
>
> Thanks
> Tory


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux