Postgre Server stopped during continuous run.
am 21.06.2010 12:52:33 von vishnu.sThis is a multi-part message in MIME format.
------_=_NextPart_001_01CB112F.DBB9487A
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Hi,
=20
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.
=20
=20
=20
=20
Thanks & Regards,
Vishnu S
***** Confidentiality Statement/Disclaimer *****=20
This message and any attachments is intended for the sole use of the inte=
nded recipient. It may contain confidential information. Any unauthorized=
use, dissemination or modification is strictly prohibited. If you are no=
t the intended recipient, please notify the sender immediately then delet=
e it from all your systems, and do not copy, use or print. Internet commu=
nications 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 confir=
mation of the contents, please contact the company/sender. The company/se=
nder is not liable for any errors or omissions in the content of this mes=
sage.
------_=_NextPart_001_01CB112F.DBB9487A
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
rd" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D=
"http://www.w3.org/TR/REC-html40">
>
Hi,
I am new in PostgreSQL database.
I have a continuous running application that uses Po=
stgreSQL
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 i=
n the
disc. My issue is that , after a two days continuous run the Postgres ser=
ver
stopped unexpectedly . Can you explain what is the reason behind th=
is.?
How can we recover from this. How can we use Postgres database effectivel=
y 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 t=
he
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, disseminat=
ion or modification is strictly prohibited. If you are not the intended r=
ecipient, please notify the sender immediately then delete it from all yo=
ur systems, and do not copy, use or print. Internet communications are no=
t secure and it is the responsibility of the recipient to make sure that =
it is virus/malicious code exempt.
The company/sender cannot be respon=
sible for any unauthorized alterations or modifications made to the conte=
nts. If you require any form of confirmation of the contents, please cont=
act the company/sender. The company/sender is not liable for any errors o=
r omissions in the content of this message.
------_=_NextPart_001_01CB112F.DBB9487A--