Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 179889FA0FB for ; Fri, 15 Dec 2006 08:25:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 91847-02 for ; Fri, 15 Dec 2006 08:25:28 -0400 (AST) X-Greylist: delayed 00:28:48.992414 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id D44099FA433 for ; Fri, 15 Dec 2006 08:25:28 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from cefni.aber.ac.uk (cefni.aber.ac.uk [144.124.16.40]) by svr4.postgresql.org (Postfix) with ESMTP id C64415AF043 for ; Fri, 15 Dec 2006 11:56:38 +0000 (GMT) Received: from localhost ([127.0.0.1] helo=cefni.aber.ac.uk) by cefni.aber.ac.uk with esmtp (Exim 4.54) id 1GvBfz-0005CT-6Y for pgsql-admin@postgresql.org; Fri, 15 Dec 2006 11:56:31 +0000 Received: from pc2axs.dcs.aber.ac.uk ([193.60.11.82] helo=pc2axs) by cefni.aber.ac.uk with esmtp (Exim 4.54) id 1GvBew-000536-9Y for pgsql-admin@postgresql.org; Fri, 15 Dec 2006 11:55:26 +0000 From: "Sandy Spence" To: Subject: invalid types and tables Date: Fri, 15 Dec 2006 11:55:26 -0000 Message-ID: <000c01c7203f$e92ac030$520b3cc1@pc2axs> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Thread-Index: AccgP+kLASv8pcwHREiNHCHWhVkgHw== X-Sophos-Scanned: from axs@aber.ac.uk virus scanned OK X-UWA-Mid: 1GvBew-000536-9Y X-UWA-Originating-IP: 193.60.11.82 X-UWA-Bounce-Filter: 8B4gAOMXYx X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.07 tagged_above=0 required=5 tests=BAYES_50, SPF_NEUTRAL X-Spam-Level: * X-Archive-Number: 200612/214 X-Sequence-Number: 24006 Hi all admins, Even though I am new to postgres I have been given the job of administrator, in at the deep end you might say. We have a cron job that runs nightly to back up all of our users databases, the output from the cron job shows the following WARNINGs pg_dump: WARNING: owner of data type pga_queries appears to be invalid pg_dump: WARNING: owner of data type pg_toast_557151 appears to be invalid pg_dump: WARNING: owner of data type pga_forms appears to be invalid pg_dump: WARNING: owner of data type pg_toast_557156 appears to be invalid pg_dump: WARNING: owner of data type pga_scripts appears to be invalid pg_dump: WARNING: owner of data type pg_toast_557161 appears to be invalid pg_dump: WARNING: owner of data type pga_reports appears to be invalid pg_dump: WARNING: owner of data type pg_toast_557166 appears to be invalid pg_dump: WARNING: owner of data type pga_schema appears to be invalid pg_dump: WARNING: owner of data type pg_toast_557171 appears to be invalid pg_dump: WARNING: owner of data type pga_layout appears to be invalid pg_dump: WARNING: owner of data type pg_toast_557176 appears to be invalid pg_dump: WARNING: owner of data type adult_results appears to be invalid pg_dump: WARNING: owner of data type pg_toast_557181 appears to be invalid pg_dump: WARNING: owner of data type child_results appears to be invalid pg_dump: WARNING: owner of data type pg_toast_557186 appears to be invalid pg_dump: WARNING: owner of table "pga_queries" appears to be invalid pg_dump: WARNING: owner of table "pga_forms" appears to be invalid pg_dump: WARNING: owner of table "pga_scripts" appears to be invalid pg_dump: WARNING: owner of table "pga_reports" appears to be invalid pg_dump: WARNING: owner of table "pga_schema" appears to be invalid pg_dump: WARNING: owner of table "pga_layout" appears to be invalid pg_dump: WARNING: owner of table "adult_results" appears to be invalid pg_dump: WARNING: owner of table "child_results" appears to be invalid pg_dump: WARNING: owner of data type trigger appears to be invalid My two questions are: 1: How do I find out which owner is being referenced, when I look at a number of user accounts (databases) they all appear to have pga_forms, pga_reposts etc. 2: How do I display a list of the above mentioned types? We are running version 7.2.3 (upgrading in the new year) Thanks in advance for any assistance, Regards, Sandy Spence Computer Officer, RA Certification Manager Department of Computer Science - UWA Llandinam Building Penglais Campus Aberystwyth Ceredigion Wales - UK SY23 3DB Tel: (01970)-622433 Fax: (01970)-628536