wal logging

Поиск
Список
Период
Сортировка
Искать

wal logging

От:
Kailash Vyas <kailash.vyas@gmail.com>
Дата:
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

Re: wal logging

От:
thomas.revell@powerconv.alstom.com
Дата:
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.

Re: wal logging

От:
Kailash Vyas <kailash.vyas@gmail.com>
Дата:
thanks for the info.
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

Re: wal logging

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Kailash Vyas  writes:
> what is the utility of WAL logging in postgres 7.3

Crash protection.

			regards, tom lane

Re: wal logging

От:
Kailash Vyas <kailash.vyas@gmail.com>
Дата:
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

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

Re: wal logging

От:
hubert depesz lubaczewski <depesz@gmail.com>
Дата:
On 6/17/05, Kailash Vyas  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

Re: wal logging

От:
Bruno Wolff III <bruno@wolff.to>
Дата:
On Fri, Jun 17, 2005 at 14:09:53 +0100,
  Kailash Vyas  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.
FAQ