Problem with dump importing.

From: NetLevel Admins <admins(at)netlevel(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with dump importing.
Date: 2009-12-15 16:34:09
Message-ID: d7f564e0912150834y4ccb7815v89b2f8a4eb04824e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I created database dump on server version 8.3.7 and trying to import it to
server v. 8.1.18, but i see errors.

CREATE DOMAIN
> dump.sql:20: ERROR: role "userarm" does not exist
> dump.sql:26: ERROR: type "pg_catalog.gtsvector" does not exist
> dump.sql:29: ERROR: role "userarm" does not exist
> CREATE TYPE
> dump.sql:42: ERROR: role "userarm" does not exist
> CREATE TYPE
> dump.sql:54: ERROR: role "userarm" does not exist
> CREATE TYPE
> dump.sql:67: ERROR: role "userarm" does not exist
> dump.sql:80: ERROR: type "pg_catalog.tsvector" does not exist
> dump.sql:83: ERROR: role "userarm" does not exist
> dump.sql:89: ERROR: type "pg_catalog.tsquery" does not exist
> dump.sql:92: ERROR: role "userarm" does not exist
> dump.sql:98: ERROR: type "pg_catalog.tsvector" does not exist
> dump.sql:101: ERROR: role "userarm" does not exist
> CREATE DOMAIN
> dump.sql:110: ERROR: role "userarm" does not exist
> CREATE FUNCTION
> dump.sql:121: ERROR: role "userarm" does not exist
> CREATE FUNCTION
> dump.sql:132: ERROR: role "userarm" does not exist
> CREATE FUNCTION
> dump.sql:143: ERROR: role "userarm" does not exist
> CREATE FUNCTION
> dump.sql:154: ERROR: role "userarm" does not exist
> CREATE FUNCTION
> dump.sql:165: ERROR: role "userarm" does not exist
> CREATE FUNCTION
> dump.sql:176: ERROR: role "userarm" does not exist
> CREATE FUNCTION
> dump.sql:187: ERROR: role "userarm" does not exist
> dump.sql:213: ERROR: type "tsdebug" does not exist
> dump.sql:216: ERROR: role "userarm" does not exist
> CREATE OPERATOR
> dump.sql:233: ERROR: role "userarm" does not exist
> CREATE OPERATOR
> dump.sql:250: ERROR: role "userarm" does not exist
> CREATE OPERATOR
> dump.sql:267: ERROR: role "userarm" does not exist
> CREATE OPERATOR
> dump.sql:286: ERROR: role "userarm" does not exist
> CREATE OPERATOR
> dump.sql:303: ERROR: role "userarm" does not exist
> CREATE OPERATOR
> dump.sql:320: ERROR: role "userarm" does not exist
> SET
> SET
> CREATE TABLE
> dump.sql:339: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:356: ERROR: role "userarm" does not exist
> SET
> CREATE TABLE
> dump.sql:377: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:390: ERROR: role "userarm" does not exist
> setval
> 126
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:415: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:428: ERROR: role "userarm" does not exist
> setval
> 23
>
>
> 1 запис(ь/и/ей) CREATE TABLE
> dump.sql:451: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:466: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:485: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:521: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:534: ERROR: role "userarm" does not exist
> setval
> 168
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:575: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:588: ERROR: role "userarm" does not exist
> setval
> 308
>
>
> 1 запис(ь/и/ей) CREATE TABLE
> dump.sql:618: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:639: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:653: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:666: ERROR: role "userarm" does not exist
> setval
> 53
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:691: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:705: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:721: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:735: ERROR: role "userarm" does not exist
> setval
> 1
>
>
> 1 запис(ь/и/ей) CREATE TABLE
> dump.sql:754: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:767: ERROR: role "userarm" does not exist
> setval
> 29
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:795: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:808: ERROR: role "userarm" does not exist
> setval
> 9
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:838: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:851: ERROR: role "userarm" does not exist
> setval
> 66
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:872: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:885: ERROR: role "userarm" does not exist
> setval
> 52
>
>
> 1 запис(ь/и/ей) dump.sql:971: ERROR: unterminated quoted string at or near
> "'
> adp_always smallint DEFAULT 1 NOT NULL,
>
> adp_days integer DEFAULT 1 NOT NULL,
>
> adp_hours integer DEFAULT 0 NOT NULL,
>
> adp_mins integer DEFAULT 0 NOT NULL,
>
> adp_secs integer DEFAULT 0 NOT NULL,
>
> CONSTRAINT phpbb_forums_display_on_index_check CHECK ((display_on_index >=
> 0)),
>
> CONSTRAINT phpbb_forums_display_subforum_list_check CHECK
> ((display_subforum_list >= 0)),
>
> CONSTRAINT phpbb_forums_enable_icons_check CHECK ((enable_icons >= 0)),
>
> CONSTRAINT phpbb_forums_enable_indexing_check CHECK ((enable_indexing >=
> 0)),
>
> CONSTRAINT phpbb_forums_enable_prune_check CHECK ((enable_prune >= 0)),
>
> CONSTRAINT phpbb_forums_forum_desc_options_check CHECK ((forum_desc_options
> >= 0)),
>
> CONSTRAINT phpbb_forums_forum_last_post_id_check CHECK ((forum_last_post_id
> >= 0)),
>
> CONSTRAINT phpbb_forums_forum_last_post_time_check CHECK
> ((forum_last_post_time >= 0)),
>
> CONSTRAINT phpbb_forums_forum_last_poster_id_check CHECK
> ((forum_last_poster_id >= 0)),
>
> CONSTRAINT phpbb_forums_forum_posts_check CHECK ((forum_posts >= 0)),
>
> CONSTRAINT phpbb_forums_forum_rules_options_check CHECK
> ((forum_rules_options >= 0)),
>
> CONSTRAINT phpbb_forums_forum_style_check CHECK ((forum_style >= 0)),
>
> CONSTRAINT phpbb_forums_forum_topics_check CHECK ((forum_topics >= 0)),
>
> CONSTRAINT phpbb_forums_forum_topics_real_check CHECK ((forum_topics_real
> >= 0)),
>
> CONSTRAINT phpbb_forums_left_id_check CHECK ((left_id >= 0)),
>
> CONSTRAINT phpbb_forums_parent_id_check CHECK ((parent_id >= 0)),
>
> CONSTRAINT phpbb_forums_prune_days_check CHECK ((prune_days >= 0)),
>
> CONSTRAINT phpbb_forums_prune_freq_check CHECK ((prune_freq >= 0)),
>
> CONSTRAINT phpbb_forums_prune_next_check CHECK ((prune_next >= 0)),
>
> CONSTRAINT phpbb_forums_prune_viewed_check CHECK ((prune_viewed >= 0)),
>
> CONSTRAINT phpbb_forums_right_id_check CHECK ((right_id >= 0))
>
> );" at character 2885
> dump.sql:974: ERROR: relation "public.phpbb_forums" does not exist
> CREATE TABLE
> dump.sql:989: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:1005: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:1021: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1034: ERROR: role "userarm" does not exist
> setval
> 18
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:1082: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1095: ERROR: role "userarm" does not exist
> setval
> 10
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:1120: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1133: ERROR: role "userarm" does not exist
> setval
> 4
>
>
> 1 запис(ь/и/ей) CREATE TABLE
> dump.sql:1156: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1169: ERROR: role "userarm" does not exist
> setval
> 13694
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:1201: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1214: ERROR: role "userarm" does not exist
> setval
> 9
>
>
> 1 запис(ь/и/ей) CREATE TABLE
> dump.sql:1242: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1255: ERROR: role "userarm" does not exist
> setval
> 72
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:1284: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1297: ERROR: role "userarm" does not exist
> setval
> 3
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:1317: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:1337: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1350: ERROR: role "userarm" does not exist
> setval
> 198
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:1383: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:1399: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:1415: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1428: ERROR: role "userarm" does not exist
> setval
> 48215
>
>
> 1 запис(ь/и/ей) CREATE TABLE
> dump.sql:1488: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1501: ERROR: role "userarm" does not exist
> setval
> 6464
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:1551: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1564: ERROR: role "userarm" does not exist
> setval
> 1
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:1587: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1600: ERROR: role "userarm" does not exist
> setval
> 3
>
>
> 1 запис(ь/и/ей) CREATE TABLE
> dump.sql:1632: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:1661: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1675: ERROR: role "userarm" does not exist
> setval
> 1
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:1716: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:1728: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:1746: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:1763: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1776: ERROR: role "userarm" does not exist
> setval
> 23
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:1800: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1813: ERROR: role "userarm" does not exist
> setval
> 226
>
>
> 1 запис(ь/и/ей) CREATE TABLE
> dump.sql:1844: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1857: ERROR: role "userarm" does not exist
> setval
> 6
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:1879: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1892: ERROR: role "userarm" does not exist
> setval
> 12192
>
>
> 1 запис(ь/и/ей) CREATE TABLE
> dump.sql:1917: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:1932: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:1945: ERROR: role "userarm" does not exist
> setval
> 112345
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:1968: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:1984: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:2015: ERROR: role "userarm" does not exist
> CREATE TABLE
> dump.sql:2031: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:2045: ERROR: role "userarm" does not exist
> setval
> 1
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:2067: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:2080: ERROR: role "userarm" does not exist
> setval
> 94
>
>
> 1 запис(ь/и/ей) CREATE TABLE
> dump.sql:2109: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:2122: ERROR: role "userarm" does not exist
> setval
> 12
>
>
> 1 запис(ь/и/ей)
>
> CREATE TABLE
> dump.sql:2150: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:2163: ERROR: role "userarm" does not exist
> setval
> 7
>
>
> 1 запис(ь/и/ей) CREATE TABLE
> dump.sql:2184: ERROR: role "userarm" does not exist
> CREATE SEQUENCE
> dump.sql:2197: ERROR: role "userarm" does not exist
> setval
> 591
>
>
> 1 запис(ь/и/ей)

What could be a problem and is there a solution?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Mead 2009-12-15 17:00:49 Re: Problem with dump importing.
Previous Message Greg Smith 2009-12-15 16:13:16 Re: Interesting Benchmark Article