pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shoaib Mir <shoaibmir@gmail.com>
To: Sandy Spence <axs@aber.ac.uk>
Cc: pgsql-admin@postgresql.org
Subject: Re: invalid types and tables
Date: Fri, 15 Dec 2006 17:34:35 +0500
Message-ID: <bf54be870612150434x21f3650dnf3186001d6d00d08@mail.gmail.com> (raw)
In-Reply-To: <000c01c7203f$e92ac030$520b3cc1@pc2axs>
References: <000c01c7203f$e92ac030$520b3cc1@pc2axs>

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
>

view thread (12+ messages)  latest in thread

Message-ID: <bf54be870612150434x21f3650dnf3186001d6d00d08@mail.gmail.com>
Permalink:  ../bf54be870612150434x21f3650dnf3186001d6d00d08@mail.gmail.com/
Also on:    postgresql.org/message-id/bf54be870612150434x21f3650dnf3186001d6d00d08@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: shoaibmir@gmail.com, axs@aber.ac.uk
  Subject: Re: invalid types and tables
  In-Reply-To: <bf54be870612150434x21f3650dnf3186001d6d00d08@mail.gmail.com>
  References: <000c01c7203f$e92ac030$520b3cc1@pc2axs> <bf54be870612150434x21f3650dnf3186001d6d00d08@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox