cancel
Showing results for 
Search instead for 
Did you mean: 

pg_upgrade Alfresco postgresql 9.3.6 and no success

dba100
Star Contributor
Star Contributor

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..

2 REPLIES 2

abhinavmishra14
World-Class Innovator
World-Class Innovator

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

~Abhinav
(ACSCE, AWS SAA, Azure Admin)

"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?