Bug#389930: marked as done (warnings during upgrade from 8.1 to 8.2)

Sat, 07 Oct 2006 05:50:09 -0700 

Your message dated Sat, 07 Oct 2006 05:17:14 -0700
with message-id <[EMAIL PROTECTED]>
and subject line Bug#389930: fixed in postgresql-common 65
has caused the attached Bug report to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message --- 
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
--

--- End Message ---
--- Begin Message --- 
Source: postgresql-common
Source-Version: 65

We believe that the bug you reported is fixed in the latest version of
postgresql-common, which is due to be installed in the Debian FTP archive:

postgresql-client-common_65_all.deb
  to pool/main/p/postgresql-common/postgresql-client-common_65_all.deb
postgresql-common_65.dsc
  to pool/main/p/postgresql-common/postgresql-common_65.dsc
postgresql-common_65.tar.gz
  to pool/main/p/postgresql-common/postgresql-common_65.tar.gz
postgresql-common_65_all.deb
  to pool/main/p/postgresql-common/postgresql-common_65_all.deb



A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Martin Pitt <[EMAIL PROTECTED]> (supplier of updated postgresql-common package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [EMAIL PROTECTED])


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.7
Date: Sat,  7 Oct 2006 13:54:34 +0200
Source: postgresql-common
Binary: postgresql-client-common postgresql-common
Architecture: source all
Version: 65
Distribution: unstable
Urgency: low
Maintainer: Martin Pitt <[EMAIL PROTECTED]>
Changed-By: Martin Pitt <[EMAIL PROTECTED]>
Description: 
 postgresql-client-common - manager for multiple PostgreSQL client versions
 postgresql-common - manager for PostgreSQL database clusters
Closes: 389930
Changes: 
 postgresql-common (65) unstable; urgency=low
 .
   * pg_upgradecluster: Quiesce dropdb for already existing 'postgres'
     database.
   * pg_upgradecluster: Avoid harmless, but confusing error messages about role
     creation:
     - Do not use -c for pg_dumpall, since the target roles should not yet
       exist anyway.
     - Filter out the 'CREATE (ROLE|USER)' command for the db superuser, since
       it will already exist.
     - Testsuite: Check that pg_upgradecluster output contains no server error
       messages.
     - Closes: #389930
Files: 
 c9190fc5c8f4d43b4d36230735292e60 604 misc optional postgresql-common_65.dsc
 cd98cc5cc2b53db9c0531c70be448578 90293 misc optional 
postgresql-common_65.tar.gz
 153e25a6791d38be48b7f3e8cdd82956 96080 misc optional 
postgresql-common_65_all.deb
 727d63d88e16f71072ed780e092df9d1 38854 misc optional 
postgresql-client-common_65_all.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFJ5j7DecnbV4Fd/IRAsbYAKCysOvqhLzTGKCs2HdjeXXbU0oyYwCdHNMQ
IDHaxgzVaoscCmgE+ylS0Yo=
=7cdM
-----END PGP SIGNATURE-----

--- End Message ---

Reply via email to