pg_dump failure, can't get data out...

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема pg_dump failure, can't get data out...
Дата
Msg-id 20010826191354.A3950@lerami.lerctr.org
обсуждение исходный текст
Ответы Re: pg_dump failure, can't get data out...  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pg_dump failure, can't get data out...  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pg_dump failure, can't get data out...  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
I had upgraded yesterday and *THOUGHT* all was fine. 

Forgot to pg_dump, so I restored my $PGLIB and bin directory, now get
the following when I try to pg_dump:

$ pg_dump ler >z
Password: 
pg_dump: query to get function name of oid - failed: ERROR:  oidin:
error in "-": can't parse "-"
$ 

And the debug query log:

Aug 26 19:10:05 lerami pg-prod[3861]: [1] DEBUG:  connection: host=[local] user=ler database=ler
Aug 26 19:10:05 lerami pg-prod[3861]: [2] DEBUG:  InitPostgres
Aug 26 19:10:05 lerami pg-prod[3861]: [3] DEBUG:  StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [4] DEBUG:  query: select getdatabaseencoding()
Aug 26 19:10:05 lerami pg-prod[3861]: [5] DEBUG:  ProcessQuery
Aug 26 19:10:05 lerami pg-prod[3861]: [6] DEBUG:  CommitTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [7] DEBUG:  StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [8] DEBUG:  query: SELECT version();
Aug 26 19:10:05 lerami pg-prod[3861]: [9] DEBUG:  ProcessQuery
Aug 26 19:10:05 lerami pg-prod[3861]: [10] DEBUG:  CommitTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [11] DEBUG:  StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [12] DEBUG:  query: begin
Aug 26 19:10:05 lerami pg-prod[3861]: [13] DEBUG:  ProcessUtility: begin
Aug 26 19:10:05 lerami pg-prod[3861]: [14] DEBUG:  CommitTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [15] DEBUG:  StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [16] DEBUG:  query: set transaction isolation level serializable
Aug 26 19:10:05 lerami pg-prod[3861]: [17] DEBUG:  ProcessUtility: set transaction isolation level serializable
Aug 26 19:10:05 lerami pg-prod[3861]: [18] DEBUG:  CommitTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [19] DEBUG:  StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [20] DEBUG:  query: SELECT datlastsysoid from pg_database where datname = 'ler'
Aug 26 19:10:05 lerami pg-prod[3861]: [21] DEBUG:  ProcessQuery
Aug 26 19:10:05 lerami pg-prod[3861]: [22] DEBUG:  CommitTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [23] DEBUG:  StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [24] DEBUG:  query: select (select usename from pg_user where datdba = usesysid)
asdba from pg_database where datname = 'ler'
 
Aug 26 19:10:05 lerami pg-prod[3861]: [25] DEBUG:  ProcessQuery
Aug 26 19:10:05 lerami pg-prod[3861]: [26] DEBUG:  CommitTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [27] DEBUG:  StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [28-1] DEBUG:  query: SELECT pg_type.oid, typowner, typname, typlen, typprtlen,
typinput,typoutput, typreceive, typsend, typelem,
 
Aug 26 19:10:05 lerami pg-prod[3861]: [28-2]  typdelim, typdefault, typrelid, typalign, typstorage, typbyval,
typisdefined,(select usename from pg_user where typowner =
 
Aug 26 19:10:05 lerami pg-prod[3861]: [28-3]  usesysid) as usename, format_type(pg_type.oid, NULL) as typedefn from
pg_type
Aug 26 19:10:05 lerami pg-prod[3861]: [29] DEBUG:  ProcessQuery
Aug 26 19:10:06 lerami pg-prod[3861]: [30] DEBUG:  CommitTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [31] DEBUG:  StartTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [32-1] DEBUG:  query: SELECT pg_proc.oid, proname, prolang, pronargs, prorettype,
proretset,proargtypes, prosrc, probin, (select
 
Aug 26 19:10:06 lerami pg-prod[3861]: [32-2]  usename from pg_user where proowner = usesysid) as usename,
proiscachable,proisstrict from pg_proc where pg_proc.oid >
 
