On 04/12/2007 15:27, Wim Chalmet wrote:
Sorry for my basic question here, but I can't figure things out. I am running postgres in a windows environment. I would like to redirect the output from a "vacuum full analyze verbose;" to a text file. How do I do this?
You could use the standalone program vacuumdb and redirect its output, thus: vacuumdb -U postgres your_database >out.txt 2>&1 HTH Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx --------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
