02-22-2022 12:53 PM
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..
02-22-2022 04:06 PM
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
02-22-2022 11:04 PM
"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?
Explore our Alfresco products with the links below. Use labels to filter content by product module.