Bug#389930: warnings during upgrade from 8.1 to 8.2

[Steinar H. Gunderson]

Package: postgresql-common
Version: 63
Severity: normal

As discussed on IRC, my upgrade from 8.1 to 8.2 gave warnings:

  14:52 <Sesse> Creating globals...
  14:52 <Sesse> ERROR:  role "debbugs" does not exist
  14:52 <Sesse> ERROR:  current user cannot be dropped
  14:52 <Sesse> ERROR:  role "postgres" already exists
  14:52 <Sesse> ERROR:  role "pr0n" does not exist
  14:52 <Sesse> ERROR:  role "sesse" does not exist

However, after that it seems to have worked fine, so I guess the
warnings were harmless. I'm attaching pg_dumpall --schema-only from the
8.1 installation.

-- System Information:
Debian Release: testing/unstable
  APT prefers testing
  APT policy: (900, 'testing'), (500, 'unstable'), (500, 'stable'), (1, 
'experimental')
Architecture: i386 (x86_64)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-rc7
Locale: LANG=en_DK.UTF-8, LC_CTYPE=en_DK.UTF-8 (charmap=UTF-8)

Versions of packages postgresql-common depends on:
ii  adduser                       3.97       Add and remove users and groups
ii  debconf [debconf-2.0]         1.5.4      Debian configuration management sy
ii  lsb-base                      3.1-15     Linux Standard Base 3.1 init scrip
ii  postgresql-client-common      63         manager for multiple PostgreSQL cl
ii  procps                        1:3.2.7-3  /proc file system utilities
ii  ssl-cert                      1.0.13     Simple debconf wrapper for openssl

postgresql-common recommends no packages.

-- debconf information:
  postgresql-common/obsolete-major:
  postgresql-common/untransitioned:

--
-- PostgreSQL database cluster dump
--

\connect postgres

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET escape_string_warning = 'off';

--
-- Roles
--

CREATE ROLE debbugs;
ALTER ROLE debbugs WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN PASSWORD 'md5b208a9b0ec607c5d091d006fb3a1fd1c';
CREATE ROLE postgres;
ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN;
CREATE ROLE pr0n;
ALTER ROLE pr0n WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN PASSWORD 'md50bcce74e9a43eda193048cc3a88525c1';
CREATE ROLE sesse;
ALTER ROLE sesse WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN;






--
-- Database creation
--

CREATE DATABASE debbugs WITH TEMPLATE = template0 OWNER = sesse ENCODING = 'UTF8';
CREATE DATABASE pr0n WITH TEMPLATE = template0 OWNER = sesse ENCODING = 'UTF8';
REVOKE ALL ON DATABASE template1 FROM PUBLIC;
REVOKE ALL ON DATABASE template1 FROM postgres;
GRANT CREATE,TEMPORARY ON DATABASE template1 TO postgres;


\connect debbugs

--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


SET search_path = public, pg_catalog;

--
-- Name: array_accum(anyelement); Type: AGGREGATE; Schema: public; Owner: sesse
--

CREATE AGGREGATE array_accum(anyelement) (
    SFUNC = array_append,
    STYPE = anyarray,
    INITCOND = '{}'
);


ALTER AGGREGATE public.array_accum(anyelement) OWNER TO sesse;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: maintainers; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE maintainers (
    package character varying NOT NULL,
    maintainer character varying NOT NULL
);


ALTER TABLE public.maintainers OWNER TO sesse;

--
-- Name: srcbin; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE srcbin (
    srcpkg character varying NOT NULL,
    binpkg character varying NOT NULL,
    section character varying NOT NULL
);


ALTER TABLE public.srcbin OWNER TO sesse;