Aug 26 19:10:06 lerami pg-prod[3861]: [32-3]  '16554'::oid
Aug 26 19:10:06 lerami pg-prod[3861]: [33] DEBUG:  ProcessQuery
Aug 26 19:10:06 lerami pg-prod[3861]: [34] DEBUG:  CommitTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [35] DEBUG:  StartTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [36-1] DEBUG:  query: SELECT pg_aggregate.oid, aggname, aggtransfn, aggfinalfn,
aggtranstype,aggbasetype, agginitval, 't'::boolean as
 
Aug 26 19:10:06 lerami pg-prod[3861]: [36-2]  convertok, (select usename from pg_user where aggowner = usesysid) as
usenamefrom pg_aggregate
 
Aug 26 19:10:06 lerami pg-prod[3861]: [37] DEBUG:  ProcessQuery
Aug 26 19:10:06 lerami pg-prod[3861]: [38] DEBUG:  CommitTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [39] DEBUG:  StartTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [40-1] DEBUG:  query: SELECT pg_operator.oid, oprname, oprkind, oprcode, oprleft,
oprright,oprcom, oprnegate, oprrest, oprjoin,
 
Aug 26 19:10:06 lerami pg-prod[3861]: [40-2]  oprcanhash, oprlsortop, oprrsortop, (select usename from pg_user where
oprowner= usesysid) as usename from pg_operator
 
Aug 26 19:10:06 lerami pg-prod[3861]: [41] DEBUG:  ProcessQuery
Aug 26 19:10:06 lerami pg-prod[3861]: [42] DEBUG:  CommitTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [43] DEBUG:  StartTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [44-1] DEBUG:  query: SELECT pg_class.oid, relname, relacl, relkind, (select
usenamefrom pg_user where relowner = usesysid) as
 
Aug 26 19:10:06 lerami pg-prod[3861]: [44-2]  usename, relchecks, reltriggers, relhasindex, relhasoids from pg_class
whererelname !~ '^pg_' and relkind in ('r', 'S', 'v')
 
Aug 26 19:10:06 lerami pg-prod[3861]: [44-3]  order by oid
Aug 26 19:10:06 lerami pg-prod[3861]: [45] DEBUG:  ProcessQuery
Aug 26 19:10:06 lerami pg-prod[3861]: [46] DEBUG:  CommitTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [47] DEBUG:  StartTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [48] DEBUG:  query: SELECT indexrelid FROM pg_index i WHERE i.indisprimary AND
i.indrelid= 20947 
 
