I just upgraded PostgreSQL to postgresql-9.0.2-1-windows_x64 on my main system. I wanted to do a completely clean install, so I made backups (using pgAdmin) of all my 8.x databases, then uninstalled v8.x, wiped out the Postgres user, and deleted the data directory.
I rebooted, and then performed a fresh install of postgresql-9.0.2-1-windows_x64. Everything installed correctly, but now I'm getting the same errors as ProsperousOne when trying to restore.
I google'd around a bit, and this problem is definitely occurring due to the escape character (\) before the double quotes (") in the restore command. I know that ProsperousOne did make mention of this, but I'm not sure if he ever figured out the correct command to make the backup work.
Here's the exact command that needs to be entered:
Code:
"C:/Program Files/PostgreSQL/9.0/bin\pg_restore.exe" --host localhost --port 5432 --username postgres --dbname "P1 Laptop" --verbose "C:\Documents and Settings\Steve Sundberg\Desktop\P1 DB 122410.backup"
You can open up a command prompt and just copy and paste the above command, as long as the DB name and backup names are still the same. The empty DB needs to be created (in pgAdmin) with correct properties ahead of time.
The only thing I can really think of as to why this is happening is that the most recent pgAdmin tool must have some incorrect hard-coded commands.