Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6ED339F9F46 for ; Fri, 15 Dec 2006 08:34:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 32973-08 for ; Fri, 15 Dec 2006 08:34:32 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.233]) by postgresql.org (Postfix) with ESMTP id 3D1129FA334 for ; Fri, 15 Dec 2006 08:34:37 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so400746nzh for ; Fri, 15 Dec 2006 04:34:36 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=hK3fVtIFKJ6wknko5r72tSYryGkHNvdiBbCpFXCS6iaYF10s2uFM9hm6aL4q1LROkAyJawshZxRa5jVRZrvZhWKdLv9bZs+QDA73KRzHXU1kSlj6QihWgpEXqvuJgWzt9m9UYZb6SBowCcpKD60yrvPoLFqtA5BYOyc9Tu8uZUM= Received: by 10.65.236.18 with SMTP id n18mr1109980qbr.1166186075835; Fri, 15 Dec 2006 04:34:35 -0800 (PST) Received: by 10.65.206.17 with HTTP; Fri, 15 Dec 2006 04:34:35 -0800 (PST) Message-ID: Date: Fri, 15 Dec 2006 17:34:35 +0500 From: "Shoaib Mir" To: "Sandy Spence" Subject: Re: invalid types and tables Cc: pgsql-admin@postgresql.org In-Reply-To: <000c01c7203f$e92ac030$520b3cc1@pc2axs> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_117845_13827686.1166186075787" References: <000c01c7203f$e92ac030$520b3cc1@pc2axs> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/216 X-Sequence-Number: 24008 ------=_Part_117845_13827686.1166186075787 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline It appears to me you dropped the user that was owner of the database objects been warned during dump activity. I guess dropping user was possible in you case as you are using an older release but you cant do the same in 8.1 and onwards. I will recommend recreating the user that was dropped to get around this problem... --------------------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 12/15/06, Sandy Spence wrote: > > 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > ------=_Part_117845_13827686.1166186075787 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline It appears to me you dropped the user that was owner of the database objects been warned during dump activity. I guess dropping user was possible in you case as you are using an older release but you cant do the same in 8.1 and onwards.

I will recommend recreating the user that was dropped to get around this problem...

---------------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com )

On 12/15/06, Sandy Spence <axs@aber.ac.uk> wrote:
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



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

------=_Part_117845_13827686.1166186075787--