Обсуждение: pg_dumpall fails
begin flood bleh. i can't tell if i'm getting somewhere, or running around in circles. i don't know what my brother has been doing on the other end, but pg_dumpall now returns this: SELECT nextval ('"art_links_id_seq"'); dumpSequence(submissions_submission_id_seq): different sequence name returned by SELECT: submissions_n_submission_id_seq pg_dump failed on immedia2002, exiting help? -- =-=--------------------------------------------=-= -.c.- My mistress when she walks treads on the ground.
Willy Wonka <lunchtime@onethirty.org> writes: > i don't know what my brother has been doing on the other end, but > pg_dumpall now returns this: > SELECT nextval ('"art_links_id_seq"'); > dumpSequence(submissions_submission_id_seq): different sequence name > returned by SELECT: submissions_n_submission_id_seq What he's been doing is renaming sequences ... pg_dump doesn't like that, for no particularly good reason :-(. (This gratuitous failure is gone in 7.3, but that doesn't help you much today.) I'd suggest dropping and recreating the sequence, then using setval() to set its current value correctly. Then you should be able to pg_dump. regards, tom lane
After a recent failure and restore I noticed two things that might be bugs in pg_dumpall: 1. It saves the users passwords as plain text in the dump. (gack) 2. It doesnt seem to be i18n friendly. Our tables had lots of umlats and accent's etc in them and they barfed on the restore noticed that they were represented as \0232 or such. I had to hand fix all occurances to import. -- Derek Neighbors GNU Enterprise http://www.gnuenterprise.org derek@gnue.org Was I helpful? Let others know: http://svcs.affero.net/rm.php?r=dneighbo
Вложения
i'm getting further, i think. i dropped and created the new sequence. i don't think i had to set the current value, because currval returned submissions_submission_id_seq.currval is not yet defined in this session [this database isn't on a production server at the moment] now i get a new error: > pg_dumpall > bigdump dumpSequence(website_suggest_id_seq): 0 (!= 1) tuples returned by SELECT pg_dump failed on immedia2002, exiting ok, so 0 isn't 1. is there anything i can do about this one? -c At 11:38 PM -0400 9/27/02, Tom Lane wrote: >Willy Wonka <lunchtime@onethirty.org> writes: >> i don't know what my brother has been doing on the other end, but >> pg_dumpall now returns this: > > > SELECT nextval ('"art_links_id_seq"'); > > dumpSequence(submissions_submission_id_seq): different sequence name >> returned by SELECT: submissions_n_submission_id_seq > >What he's been doing is renaming sequences ... pg_dump doesn't like >that, for no particularly good reason :-(. (This gratuitous failure >is gone in 7.3, but that doesn't help you much today.) I'd suggest >dropping and recreating the sequence, then using setval() to set its >current value correctly. Then you should be able to pg_dump. > > regards, tom lane
Derek Neighbors wrote: -- Start of PGP signed section. > After a recent failure and restore I noticed two things that might be > bugs in pg_dumpall: > > 1. It saves the users passwords as plain text in the dump. (gack) Use: password_encryption = true and during the load the passwords will be MD5 encrypted. However, this disables pre-7.2 clients using crypt. This will be the default in 7.3. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073