vacuumdb with cronjob needs password since 9.0?
От | Andreas Laggner |
---|---|
Тема | vacuumdb with cronjob needs password since 9.0? |
Дата | |
Msg-id | 4DCBA0B4.80909@vti.bund.de обсуждение исходный текст |
Ответы |
Re: vacuumdb with cronjob needs password since 9.0?
Re: vacuumdb with cronjob needs password since 9.0? |
Список | pgsql-general |
Hi list, i always vaccumed my postgresql automatically with crontab, because autovacuum is not suitable for my applications. With version 8.2 it works perfect for me with this command line: 00 02 * * * postgres /usr/bin/vacuumdb -d gis -z But not with 9.0, because vacuumdb now wants to have the password to connect to the db. i did not find any options to send the password with the command line in vacuumdb!? Cheers Andreas -- Dipl. Geoökologe Andreas Laggner Institut für Agrarrelevante Klimaforschung (AK) des vTI Arbeitsgruppe Emissionsinventare Johann Heinrich von Thünen-Institut (vTI), Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei Institute of Agricultural Climate Research (AK) of the vTI Johann Heinrich von Thünen-Institute (vTI), Federal Research Institute for Rural Areas, Forestry and Fisheries Bundesallee 50 D-38116 Braunschweig Tel.: (+49) (0)531 596 2636 Fax : (+49) (0)531 596 2645 E-mail: andreas.laggner@vti.bund.de Homepage: http://www.vti.bund.de
В списке pgsql-general по дате отправления: