Wiederherstellung Sicherung Fehlermeldung

Allgemeines zu PostgreSQL.
Antworten
sisqonrw
Benutzer
Beiträge: 30
Registriert: So 31. Okt 2010, 15:22

Wiederherstellung Sicherung Fehlermeldung

Beitrag von sisqonrw » Mi 10. Jan 2018, 14:36

Hallo,

wollte deine Datenbank auf einem neuen Notebook aufspielen/Wiederherstellen. Bekomme diese Fehler bei diesem Befehl:

Code: Alles auswählen

psql -U postgres ablegoods < ablegoods
hatte vorher

Code: Alles auswählen

createdb -U postgres -W ablegoods --owner=postgres
gemacht.

Erkennt Ihr irgendwo den Fehler?

Code: Alles auswählen

invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
ERROR:  syntax error at or near "Edelstahl"
LINE 1: Edelstahl 304</p> t f f 0 15 79 151 t f f http://www.able-go...
        ^
ERROR:  syntax error at or near "not"
LINE 1: do not update', item_id, item_requirement_spec_id;
           ^
ERROR:  syntax error at or near "float"
LINE 1: float:left;
        ^
ERROR:  syntax error at or near "max"
LINE 1: max-width:250px;
        ^
ERROR:  syntax error at or near "margin"
LINE 1: margin-top:20px:margin-right:10px;
        ^
ERROR:  syntax error at or near "margin"
LINE 1: margin-left:10px;
        ^
ERROR:  syntax error at or near "'::text,
    normalize_vc_names boolean DEFAULT true,
    normalize_part_descriptions boolean DEFAULT true,
    assemblynumber text,
    show_weight boolean DEFAULT false NOT NULL,
    transfer_default boolean DEFAULT true,
    transfer_default_use_master_default_bin boolean DEFAULT false,
    transfer_default_ignore_onhand boolean DEFAULT false,
    warehouse_id_ignore_onhand integer,
    bin_id_ignore_onhand integer,
    balance_startdate_method text,
    currency_id integer NOT NULL,
    signature text,
    customer_hourly_rate numeric(8,2),
    requirement_spec_section_order_part_id integer,
    transfer_default_services boolean DEFAULT true,
    delivery_plan_show_value_of_goods boolean DEFAULT false NOT NULL,
    delivery_plan_calculate_transferred_do boolean DEFAULT false NOT NULL,
    global_bcc text DEFAULT ''::text,
    customer_projects_only_in_sales boolean DEFAULT false NOT NULL,
    reqdate_interval integer DEFAULT 0,
    require_transaction_description_ps boolean DEFAULT false NOT NULL,
    sales_purchase_order_ship_missing_column boolean DEFAULT false,
    allow_sales_invoice_from_sales_quotation boolean DEFAULT true NOT NULL,
    allow_sales_invoice_from_sales_order boolean DEFAULT true NOT NULL,
    allow_new_purchase_delivery_order boolean DEFAULT true NOT NULL,
    allow_new_purchase_invoice boolean DEFAULT true NOT NULL,
    disabled_price_sources text[],
    transport_cost_reminder_article_number_id integer,
    is_transfer_out boolean DEFAULT false NOT NULL,
    letternumber integer
);


ALTER TABLE public.defaults OWNER TO postgres;

--
-- Name: defaults_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE defaults_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.defaults_id_seq OWNER TO postgres;

--
-- Name: defaults_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE defaults_id_seq OWNED BY defaults.id;


--
-- Name: delivery_order_items_id; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE delivery_order_items_id
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.delivery_order_items_id OWNER TO postgres;

--
-- Name: delivery_order_items; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE delivery_order_items (
    id integer DEFAULT nextval('"
LINE 1: '::text,
        ^

sisqonrw
Benutzer
Beiträge: 30
Registriert: So 31. Okt 2010, 15:22

Re: Wiederherstellung Sicherung Fehlermeldung

Beitrag von sisqonrw » Mi 10. Jan 2018, 14:43

per pgAdmin

kommen diese Meldungen bei der Wiederherstellung

Code: Alles auswählen

Ein Fehler ist aufgetreten:

14:37:59: Fehler: File '' couldn't be removed (Fehler 2: Datei oder Verzeichnis nicht gefunden)
https://paste.ubuntu.com/26360172/

Antworten