Re: Administration tips

On 26 Jun 2000, Camm Maguire wrote:

CM> Both of these basically depend on 'pg_dump | psql'. From what I
CM> understand now, the pg_dump has to be executed on the db host unless
CM> user checking across the network is disabled with a 'trust' entry in
CM> hba.conf, as pg_dump needs to connect as postgres. It would be great
CM> if the replication/backup procedure could be run on an arbitrary host
CM> without disabling all such user checking.

You could define $PGPASSWORD to authenticate with passwords; also, you can
restrict the backup host with no passwords (restricting IP traffic by
ipfw, e.g) but with ident... Ways are vary... Surely in latter case you
should make sure that no others connections to your db are possible from
that (hopefully the most restricted host in the network -- this possibly
should apply to any kind of backup host).

Just my $.02 ;-)

Sincerely,
D.Marck [DM5020, DM268-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck(at)rinet(dot)ru ***
------------------------------------------------------------------------