VACCUM VERBOSE ANALYZE
| От | Cédric BUSCHINI |
|---|---|
| Тема | VACCUM VERBOSE ANALYZE |
| Дата | |
| Msg-id | 4469C0AD.60802@carax.com обсуждение исходный текст |
| Ответы |
Re: VACCUM VERBOSE ANALYZE
|
| Список | pgsql-novice |
Hello,
I would like to save in a file log from a "VACUUM VERBOSE analyze" perform from psql.
I ve tried different ways :
--------------
[USER@DBsrv] # psql -c'VACUUM VERBOSE analyze' > /home/log_vaccum
--------------
the same command in a script without the '> /home/log_vaccum'
[USER@DBsrv] # vaccum.sh > /home/log_vaccum
--------------
[USER@DBsrv]# psql
Welcome to psql 8.0.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
DBsrv=# VACUUM VERBOSE analyze; \o /home/log_vaccum
--------------
..... but no one worked :(
The log file is created but empty.
Does any one got an idea ?
Cheers
Cedric
I would like to save in a file log from a "VACUUM VERBOSE analyze" perform from psql.
I ve tried different ways :
--------------
[USER@DBsrv] # psql -c'VACUUM VERBOSE analyze' > /home/log_vaccum
--------------
the same command in a script without the '> /home/log_vaccum'
[USER@DBsrv] # vaccum.sh > /home/log_vaccum
--------------
[USER@DBsrv]# psql
Welcome to psql 8.0.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
DBsrv=# VACUUM VERBOSE analyze; \o /home/log_vaccum
--------------
..... but no one worked :(
The log file is created but empty.
Does any one got an idea ?
Cheers
Cedric
В списке pgsql-novice по дате отправления: