pg_upgrade Alfresco postgresql 9.3.6 and no success

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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..
- Labels:
-
Alfresco Content Services
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
(ACSCE, AWS SAA, Azure Admin)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
