SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 11:13 PM
| ||||
| ||||
 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.log And also this: psql -d sirius_lm -U postgres -f run_vacuum.sql >vacuum.log But 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.      |
|
04-09-2008, 11:13 PM
| |||
| |||
| Re: Vacuum output redirect does psql have write access to the folder? M- ----- Original Message ----- From: Wim Chalmet To: pgsql-general@postgresql.org Sent: Tuesday, December 04, 2007 10:27 AM Subject: [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.log And also this: psql -d sirius_lm -U postgres -f run_vacuum.sql >vacuum.log But 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. |
|
04-09-2008, 11:13 PM
| ||||
| ||||
| Re: Vacuum output redirect 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. On 12/4/07, Martin Gainty <mgainty@hotmail.com> wrote: > > does psql have write access to the folder? > > M- > > ----- Original Message ----- > *From:* Wim Chalmet <wim.chalmet@gmail.com> > *To:* pgsql-general@postgresql.org > *Sent:* Tuesday, December 04, 2007 10:27 AM > *Subject:* [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.log > > And also this: > psql -d sirius_lm -U postgres -f run_vacuum.sql >vacuum.log > > But 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. |
Linear Mode
