Re: HELP! Restore from a pg_dump?
Yes I got the reply, thanks. We've been working on the problem in our own time zone and it transpired that one team member was in the process of moving the DB from localhost to a central server. The work was incomplete but went live by mistake. There was a SUGUSR1 that restarted / reloaded apache2 on Sunday. Could that be a cron? On Wednesday, March 11, 2015 at 10:00:47 PM UTC, Christian Hammond wrote: > > Hi Craig, > > I want to check whether you received our e-mail on the support address? > > Christian > > -- > Christian Hammond - chri...@beanbaginc.com > Review Board - https://www.reviewboard.org > Beanbag, Inc. - https://www.beanbaginc.com > > -Original Message- > From: Craig Emery > > Reply: revie...@googlegroups.com >> > Date: March 11, 2015 at 11:50:50 AM > To: revie...@googlegroups.com >> > Subject: HELP! Restore from a pg_dump? > > > I've ended up in a sorry situation. > > > > I don't know how I really got into this. > > I found lots of this in my /var/log/apache2/error.log > > [Sun Mar 08 06:25:22 2015] [error] ERROR:root:Could not load siteconfig: > > relation "django_site" does not exist > > [Sun Mar 08 06:25:22 2015] [error] LINE 1: ..."django_site"."domain", > > "django_site"."name" FROM "django_si... > > > > So I thought I'd > > > > $ rb-site manage syndb > > > > That seemed to make the site run again, but it's empty. > > > > I haven't been making backups by > > > > $ rb-site manage dumpdb > json-file > > > > I've got a single pg_dump in an SQL file from a day or so before the > > "crash." > > > > If I restore using psql I end up with a DB with 0 reviews, no users, > > basically en empty site. > > > > What can I do after the psql invoke to get the site working again, if at > > all? > > > > I've got an immense amount of history, repos, user accounts lost. > > > > -- > > Supercharge your Review Board with Power Pack: > https://www.reviewboard.org/powerpack/ > > Want us to host Review Board for you? Check out RBCommons: > https://rbcommons.com/ > > Happy user? Let us know! https://www.reviewboard.org/users/ > > --- > > You received this message because you are subscribed to the Google > Groups "reviewboard" > > group. > > To unsubscribe from this group and stop receiving emails from it, send > an email to reviewboard...@googlegroups.com . > > For more options, visit https://groups.google.com/d/optout. > > > > -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: HELP! Restore from a pg_dump?
Hi Craig, I want to check whether you received our e-mail on the support address? Christian -- Christian Hammond - christ...@beanbaginc.com Review Board - https://www.reviewboard.org Beanbag, Inc. - https://www.beanbaginc.com -Original Message- From: Craig Emery Reply: reviewboard@googlegroups.com > Date: March 11, 2015 at 11:50:50 AM To: reviewboard@googlegroups.com > Subject: HELP! Restore from a pg_dump? > I've ended up in a sorry situation. > > I don't know how I really got into this. > I found lots of this in my /var/log/apache2/error.log > [Sun Mar 08 06:25:22 2015] [error] ERROR:root:Could not load siteconfig: > relation "django_site" does not exist > [Sun Mar 08 06:25:22 2015] [error] LINE 1: ..."django_site"."domain", > "django_site"."name" FROM "django_si... > > So I thought I'd > > $ rb-site manage syndb > > That seemed to make the site run again, but it's empty. > > I haven't been making backups by > > $ rb-site manage dumpdb > json-file > > I've got a single pg_dump in an SQL file from a day or so before the > "crash." > > If I restore using psql I end up with a DB with 0 reviews, no users, > basically en empty site. > > What can I do after the psql invoke to get the site working again, if at > all? > > I've got an immense amount of history, repos, user accounts lost. > > -- > Supercharge your Review Board with Power Pack: > https://www.reviewboard.org/powerpack/ > Want us to host Review Board for you? Check out RBCommons: > https://rbcommons.com/ > Happy user? Let us know! https://www.reviewboard.org/users/ > --- > You received this message because you are subscribed to the Google Groups > "reviewboard" > group. > To unsubscribe from this group and stop receiving emails from it, send an > email to reviewboard+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
HELP! Restore from a pg_dump?
I've ended up in a sorry situation. I don't know how I really got into this. I found lots of this in my /var/log/apache2/error.log [Sun Mar 08 06:25:22 2015] [error] ERROR:root:Could not load siteconfig: relation "django_site" does not exist [Sun Mar 08 06:25:22 2015] [error] LINE 1: ..."django_site"."domain", "django_site"."name" FROM "django_si... So I thought I'd $ rb-site manage syndb That seemed to make the site run again, but it's empty. I haven't been making backups by $ rb-site manage dumpdb > json-file I've got a single pg_dump in an SQL file from a day or so before the "crash." If I restore using psql I end up with a DB with 0 reviews, no users, basically en empty site. What can I do after the psql invoke to get the site working again, if at all? I've got an immense amount of history, repos, user accounts lost. -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
