[gold-users] Backing up gold database

Scott Jackson scottmo at adaptivecomputing.com
Fri Jun 11 14:43:03 MDT 2010

You did it (mostly) the right way. I think what you did wrong here is 
that you did not dropdb gold and createdb gold. Therefore, I think you 
basically duplicated many of your lines in the database, which would 
explain the unable to generate nextid error.


Steve Crusan wrote:
> Sorry for the newbie (postgres + gold) question, but what is the best 
> way to backup the gold database?
> While I was waiting for someone to work on some other gold functions, 
> I decided to make some horrific changes to the golddb via the goldsh 
> commands, ;-)
> Before that, I stopped gold, and then did the standard pg_dump gold 
> >gold-$DATE.sql
> I started up gold again, and deleted all the role actions...(2ndary 
> gold dev env, so it’s okay)
> Then I did the restore using psql gold < gold-$DATE.sql
> When I start the daemon again, I cannot run commands anymore, 
> basically I get the error:
> Failed obtaining database connection: Unable to generate next id for 
> Request
> That seems to be an issue with the transaction logs.
> Is there a better way to do online/offline backups of the gold db? I 
> realize this might be a postgres question, so I apologize is this is 
> in the wrong list.
> Thanks!
> ----------------------
> Steve Crusan
> System Administrator
> Center for Research Computing
> University of Rochester
> (585) 276-5599
> https://www.crc.rochester.edu/
> ------------------------------------------------------------------------
> _______________________________________________
> gold-users mailing list
> gold-users at supercluster.org
> http://www.supercluster.org/mailman/listinfo/gold-users

More information about the gold-users mailing list