Postgre Server stopped during continuous run.

Поиск
Список
Период
Сортировка
От Vishnu S.
Тема Postgre Server stopped during continuous run.
Дата
Msg-id 452E41849DBD7344A59685AE42A3F3F2549266@mail-4.tvm.nestgroup.net
обсуждение исходный текст
Ответы Re: Postgre Server stopped during continuous run.  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Re: Postgre Server stopped during continuous run.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin

Hi,

 

I am  new in PostgreSQL database.

I have a continuous running application that uses PostgreSQL as database. This application inserts about 20 MB data into the database in every second.I have disabled the WAL log , because all the data inserting into the database is logged in the WAL files, that  takes so much space in the disc. My issue is that , after a two days continuous run the Postgres server stopped unexpectedly . Can you  explain what is the reason behind this.? How can we recover from this. How can we use Postgres database effectively in a continuous running application. Can we specify the maximum  size of WAL file that can be stored in the database.On reaching the specified limit the older log files can be deleted automatically.

 

 

 

 

Thanks & Regards,

Vishnu S

***** Confidentiality Statement/Disclaimer *****

This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt.
The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.

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

Предыдущее
От: Elior Soliman
Дата:
Сообщение: High availability with Postgres
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: Postgre Server stopped during continuous run.