Diferent Instances

Поиск
Список
Период
Сортировка
От Rodrigo Sakai
Тема Diferent Instances
Дата
Msg-id 20040210121342.16561.qmail@hm10.locaweb.com.br
обсуждение исходный текст
Ответы Re: Diferent Instances
Список pgsql-admin

  Hi,

  We are using PostgreSQL for a lot of distinct databases, and so the problem is, when occurs an error on just one
databaseand we have to restart the postmaster process, it kills all the others databases that do not have problem,
becausethere is only one instance controling the databases. But we are making an ASP, so we should not run into this
kindof problem. 
  I think abut a solution, if I make initdb for each database, instaling it inside a new folder, like initdb -D
/postgresql/datadb1/........... 
initdb -D /postgresql/datadb2/ and so on....! Then i think I can initialize each database one by one, and in the same
waystop and restart them. 
  Is it a good idea or not??? Is there a better way to do what I want ???





=====================
Rodrigo Sakai
Database Administrator
rodrigo@2bfree.com.br
http://www.2bfree.com.br
Tel:  (55) (11) 5083-5577
Fax: (55) (11) 5549-3598
=====================


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

Предыдущее
От: "Peter Galbavy"
Дата:
Сообщение: Re: hanging for 30sec when checkpointing
Следующее
От: Russell Shaw
Дата:
Сообщение: Debian "dump" problem