I took a backup of Postgresql db from system1 using the pgadmin3 tool. The created backup file has the extension ".backup"
I am trying to restore it on another system2 installed with postgresql 9.0 and pgadmin3 1.8. But I get an error:
query failed: ERROR: unrecognized configuration parameter Command "lock_timeout": SET lock_timeout = 0;
The configuration of both systems:
system1 win7-64bit postgresql 9.0.13-1 - 64bit pgadmin 1.8
system2 win7-32bit postgresql 9.0.13-1 - 32bit pgadmin 1.8
pgAdmin , ( ), PostgreSQL, . pgAdmin PostgreSQL, . , , , PostgreSQL, .
→ → PG bin PostgreSQL ( , , ).
PG , PostgreSQL pgAdmin. , PostgreSQL , . pgAdmin , , gui ( ) ( , - no-password).
Lock_timeout 9.3. pgAdmin. .
(psql , pg_restore ).