[Treebase-devel] pg_dump how best to run?

[Rutger V. <rut...@gm...>]

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