Thread

1. Expect and scripting.

   Eric Naujock <naujocke@abacusii.com> — 2002-06-24T01:46:00Z

   Does anyone have an example of an expect script that could work. For some reason either I am not understanding something about this or My script is just wrong but my pg_sump script does not work with expect. 
   
   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.
   
   thanks in advance.
   
   --------------------------------------------------------------------------------
   Eric Naujock  CCNA, CCDA, A+, Network +, I-Net +
   Abacus II
   5610 Monroe St.
   Sylvania, Ohio 43560
   <http://www.abacusii.com>
   E-mail - naujocke@abacusii.com
   Phone - 419-885-0082  X 241
   Fax : 419-885-2717
   AOL IM: erlic
   

2. Re: Expect and scripting.

   Josh Berkus <josh@agliodbs.com> — 2002-06-24T21:29:52Z

   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@agliodbs.com
       and data management solutions 	(415) 565-7293
      for law firms, small businesses 	 fax 621-2533
       and non-profit organizations. 	San Francisco