| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | William Shatner <shatner(dot)william(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Automatic database backup on Windows Machine |
| Date: | 2005-03-03 02:11:24 |
| Message-ID: | 8B4196B9-8B89-11D9-B9BF-000A95B03262@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mar 2, 2005, at 4:18 AM, William Shatner wrote:
> I am a newbie at PostgreSQL. I am running PostgreSQL 8.0 on Windows
> XP. I would like to automate my database backup (pg_dump, pg_dumpall).
>
> I can't add it to scheduled tasks as Windows doesn't see my PostgreSQL
> superuser account (it only sees the service a/c). Even if it did i
> think there might be issues when it prompts for a password????. I am
> logged into my machine as my Windows user name.
The password issue can be resolved with the pgpass file:
http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Rademeyer | 2005-03-03 05:08:34 | Re: Application gui |
| Previous Message | Jim C. Nasby | 2005-03-02 20:40:43 | Re: Scheduling/Automated Jobs in Postgre |