Обсуждение: wal logging
hi
I have to setup some backup policies for our postgres server.
I had a few queries regarding corruption of database.
what are the steps to be followed in postgres regarding logical corruption, instance failures, block corruption, log corruption?
I am using postgres 7.3.9
I was checking out WAL logging. I enabled WAL logging in postgres.conf
I found the logs in the pg_xlog directory but don't know how to recover it
thanks,
kailash
I have to setup some backup policies for our postgres server.
I had a few queries regarding corruption of database.
what are the steps to be followed in postgres regarding logical corruption, instance failures, block corruption, log corruption?
I am using postgres 7.3.9
I was checking out WAL logging. I enabled WAL logging in postgres.conf
I found the logs in the pg_xlog directory but don't know how to recover it
thanks,
kailash
Database recovery from write ahead logs is only supported in PostgreSQL 8.0.0 and later. ----------------------------------------------------------------------- hi I have to setup some backup policies for our postgres server. I had a few queries regarding corruption of database. what are the steps to be followed in postgres regarding logical corruption, instance failures, block corruption, log corruption? I am using postgres 7.3.9 I was checking out WAL logging. I enabled WAL logging in postgres.conf I found the logs in the pg_xlog directory but don't know how to recover it thanks, kailash :.________________ CONFIDENTIALITY : This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium.
thanks for the info.
what is the utility of WAL logging in postgres 7.3
thanks,
kailash
what is the utility of WAL logging in postgres 7.3
thanks,
kailash
On 6/17/05, thomas.revell@powerconv.alstom.com < thomas.revell@powerconv.alstom.com> wrote:
Database recovery from write ahead logs is only supported in PostgreSQL
8.0.0 and later.
-----------------------------------------------------------------------
hi
I have to setup some backup policies for our postgres server.
I had a few queries regarding corruption of database.
what are the steps to be followed in postgres regarding logical
corruption, instance failures, block corruption, log corruption?
I am using postgres 7.3.9
I was checking out WAL logging. I enabled WAL logging in postgres.conf
I found the logs in the pg_xlog directory but don't know how to recover it
thanks,
kailash
:.________________
CONFIDENTIALITY : This e-mail and any attachments are confidential and
may be privileged. If you are not a named recipient, please notify the
sender immediately and do not disclose the contents to another person, use
it for any purpose or store or copy the information in any medium.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
Kailash Vyas <kailash.vyas@gmail.com> writes:
> what is the utility of WAL logging in postgres 7.3
Crash protection.
regards, tom lane
thanks tom for you prompt response.
can you give me more info into crash protection.
for example in case of database crash what would be the steps involved in recovering it through WAL.
thanks,
kailash
can you give me more info into crash protection.
for example in case of database crash what would be the steps involved in recovering it through WAL.
thanks,
kailash
On 6/17/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Kailash Vyas <kailash.vyas@gmail.com> writes:
> what is the utility of WAL logging in postgres 7.3
Crash protection.
regards, tom lane
On 6/17/05, Kailash Vyas <kailash.vyas@gmail.com> wrote: > for example in case of database crash what would be the steps involved in > recovering it through WAL. just restart the database. postgresql with recover itself using wal files. depesz
On Fri, Jun 17, 2005 at 14:09:53 +0100, Kailash Vyas <kailash.vyas@gmail.com> wrote: > thanks for the info. > what is the utility of WAL logging in postgres 7.3 It allows the postres to recover if the server crashes.