koji database

Ricky Zhou ricky at fedoraproject.org
Thu Jun 11 00:55:00 UTC 2009


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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: not available
Url : http://lists.fedoraproject.org/pipermail/infrastructure/attachments/20090610/fb8fbaa2/attachment.bin 


More information about the infrastructure mailing list