Re: Administration tips

Поиск
Список
Период
Сортировка
От Dmitry Morozovsky
Тема Re: Administration tips
Дата
Msg-id Pine.BSF.4.21.0006262012380.24171-100000@woozle.rinet.ru
обсуждение исходный текст
Ответ на Administration tips  (Camm Maguire <camm@enhanced.com>)
Список pgsql-admin
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@rinet.ru ***
------------------------------------------------------------------------


В списке pgsql-admin по дате отправления:

Предыдущее
От: Camm Maguire
Дата:
Сообщение: Administration tips
Следующее
От: Michael Fraley
Дата:
Сообщение: ERROR: fmgr_info: function 19104: cache lookup failed