Вообщем запустил Postgre SQL 8.1 который шёл в поставке 1С, всё поставил по книге, всё фурычит, снимается бэкап, но он сцуко не ресторится и выдаёт ошибку (опишу часть кода)

авторF:\PosrgreSQL\bin\pg_restore.exe -i -h localhost -p 5432 -U postgres -d "HBP(test)" -v "D:\1.backup"pg_restore: connecting to database for restorepg_restore: [archiver (db)] Error while INITIALIZING:pg_restore: [archiver (db)] could not execute query: ERROR: invalid byte sequence for encoding "UTF8": 0xd1e5HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". Command was: ---- PostgreSQL database dump---- Started on 2008-07-01 16:48:15 Ñåâåðíàÿ Öåíòð. Àçèÿ (ëåòî)SET client_encoding = 'UTF8';pg_restore: creating SCHEMA publicpg_restore: creating COMMENT SCHEMA publicpg_restore: creating PROCEDURAL LANGUAGE plpgsqlpg_restore: [archiver (db)] Error while PROCESSING TOC:pg_restore: [archiver (db)] Error from TOC entry 6920; 2612 16386 PROCEDURAL LANGUAGE plpgsql pg_restore: [archiver (db)] could not execute query: ERROR: language "plpgsql" already exists Command was: CREATE PROCEDURAL LANGUAGE plpgsql;pg_restore: creating FUNCTION mchar_in(cstring)pg_restore: [archiver (db)] Error from TOC entry 25; 1255 28536 FUNCTION mchar_in(cstring) postgrespg_restore: [archiver (db)] could not execute query: ERROR: function "mchar_in" already exists with same argument types Command was: CREATE FUNCTION mchar_in(cstring) RETURNS mchar AS '$libdir/mchar', 'mchar_in' LANGUAGE c IMMUTABLE STRICT;pg_restore: creating FUNCTION mchar_out(mchar)pg_restore: [archiver (db)] Error from TOC entry 26; 1255 28537 FUNCTION mchar_out(mchar) postgrespg_restore: [archiver (db)] could not execute query: ERROR: function "mchar_out" already exists with same argument types Command was: CREATE FUNCTION mchar_out(mchar) RETURNS cstring AS '$libdir/mchar', 'mchar_out' LANGUAGE c IMMUTABLE STRICT;pg_restore: creating FUNCTION mchar_recv(internal)pg_restore: [archiver (db)] Error from TOC entry 28; 1255 28539 FUNCTION mchar_recv(internal) postgrespg_restore: [archiver (db)] could not execute query: ERROR: function "mchar_recv" already exists with same argument types Command was: CREATE FUNCTION mchar_recv(internal) RETURNS mchar AS '$libdir/mchar', 'mchar_recv' LANGUAGE c IMMUTABLE STRICT;pg_restore: creating FUNCTION mchar_send(mchar)pg_restore: [archiver (db)] Error from TOC entry 27; 1255 28538 FUNCTION mchar_send(mchar) postgrespg_restore: [archiver (db)] could not execute query: ERROR: function "mchar_send" already exists with same argument types Command was: CREATE FUNCTION mchar_send(mchar) RETURNS bytea AS '$libdir/mchar', 'mchar_send' LANGUAGE c IMMUTABLE STRICT;pg_restore: creating TYPE mcharpg_restore: [archiver (db)] Error from TOC entry 415; 1247 28535 TYPE mchar postgrespg_restore: [archiver (db)] could not execute query: ERROR: type "mchar" already exists Command was: CREATE TYPE mchar ( INTERNALLENGTH = variable, INPUT = mchar_in, OUTPUT = mchar_out, RECEIVE = mchar_recv,

Проблема решена. Плохо гуглил. Нужно делать последовательно dropdb -> createdb -> pg_restore.