Automated restore?

Hi,

I'd like to have a simple system whereby I can sync a local copy of a
whole database from the master.

My first shot at this has been,

ssh root(at)master "pg_dump -c $DATABASE" | sudo -u postgres psql -q $DATABASE

where postgres is the Debian user that has what I understand to be
super-user style privs with PostgreSQL.

The problem is that the dump contains \connect commands which require me
to either authenticate or create *nix users and run ident - as far as I
can tell. Ideally I'd like the super-user to be able to perform these
connects silently - the initial authentication effectively happening at
sudo time.

(My pg_hba.conf has localhost password authenticating so the webserver
can access it, and ident/username based for unix sockets.)

Is this possible? Is there a better way of doing what I'm trying?

If I've missed R'ing something in TFM, pointers appreciated! I didn't
see anything in the Admin Guide.

Thanks, Paul

--
Paul Makepeace ....................................... http://paulm.com/

"What is the sun's temperature? Life is a tasty cereal."
-- http://paulm.com/toys/surrealism/