currently want to upgrade Alfresco postgresql 9.3.6 to official postgreSQL 11.14.1/13.5.2 by this command:
"D:\postgresql-11.14\pgsql\bin\pg_upgrade.exe" --old-bindir="D:\Alfresco\postgresql\bin" --new-bindir="D:\Program Files\PostgreSQL\11\bin" --old-datadir="D:\Alfresco\alf_data\postgresql" --new-datadir="D:\Program Files\PostgreSQL\11\data"
-U postgres --old-port=5432 --new-port=5434 --check --verbose --jobs=8
but it always has error, any idea:
database user "postgres" is not the install user
Failure, exiting
"D:/Alfresco/postgresql/bin/pg_ctl" -w -D "D:/Alfresco/alf_data/postgresql" -o "
" -m fast stop >> "pg_upgrade_utility.log" 2>&1
I already login to windows using postgres account but still that..
Check which user was used to create the old db, you can find some info here:
https://stackoverflow.com/questions/41854387/database-user-postgres-is-not-the-install-user
Also, did you tried backup and restore db to new pg db ? it would be an alternative
"https://stackoverflow.com/questions/41854387/database-user-postgres-is-not-the-install-user"
initdb -U dimid
but we are using Alfresco postgresql 9.3.6 on Windows, this command is not going to works, right?
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.