Re: Vacuum output redirect
| От | Wim Chalmet |
|---|---|
| Тема | Re: Vacuum output redirect |
| Дата | |
| Msg-id | b29c4c2a0712041742l4a3fb83dga30cf27f208c76e4@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Vacuum output redirect ("Martin Gainty" <mgainty@hotmail.com>) |
| Список | pgsql-general |
Yes, the write access is fine. I think I have a problem with syntax. I don't know if there is a command switch on psql to redirect standard output to a logfile. THere is one for any query results, but that does not happen to contain the output of vacuum.
--
Do you want to make a difference? Issue a microloan at www.kiva.org.
On 12/4/07, Martin Gainty <mgainty@hotmail.com> wrote:
does psql have write access to the folder?
M------ Original Message -----From: Wim ChalmetSent: Tuesday, December 04, 2007 10:27 AMSubject: [GENERAL] Vacuum output redirect
Hi,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?I have tried this (the file "run_vacuum.sql" just contains this one line - without quotes of course: "vacuum full analyze verbose;" )psql -d sirius_lm -U postgres -f run_vacuum.sql -o vacuum.logAnd also this:psql -d sirius_lm -U postgres -f run_vacuum.sql >vacuum.logBut none of that works. Can anybody help a beginner out? Thanks!
--
Do you want to make a difference? Issue a microloan at www.kiva.org.
--
Do you want to make a difference? Issue a microloan at www.kiva.org.
В списке pgsql-general по дате отправления: