From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Eric Naujock <naujocke(at)abacusii(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Expect and scripting. |
Date: | 2002-06-24 21:29:52 |
Message-ID: | 200206241429.52999.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Eric,
> I have all my databases password protected hence a need for doing this for
backup.
>
> Currently this is what I am doing
>
> spawn /usr/bin/pg_dump -U myusername -b -c -F c -f /backup/databasename_sql
databasename
> expect Password:
> send "the_password\r"
>
> any tips or suggestions would be appreciated.
I would suggest instead configureing pg_hba.conf to allow "Trust" access from
the specific user and host that does the backup. This will save you a lot
of trouble.
--
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Sharda Srinivasan | 2002-06-25 11:54:23 | SQL operators |
Previous Message | Brett Krebs | 2002-06-24 20:12:28 | Help working with arrays / vectors |