#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    6
    Rep Power
    0

    database dumping problem


    Hi,

    I'm trying to dump a database and I received the error message below

    DumpComment: SELECT failed: 'ERROR: dtoi4: integer out of range

    Im using Postgresl v7.1.3

    When I tried using pg_dump from Postgresql v7.3.4 the error message below appeared.

    Attempt to lock table "tablename" failed. FATAL 1: LockAcquire: lock table 1 is corrupted

    Has anybody experienced this problem? Please help. Thanks in advance
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Posts
    373
    Rep Power
    12
    can you try a different option on pg_dump, like only doing the schema, or only doing the data?

    these options would be

    --schema-only

    and

    --data-only

    respectively. The error you're getting is weird, I don't know about that but maybe you can get out the data and rebuild the schema or vice versa. You could also try specifying a --table=TABLE option to see if it's only having problems with one table.
  4. #3
  5. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62

    Re: database dumping problem


    Originally posted by Ken_Afford
    Hi,

    I'm trying to dump a database and I received the error message below

    DumpComment: SELECT failed: 'ERROR: dtoi4: integer out of range

    Im using Postgresl v7.1.3
    This seems to have been a known problem in PostgreSQL 7.1. See http://www.geocrawler.com/archives/3.../8/50/6525875/
    http://archives.postgresql.org/pgsql...0/msg00046.php


    When I tried using pg_dump from Postgresql v7.3.4 the error message below appeared.

    Attempt to lock table "tablename" failed. FATAL 1: LockAcquire: lock table 1 is corrupted

    Has anybody experienced this problem? Please help. Thanks in advance
    I'm not sure I understand... if the database is in PG 7.1.3 and you can't dump it, then how are you doing this from 7.3.4?

    Are you able to query the table with a normal SQL query in 7.1.3? Then maybe you could just write a script which outputs the table as plain text, as tab-delimited data.
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    6
    Rep Power
    0

    Thanks


    Thanks for your help. What I did was create a script that will dump the tables individually. This worked rather that issuing a single dump command to dump all the tables. What I ment about using pg_dump of a newer version of Postgresql was that I installed a newer Postgresql version from another machine and use the pg_dump command that came with the newer version as the dump client to the database I want to back up. I worked if dumping single tables individually but nod dumping the whole database.

    thanks again.

IMN logo majestic logo threadwatch logo seochat tools logo