From: Hilmar L. <hl...@du...> - 2009-12-02 14:48:48
|
Rutger - I would suggest that you post any backup requests that we want to rely on being able to restore from to the helpdesk at NESCent. This is one of our responsibilities as TreeBASE hosts, including being accountable if something goes wrong. -hilmar On Dec 2, 2009, at 6:36 AM, Rutger Vos wrote: > Hi, > > I am about to run a script that deletes orphaned taxonlabels from the > database. These labels were created during an intermediate step of > data bulk loading. They don't interfere with the integrity of genuine > records, but may have some effect on performance (though probably not > spectacular) so I want to get rid of them. Just to be on the safe > side, I want to dump the database first. Also, this might be a good > practice run if we want to release periodical database dumps to the > public (the way itis and ncbi do). So what would be the best way to do > this? Anyone have any experience running pg_dump? > > Rutger > > -- > Dr. Rutger A. Vos > School of Biological Sciences > Philip Lyle Building, Level 4 > University of Reading > Reading > RG6 6BX > United Kingdom > Tel: +44 (0) 118 378 7535 > http://www.nexml.org > http://rutgervos.blogspot.com > > ------------------------------------------------------------------------------ > Join us December 9, 2009 for the Red Hat Virtual Experience, > a free event focused on virtualization and cloud computing. > Attend in-depth sessions from your desk. Your couch. Anywhere. > http://p.sf.net/sfu/redhat-sfdev2dev > _______________________________________________ > Treebase-devel mailing list > Tre...@li... > https://lists.sourceforge.net/lists/listinfo/treebase-devel -- =========================================================== : Hilmar Lapp -:- Durham, NC -:- hlapp at duke dot edu : =========================================================== |