8.х проблемы с Restore в Postgre SQL 8.1

Тема в разделе "Установка платформы "1С:Предприятие 8"", создана пользователем Ekklesiast, 1 июл 2008.

  1. TopicStarter Overlay
    Ekklesiast
    Offline

    Ekklesiast

    Регистрация:
    1 июл 2008
    Сообщения:
    13
    Симпатии:
    0
    Баллы:
    1
    Вообщем запустил 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 restore
    pg_restore: [archiver (db)] Error while INITIALIZING:
    pg_restore: [archiver (db)] could not execute query: ERROR:  invalid byte sequence for encoding "UTF8": 0xd1e5
    HINT:  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 public
    pg_restore: creating COMMENT SCHEMA public
    pg_restore: creating PROCEDURAL LANGUAGE plpgsql
    pg_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) postgres
    pg_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) postgres
    pg_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) postgres
    pg_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) postgres
    pg_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 mchar
    pg_restore: [archiver (db)] Error from TOC entry 415; 1247 28535 TYPE mchar postgres
    pg_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,
    
  2. lazy
    Offline

    lazy Модераторы Команда форума Модератор

    Регистрация:
    1 сен 2007
    Сообщения:
    2.127
    Симпатии:
    4
    Баллы:
    29
    Сильно подозреваю, что есть смысл с таким вопросом обратится на SQL.RU - там спецов именно по базам данных больше водится...

Поделиться этой страницей