Aug 26 19:10:06 lerami pg-prod[3861]: [49] DEBUG:  ProcessQuery
Aug 26 19:10:06 lerami pg-prod[3861]: [50] DEBUG:  CommitTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [51] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [448-2]  relname = 'pg_class') and objsubid = 9
Aug 26 19:10:07 lerami pg-prod[3861]: [449] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [450] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [451] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [452-1] DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
20974and classoid = (SELECT oid FROM pg_class where
 
Aug 26 19:10:07 lerami pg-prod[3861]: [452-2]  relname = 'pg_class') and objsubid = 10
Aug 26 19:10:07 lerami pg-prod[3861]: [453] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [454] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [455] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [456-1] DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
20974and classoid = (SELECT oid FROM pg_class where
 
Aug 26 19:10:07 lerami pg-prod[3861]: [456-2]  relname = 'pg_class') and objsubid = 0
Aug 26 19:10:07 lerami pg-prod[3861]: [457] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [458] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [459] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [460-1] DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
20976and classoid = (SELECT oid FROM pg_class where
 
Aug 26 19:10:07 lerami pg-prod[3861]: [460-2]  relname = 'pg_class') and objsubid = 1
Aug 26 19:10:07 lerami pg-prod[3861]: [461] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [462] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [463] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [464-1] DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
20976and classoid = (SELECT oid FROM pg_class where
 
Aug 26 19:10:07 lerami pg-prod[3861]: [464-2]  relname = 'pg_class') and objsubid = 2
Aug 26 19:10:07 lerami pg-prod[3861]: [465] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [466] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [467] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [468-1] DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
20976and classoid = (SELECT oid FROM pg_class where 
Aug 26 19:10:07 lerami pg-prod[3861]: [468-2]  relname = 'pg_class') and objsubid = 3
Aug 26 19:10:07 lerami pg-prod[3861]: [469] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [470] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [471] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [472-1] DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
20976and classoid = (SELECT oid FROM pg_class where
 
Aug 26 19:10:07 lerami pg-prod[3861]: [472-2]  relname = 'pg_class') and objsubid = 4
Aug 26 19:10:07 lerami pg-prod[3861]: [473] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [474] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [475] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [476-1] DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
20976and classoid = (SELECT oid FROM pg_class where
 
Aug 26 19:10:07 lerami pg-prod[3861]: [476-2]  relname = 'pg_class') and objsubid = 5
Aug 26 19:10:07 lerami pg-prod[3861]: [477] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [478] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [479] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [480-1] DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
20976and classoid = (SELECT oid FROM pg_class where
 
Aug 26 19:10:07 lerami pg-prod[3861]: [480-2]  relname = 'pg_class') and objsubid = 6
Aug 26 19:10:07 lerami pg-prod[3861]: [481] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [482] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [483] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [484-1] DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
20976and classoid = (SELECT oid FROM pg_class where
 
Aug 26 19:10:07 lerami pg-prod[3861]: [484-2]  relname = 'pg_class') and objsubid = 7
Aug 26 19:10:07 lerami pg-prod[3861]: [485] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [486] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [487] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [488-1] DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
20976and classoid = (SELECT oid FROM pg_class where
 
Aug 26 19:10:07 lerami pg-prod[3861]: [488-2]  relname = 'pg_class') and objsubid = 8
Aug 26 19:10:07 lerami pg-prod[3861]: [489] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [490] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [491] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [492-1] DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
20976and classoid = (SELECT oid FROM pg_class where
 
Aug 26 19:10:07 lerami pg-prod[3861]: [492-2]  relname = 'pg_class') and objsubid = 9
Aug 26 19:10:07 lerami pg-prod[3861]: [493] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [494] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [495] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [496-1] DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
20976and classoid = (SELECT oid FROM pg_class where
 
Aug 26 19:10:07 lerami pg-prod[3861]: [496-2]  relname = 'pg_class') and objsubid = 10
Aug 26 19:10:07 lerami pg-prod[3861]: [497] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [498] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [499] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [500-1] DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
20976and classoid = (SELECT oid FROM pg_class where
 
Aug 26 19:10:07 lerami pg-prod[3861]: [500-2]  relname = 'pg_class') and objsubid = 0
Aug 26 19:10:07 lerami pg-prod[3861]: [501] DEBUG:  ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [502] DEBUG:  CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [503] DEBUG:  StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [504] DEBUG:  query: SELECT proname from pg_proc where pg_proc.oid = '-'::oid
Aug 26 19:10:07 lerami pg-prod[3861]: [505] ERROR:  oidin: error in "-": can't parse "-"
Aug 26 19:10:07 lerami pg-prod[3861]: [506] DEBUG:  AbortCurrentTransaction
Aug 26 19:10:07 lerami pg-prod[3861]: [507] DEBUG:  proc_exit(0)
Aug 26 19:10:07 lerami pg-prod[3861]: [508] DEBUG:  shmem_exit(0)
Aug 26 19:10:07 lerami pg-prod[3861]: [509] DEBUG:  exit(0)

Any ideas on how I can get my data out? 

LER

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Anyone see any value in LockDisable/LockingDisabled mechanism?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump failure, can't get data out...