Re: automating backup ?
От | Zlatko Matic |
---|---|
Тема | Re: automating backup ? |
Дата | |
Msg-id | 003f01c57c8d$62fd5650$2b748353@zlatko58zaczpv обсуждение исходный текст |
Ответ на | Re: automating backup ? ("Relyea, Mike" <Mike.Relyea@xerox.com>) |
Ответы |
Explain Analyse never returns .. maybe a bug
|
Список | pgsql-general |
Hi. Yes, you were right. I added lines for template0 and template1 into pgpass.conf file and now it works. I'm wondering how to include timestamp in backup file name ? ----- Original Message ----- From: "Andreas" <maps.on@gmx.net> To: "Zlatko Matic" <zlatko.matic1@sb.t-com.hr> Cc: <pgsql-general@postgresql.org> Sent: Wednesday, June 29, 2005 1:56 AM Subject: Re: [GENERAL] automating backup ? > Zlatko Matic schrieb: > >> Now I have pgpass.conf file in D:\Documents and >> Settings\Zlatko\Application Data\postgresql >> content of pgpass.conf is: >> localhost:*:MONITORINGZ:postgres:tralalala >> >> content of backup_script.bat is: >> cd D:\Program Files\PostgreSQL\8.0\bin >> pg_dumpall >D:\MONITORINGZ_DUMPALL -U postgres >> >> still prompts for password...What is wrong ? > > > Perhaps its like this. > pg_dumpall wants to dump the whole database-cluster (every database in > your server) that is not only "MONITORINGZ" but the two templates, too. > So pg_dumpall doesn't ask you for the password to your own database but 2 > times for the pw for the 2 template DBs. > > In pgpass.conf write * instead of MONITORINGZ or copy the line for > template0 and template1. > Or don't use pg_dumpall and use pg_dump instead just for MONITORINGZ. > > Maybe it's somerthing else ... one never knows with those computers ... ;) > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
В списке pgsql-general по дате отправления: