On Wed, Jun 10, 2009 at 6:55 PM, Ricky Zhou<ricky(a)fedoraproject.org> wrote:
Just so that this is documented somewhere:
I accidentally ran the following command in
/backups/postgres/db3.fedora.phx.redhat.com on db3 (I was expecting
something else to be in my paste buffer):
vim sudo createdb -T template1 koji && pg_restore --use-set-session-authorization
-d koji koji.db
As a result, the pg_restore command ran for a moment before I ctrl-ced
it. This caused some sequences in the database to be reset, and I'm not
exactly sure what else could have happened in that short time. mbonnet
took a look at it and fixed up the sequences, but keep an eye out for
anything else that could have happened here.
Sorry for the trouble - I'll be more careful next time :-(
Ricky
Thankyou for documenting it. Its all a learning experience.
--
Stephen J Smoogen. -- BSD/GNU/Linux
How far that little candle throws his beams! So shines a good deed
in a naughty world. = Shakespeare. "The Merchant of Venice"