Re: Scripting a pg_dumpall/pg_dump backup using bash or perl - Mailing list pgsql-novice

From Kretschmer Andreas
Subject Re: Scripting a pg_dumpall/pg_dump backup using bash or perl
Date
Msg-id 20050203101400.GA5069@kaufbach.delug.de
Whole thread Raw
In response to Scripting a pg_dumpall/pg_dump backup using bash or perl  ("Gavin Henry" <ghenry@suretecsystems.com>)
List pgsql-novice
am  Thu, dem 03.02.2005, um  9:52:35 -0000 mailte Gavin Henry folgendes:
> Dear all,
>
> This is my first post. 2 questions:
>
> 1. How can I script the above so passwords aren't asked for?

You can edit the pg_hba.con and make the client 'trust'. Or you can
tools like http://www.edlsystems.com/shellsql/. Or you can use tools
like expect.


> 2. Is bash or perl better, i.e. should I need DBI?

This is your decision ;-)


Andreas
--
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung.   Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org)     GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)

pgsql-novice by date:

Previous
From: "Gavin Henry"
Date:
Subject: Scripting a pg_dumpall/pg_dump backup using bash or perl
Next
From: Tom Lane
Date:
Subject: Re: Scripting a pg_dumpall/pg_dump backup using bash or perl