Re: Scripting a pg_dumpall/pg_dump backup using bash or perl

From: Kretschmer Andreas <andreas_kretschmer(at)despammed(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Scripting a pg_dumpall/pg_dump backup using bash or perl
Date: 2005-02-03 10:14:00
Message-ID: 20050203101400.GA5069@kaufbach.delug.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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° ;-)

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-02-03 14:39:14 Re: Scripting a pg_dumpall/pg_dump backup using bash or perl
Previous Message Gavin Henry 2005-02-03 09:52:35 Scripting a pg_dumpall/pg_dump backup using bash or perl