Re: pg_dump command inside shell scripts

Hi,

Yes, Richard is right about suggesting the expect command. If you're
running a Red Hat-based system, you can download the expect rpm from
rpmfind.net.

Once you've installed this, create a file called pg-script.exp and put
the following in there:

#!/usr/bin/expect -f

set username [lindex $argv 0]
set password [lindex $argv 1]
set database [lindex $argv 2]

spawn {pg_dump} -u -Ft $database --file=$database.sql.tar
expect "Username:"
send "$username\r"
expect "Password:"
send "$password\r"
expect eof

This will take the username as the 1st argument, password as the second
argument and database as the third. Dumps them into local variables and
passes the values when prompted by postgresql. It "expects" Username:
and when comes across that, it sends the value for username along with a
carriage return.

Note that it assumes that expect binary is in the /usr/bin directory.

:)

Roj Niyogi
niyogi(at)pghoster(dot)com

pgHoster - PostgreSQL Web Hosting
http://www.pghoster.com

Richard Huxton wrote:

>On Tuesday 08 Oct 2002 2:35 pm, Elielson Fontanezi wrote:
>
>
>>Hi Folks!
>>
>> Again I need a help from you!
>>
>> I have develop a shell script (seen below) to do dump and vaccum
>>automatically.
>>
>>
>
>
>
>> But now I need change the $PGDATA/*hba.conf file as it was originally
>>and
>>face the password prompt again.
>>
>>
>
>Do a search on "expect" - probably included with your system and designed for
>this sort of interactive chatting (traditionally with a modem). There's also
>a perl module to do the same.
>
>- Richard Huxton
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
>
>