--
-- Name: status; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE status (
    bug integer NOT NULL,
    subject character varying NOT NULL,
    submitted timestamp without time zone NOT NULL,
    whendone character varying NOT NULL,
    originator character varying NOT NULL,
    done character varying,
    "owner" character varying,
    forwarded character varying,
    severity character varying NOT NULL,
    found_versions character varying[],
    fixed_versions character varying[],
    mergedwith integer[],
    blockedby integer[],
    blocks integer[],
    CONSTRAINT status_severity_check CHECK (((((((((severity)::text = 'critical'::text) OR ((severity)::text = 'serious'::text)) OR ((severity)::text = 'grave'::text)) OR ((severity)::text = 'important'::text)) OR ((severity)::text = 'normal'::text)) OR ((severity)::text = 'minor'::text)) OR ((severity)::text = 'wishlist'::text))),
    CONSTRAINT status_whendone_check CHECK (((((whendone)::text = 'open'::text) OR ((whendone)::text = 'forwarded'::text)) OR ((whendone)::text = 'done'::text)))
);


ALTER TABLE public.status OWNER TO sesse;

--
-- Name: status_keywords; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE status_keywords (
    bug integer NOT NULL,
    keyword character varying NOT NULL
);


ALTER TABLE public.status_keywords OWNER TO sesse;

--
-- Name: status_packages; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE status_packages (
    bug integer NOT NULL,
    package character varying NOT NULL
);


ALTER TABLE public.status_packages OWNER TO sesse;

--
-- Name: status_submitters; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE status_submitters (
    bug integer NOT NULL,
    submitter character varying NOT NULL
);


ALTER TABLE public.status_submitters OWNER TO sesse;

--
-- Name: version_srcbin; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE version_srcbin (
    binpkg character varying NOT NULL,
    binversion character varying NOT NULL,
    arch character varying NOT NULL,
    srcpkg character varying NOT NULL,
    srcversion character varying NOT NULL
);


ALTER TABLE public.version_srcbin OWNER TO sesse;

--
-- Name: versions; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE versions (
    pkg character varying NOT NULL,
    dist character varying NOT NULL,
    arch character varying NOT NULL,
    version character varying NOT NULL
);


ALTER TABLE public.versions OWNER TO sesse;

--
-- Name: maintainers_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace: 
--

ALTER TABLE ONLY maintainers
    ADD CONSTRAINT maintainers_pkey PRIMARY KEY (package);


--
-- Name: srcbin_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace: 
--

ALTER TABLE ONLY srcbin
    ADD CONSTRAINT srcbin_pkey PRIMARY KEY (srcpkg, binpkg);


--
-- Name: status_keywords_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace: 
--

ALTER TABLE ONLY status_keywords
    ADD CONSTRAINT status_keywords_pkey PRIMARY KEY (bug, keyword);


--
-- Name: status_packages_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace: 
--

ALTER TABLE ONLY status_packages
    ADD CONSTRAINT status_packages_pkey PRIMARY KEY (bug, package);


--
-- Name: status_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace: 
--

ALTER TABLE ONLY status
    ADD CONSTRAINT status_pkey PRIMARY KEY (bug);


--
-- Name: version_srcbin_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace: 
--

ALTER TABLE ONLY version_srcbin
    ADD CONSTRAINT version_srcbin_pkey PRIMARY KEY (binpkg, binversion, arch);


--
-- Name: versions_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace: 
--

ALTER TABLE ONLY versions
    ADD CONSTRAINT versions_pkey PRIMARY KEY (pkg, dist, arch);


--
-- Name: srcbin_binpkg; Type: INDEX; Schema: public; Owner: sesse; Tablespace: 
--

CREATE INDEX srcbin_binpkg ON srcbin USING btree (binpkg);


--
-- Name: status_keywords_keyword; Type: INDEX; Schema: public; Owner: sesse; Tablespace: 
--

CREATE INDEX status_keywords_keyword ON status_keywords USING btree (keyword);


--
-- Name: status_packages_package; Type: INDEX; Schema: public; Owner: sesse; Tablespace: 
--

CREATE INDEX status_packages_package ON status_packages USING btree (package);


--
-- Name: status_severity; Type: INDEX; Schema: public; Owner: sesse; Tablespace: 
--

CREATE INDEX status_severity ON status USING btree (severity);


--
-- Name: status_submitters_submitter; Type: INDEX; Schema: public; Owner: sesse; Tablespace: 
--

CREATE INDEX status_submitters_submitter ON status_submitters USING btree (submitter);


--
-- Name: status_whendone; Type: INDEX; Schema: public; Owner: sesse; Tablespace: 
--

