windows 7, PostgreSQL 9.4/ArcSDE/PostGIS backend database that I am transferring to another computer.
My backup command is as follows. host 5433
pg_dumpall -h localhost -p 5433 -U postgres -c -f "file.backup"
backups up all nice and everything.
when I go to restore it on windows 10, PostgreSQL 9.4, port 5433 I run
psql -h localhost -p 5433 -U postgres -f file.backup
so everything restores okay. All tables, schemas, logins are good. I can connect with QGIS and everything works fine.
When I go to add an ArcGIS database connection I get this error
I uninstalled postgres on the new computer reinstalled 9.5,
psql -h localhost -p 5432 -U postgres -f file.backup on port 5432 and in the CMD I found 1 error it should while it is running the restore
psql:R:/Data/LUCZ_2017/blah.backup:12531010: ERROR: relation "gdb_items" does not exist
whats going on here!
Based on Evan Carroll's suggestion I ran
C:\Program Files\PostgreSQL\9.5\bin>psql \duS+ Password: psql: FATAL: password authentication failed for user "rizagha"
the CMD wouldn't let me enter my password, I pressed enter and received the above error