Re: automating backup ?

From: "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
To: "Andreas" <maps(dot)on(at)gmx(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: automating backup ?
Date: 2005-06-29 09:31:08
Message-ID: 003f01c57c8d$62fd5650$2b748353@zlatko58zaczpv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)on(at)gmx(dot)net>
To: "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Cc: <pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zlatko Matić 2005-06-29 09:34:39 truncate all tables?
Previous Message Zlatko Matic 2005-06-29 09:28:54 Re: automating backup ?