CREATE INDEX status_whendone ON status USING btree (whendone);


--
-- Name: version_srcbin_reverse; Type: INDEX; Schema: public; Owner: sesse; Tablespace: 
--

CREATE INDEX version_srcbin_reverse ON version_srcbin USING btree (srcpkg, srcversion);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- Name: maintainers; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE maintainers FROM PUBLIC;
REVOKE ALL ON TABLE maintainers FROM sesse;
GRANT ALL ON TABLE maintainers TO sesse;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE maintainers TO debbugs;


--
-- Name: srcbin; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE srcbin FROM PUBLIC;
REVOKE ALL ON TABLE srcbin FROM sesse;
GRANT ALL ON TABLE srcbin TO sesse;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE srcbin TO debbugs;


--
-- Name: status; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE status FROM PUBLIC;
REVOKE ALL ON TABLE status FROM sesse;
GRANT ALL ON TABLE status TO sesse;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE status TO debbugs;


--
-- Name: status_keywords; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE status_keywords FROM PUBLIC;
REVOKE ALL ON TABLE status_keywords FROM sesse;
GRANT ALL ON TABLE status_keywords TO sesse;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE status_keywords TO debbugs;


--
-- Name: status_packages; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE status_packages FROM PUBLIC;
REVOKE ALL ON TABLE status_packages FROM sesse;
GRANT ALL ON TABLE status_packages TO sesse;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE status_packages TO debbugs;


--
-- Name: status_submitters; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE status_submitters FROM PUBLIC;
REVOKE ALL ON TABLE status_submitters FROM sesse;
GRANT ALL ON TABLE status_submitters TO sesse;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE status_submitters TO debbugs;


--
-- Name: version_srcbin; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE version_srcbin FROM PUBLIC;
REVOKE ALL ON TABLE version_srcbin FROM sesse;
GRANT ALL ON TABLE version_srcbin TO sesse;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE version_srcbin TO debbugs;


--
-- Name: versions; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE versions FROM PUBLIC;
REVOKE ALL ON TABLE versions FROM sesse;
GRANT ALL ON TABLE versions TO sesse;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE versions TO debbugs;


--
-- PostgreSQL database dump complete
--

\connect postgres

--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--

\connect pr0n

--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = true;

--
-- Name: deleted_images; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE deleted_images (
    id integer NOT NULL,
    event character varying(32) NOT NULL,
    filename character varying(255) NOT NULL,
    width integer DEFAULT -1 NOT NULL,
    height integer DEFAULT -1 NOT NULL,
    uploadedby character varying(32),
    date timestamp without time zone,
    takenby character varying(32) NOT NULL,
    selected boolean
);


ALTER TABLE public.deleted_images OWNER TO sesse;

--
-- Name: events; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE events (
    id character varying NOT NULL,
    date character varying NOT NULL,
    name character varying NOT NULL,
    vhost character varying NOT NULL
);


ALTER TABLE public.events OWNER TO sesse;

--
-- Name: fake_files; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE fake_files (
    event character varying(32) NOT NULL,
    filename character varying(255) NOT NULL,
    expires_at timestamp without time zone NOT NULL
);


ALTER TABLE public.fake_files OWNER TO sesse;

--
-- Name: imageid_seq; Type: SEQUENCE; Schema: public; Owner: sesse
--

CREATE SEQUENCE imageid_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.imageid_seq OWNER TO sesse;

--
-- Name: images; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE images (
    id integer DEFAULT nextval(('imageid_seq'::text)::regclass) NOT NULL,
    event character varying NOT NULL,
    filename character varying NOT NULL,
    width integer DEFAULT -1 NOT NULL,
    height integer DEFAULT -1 NOT NULL,
    uploadedby character varying NOT NULL,
    date timestamp without time zone,
    takenby character varying NOT NULL,
    selected boolean DEFAULT false
);


ALTER TABLE public.images OWNER TO sesse;

SET default_with_oids = false;

--
-- Name: last_picture_cache; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE last_picture_cache (
    event character varying NOT NULL,
    last_picture timestamp without time zone
);


ALTER TABLE public.last_picture_cache OWNER TO sesse;

SET default_with_oids = true;

--
-- Name: shadow_files; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE shadow_files (
    event character varying(32) NOT NULL,
    filename character varying(255) NOT NULL,
    id integer NOT NULL,
    expires_at timestamp without time zone NOT NULL
);


ALTER TABLE public.shadow_files OWNER TO sesse;

--
-- Name: users; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE users (
    username character varying(32) NOT NULL,
    sha1password character(28) NOT NULL,
    vhost character varying(32) NOT NULL
);


ALTER TABLE public.users OWNER TO sesse;

--
-- Name: events_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace: 
--

ALTER TABLE ONLY events
    ADD CONSTRAINT events_pkey PRIMARY KEY (id);


--
-- Name: fake_files_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace: 
--

ALTER TABLE ONLY fake_files
    ADD CONSTRAINT fake_files_pkey PRIMARY KEY (event, filename);


--
-- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace: 
--

ALTER TABLE ONLY images
    ADD CONSTRAINT images_pkey PRIMARY KEY (id);


--
-- Name: last_picture_cache_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace: 
--

ALTER TABLE ONLY last_picture_cache
    ADD CONSTRAINT last_picture_cache_pkey PRIMARY KEY (event);


--
-- Name: unique_filenames; Type: INDEX; Schema: public; Owner: sesse; Tablespace: 
--

CREATE UNIQUE INDEX unique_filenames ON images USING btree (event, filename);


--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: sesse
--

ALTER TABLE ONLY fake_files
    ADD CONSTRAINT "$1" FOREIGN KEY (event) REFERENCES events(id);


--
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: sesse
--

ALTER TABLE ONLY images
    ADD CONSTRAINT "$1" FOREIGN KEY (event) REFERENCES events(id);


--
-- Name: last_picture_cache_event_fkey; Type: FK CONSTRAINT; Schema: public; Owner: sesse
--

ALTER TABLE ONLY last_picture_cache
    ADD CONSTRAINT last_picture_cache_event_fkey FOREIGN KEY (event) REFERENCES events(id);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- Name: deleted_images; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE deleted_images FROM PUBLIC;
REVOKE ALL ON TABLE deleted_images FROM sesse;
GRANT ALL ON TABLE deleted_images TO sesse;
GRANT INSERT ON TABLE deleted_images TO pr0n;


--
-- Name: events; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE events FROM PUBLIC;
REVOKE ALL ON TABLE events FROM sesse;
GRANT ALL ON TABLE events TO sesse;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE events TO pr0n;


--
-- Name: fake_files; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE fake_files FROM PUBLIC;
REVOKE ALL ON TABLE fake_files FROM sesse;
GRANT ALL ON TABLE fake_files TO sesse;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE fake_files TO pr0n;


--
-- Name: imageid_seq; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON SEQUENCE imageid_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE imageid_seq FROM sesse;
GRANT SELECT,UPDATE ON SEQUENCE imageid_seq TO sesse;
GRANT SELECT,UPDATE ON SEQUENCE imageid_seq TO pr0n;


--
-- Name: images; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE images FROM PUBLIC;
REVOKE ALL ON TABLE images FROM sesse;
GRANT ALL ON TABLE images TO sesse;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE images TO pr0n;


--
-- Name: last_picture_cache; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE last_picture_cache FROM PUBLIC;
REVOKE ALL ON TABLE last_picture_cache FROM sesse;
GRANT ALL ON TABLE last_picture_cache TO sesse;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE last_picture_cache TO pr0n;


--
-- Name: shadow_files; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE shadow_files FROM PUBLIC;
REVOKE ALL ON TABLE shadow_files FROM sesse;
GRANT ALL ON TABLE shadow_files TO sesse;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE shadow_files TO pr0n;


--
-- Name: users; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE users FROM PUBLIC;
REVOKE ALL ON TABLE users FROM sesse;
GRANT ALL ON TABLE users TO sesse;
GRANT SELECT ON TABLE users TO pr0n;


--
-- PostgreSQL database dump complete
--

\connect template1

--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- Name: DATABASE template1; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON DATABASE template1 IS 'Default template database';


--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--

--
-- PostgreSQL database cluster dump complete
--