UDD postgresql dump
Dear Debian QA,
I've downloaded the dump of UDD from [1] and I'm trying to restore is on
postgresql-9.1, however I get tons of errors (see below). Is there
anything special I need to do with my postgres to restore that dump? Or
maybe some specific version is required? I'm not a DD, only a DM, so I
assume I do not have access to run custom queries about the UDD you have
up & running?
[1] http://udd.debian.org/udd.sql.gz
Thanks for any help,
Tomasz (Tomek) Muras
% psql udd -f udd.sql
CREATE EXTENSION
psql:udd.sql:29: ERROR: must be owner of extension plpgsql
psql:udd.sql:36: ERROR: could not open extension control file
"/usr/share/postgresql/9.1/extension/debversion.control": No such file
or directory
psql:udd.sql:43: ERROR: extension "debversion" does not exist
SET
CREATE TYPE
CREATE TYPE
psql:udd.sql:87: ERROR: type "lintian_tagtype" already exists
CREATE FUNCTION
psql:udd.sql:512: ERROR: type "debversion" does not exist
CREATE VIEW
psql:udd.sql:819: ERROR: type "debversion" does not exist
LINE 3: version debversion NOT NULL,
^
psql:udd.sql:827: ERROR: relation "packages" does not exist
LINE 2: ...bution, packages.release, packages.component FROM packages U...
^
CREATE VIEW
psql:udd.sql:909: ERROR: type "debversion" does not exist
LINE 3: version debversion NOT NULL,
^
psql:udd.sql:947: ERROR: type "debversion" does not exist
LINE 3: version debversion NOT NULL,
^
psql:udd.sql:985: ERROR: type "debversion" does not exist
LINE 3: version debversion NOT NULL,
^
psql:udd.sql:993: ERROR: relation "sources" does not exist
LINE 2: ...iginal_maintainer, sources.dm_upload_allowed FROM sources UN...
^
CREATE VIEW
psql:udd.sql:1098: ERROR: type "debversion" does not exist
LINE 4: testing_version debversion,
^
CREATE TABLE
psql:udd.sql:1133: ERROR: relation "sources" does not exist
LINE 2: ...s1.original_maintainer, s1.dm_upload_allowed FROM sources s1...
^
psql:udd.sql:1158: ERROR: type "debversion" does not exist
LINE 3: version debversion NOT NULL,
^
psql:udd.sql:1166: ERROR: relation "upload_history" does not exist
LINE 2: SELECT uh1.source, count(*) AS nmus FROM upload_history ...
^
psql:udd.sql:1174: ERROR: relation "sources_uniq" does not exist
LINE 2: ...modified)::date) AS last_modified_age FROM (((((((sources_un...
^
CREATE TABLE
psql:udd.sql:1221: ERROR: type "debversion" does not exist
LINE 27: chlog_version debversion
^
CREATE TABLE
psql:udd.sql:1290: ERROR: relation "sources" does not exist
LINE 2: ...))) AND (bugs.id IN (SELECT bugs_packages.id FROM sources, b...
^
psql:udd.sql:1298: ERROR: relation "sources" does not exist
LINE 2: ...))) AND (bugs.id IN (SELECT bugs_packages.id FROM sources, b...
^
psql:udd.sql:1306: ERROR: relation "sources" does not exist
LINE 2: ...))) AND (bugs.id IN (SELECT bugs_packages.id FROM sources, b...
^
psql:udd.sql:1314: ERROR: relation "sources" does not exist
LINE 2: ...))) AND (bugs.id IN (SELECT bugs_packages.id FROM sources, b...
^
psql:udd.sql:1322: ERROR: relation "sources" does not exist
LINE 2: ...))) AND (bugs.id IN (SELECT bugs_packages.id FROM sources, b...
^
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
psql:udd.sql:1385: ERROR: type "debversion" does not exist
LINE 3: version debversion NOT NULL,
^
psql:udd.sql:1396: ERROR: type "debversion" does not exist
LINE 3: version debversion NOT NULL,
^
psql:udd.sql:1407: ERROR: type "debversion" does not exist
LINE 3: version debversion NOT NULL,
^
psql:udd.sql:1418: ERROR: type "debversion" does not exist
LINE 3: version debversion NOT NULL,
^
psql:udd.sql:1437: ERROR: type "debversion" does not exist
LINE 3: unstable_version debversion,
^
CREATE TABLE
psql:udd.sql:1471: ERROR: type "debversion" does not exist
LINE 3: version debversion NOT NULL,
^
psql:udd.sql:1487: ERROR: type "debversion" does not exist
LINE 3: version debversion,
^
CREATE TABLE
CREATE TABLE
psql:udd.sql:1533: ERROR: type "debversion" does not exist
LINE 3: version debversion,
^
psql:udd.sql:1548: ERROR: type "debversion" does not exist
LINE 5: package_version debversion,
^
CREATE TABLE
CREATE VIEW
CREATE TABLE
CREATE VIEW
psql:udd.sql:1636: ERROR: type "debversion" does not exist
LINE 4: version debversion NOT NULL,
^
CREATE TABLE
psql:udd.sql:1668: ERROR: type "debversion" does not exist
LINE 3: version debversion NOT NULL,
^
CREATE TABLE
psql:udd.sql:1715: ERROR: relation "hints" does not exist
LINE 2: ...e, hints.argument, hints.file, hints.comment FROM hints WHER...
^
CREATE TABLE
CREATE VIEW
psql:udd.sql:1749: ERROR: relation "sources" does not exist
LINE 2: ...s1.original_maintainer, s1.dm_upload_allowed FROM sources s1...
LINE 5: package_version debversion,
^
psql:udd.sql:1931: ERROR: type "debversion" does not exist
LINE 3: version debversion NOT NULL,
^
CREATE VIEW
psql:udd.sql:2010: ERROR: type "debversion" does not exist
LINE 3: version debversion NOT NULL,
^
psql:udd.sql:2022: ERROR: type "debversion" does not exist
^
ALTER TABLE
SET
SET
psql:udd.sql:2735456: ERROR: relation "blends_prospectivepackages" does
not exist
psql:udd.sql:2735457: invalid command \n
psql:udd.sql:2735458: invalid command \n
...
Reply to: