Professional Web Applications Themes

vac db fail - PostgreSQL / PGSQL

Trying vacuumdb eventuallydisplays this: ERROR: catalog is missing 3 attribute(s) for relid 31457 vacuumdb: vacuum databasename failed There is another thread which states this is a corrupted systems catalog. Is this definitely the case? Does it mean I need to re-build the database? Re-install? Thanks. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? [url]http://archives.postgresql.org[/url]...

  1. #1

    Default vac db fail

    Trying vacuumdb eventuallydisplays this:


    ERROR: catalog is missing 3 attribute(s) for relid 31457
    vacuumdb: vacuum databasename failed

    There is another thread which states this is a corrupted systems
    catalog. Is this definitely the case? Does it mean I need to re-build
    the database? Re-install?

    Thanks.


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

    [url]http://archives.postgresql.org[/url]

    Matthew Terenzio Guest

  2. #2

    Default Re: vac db fail

    I honestly have no idea what that error means, however I'd imagine
    that you should be able to dump the DB, and reimport it as a last
    resort to fixing this.


    On Tue, 28 Dec 2004 18:33:24 -0500, Matthew Terenzio
    <webmasterlocalnotion.com> wrote:
    > Trying vacuumdb eventuallydisplays this:
    >
    > ERROR: catalog is missing 3 attribute(s) for relid 31457
    > vacuumdb: vacuum databasename failed
    >
    > There is another thread which states this is a corrupted systems
    > catalog. Is this definitely the case? Does it mean I need to re-build
    > the database? Re-install?
    >
    > Thanks.
    >
    > ---------------------------(end of broadcast)---------------------------
    > TIP 6: Have you searched our list archives?
    >
    > [url]http://archives.postgresql.org[/url]
    >

    --
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~
    L. Friedman [email]netllama[/email]
    LlamaLand [url]http://netllama.linux-sxs.org[/url]

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

    [url]http://archives.postgresql.org[/url]

    Lonni J Friedman Guest

  3. #3

    Default Re: vac db fail

    Matthew Terenzio <webmasterlocalnotion.com> writes:
    > Trying vacuumdb eventuallydisplays this:
    > ERROR: catalog is missing 3 attribute(s) for relid 31457
    > vacuumdb: vacuum databasename failed
    > There is another thread which states this is a corrupted systems
    > catalog. Is this definitely the case? Does it mean I need to re-build
    > the database? Re-install?
    You've definitely got some problems in the pg_attribute catalog.
    If you are lucky, reindexing pg_attribute will get you out of this.
    Otherwise it's time to initdb and reload (or at least drop that one
    database, recreate it, reload it). I wouldn't trust half measures such
    as dropping the one known-corrupt table, because the odds are that more
    rows in pg_attribute got hit than just the ones reported in the first
    failure.

    regards, tom lane

    ---------------------------(end of broadcast)---------------------------
    TIP 3: if posting/reading through Usenet, please send an appropriate
    subscribe-nomail command to [email]majordomopostgresql.org[/email] so that your
    message can get through to the mailing list cleanly

    Tom Lane Guest

Similar Threads

  1. Flash9b.ocx add-on causes IE7 to fail
    By Ty1on-OK in forum Macromedia Flash Player
    Replies: 1
    Last Post: December 18th, 10:09 PM
  2. MS-SQL Connection fail
    By rr008 in forum Coldfusion Database Access
    Replies: 10
    Last Post: May 8th, 10:28 PM
  3. asp pages fail but htm is OK?
    By Rick Lemons in forum ASP Components
    Replies: 11
    Last Post: January 14th, 11:58 AM
  4. What else can cause synchronization to fail?
    By unimportante webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: July 10th, 02:37 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139