pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How can I restore from WAL log? [PG 7.3]
3+ messages / 3 participants
[nested] [flat]

* How can I restore from WAL log? [PG 7.3]
@ 2006-09-28 14:16 Chan Michael <michael_kychan@yahoo.com.hk>
  2006-09-28 18:58 ` Re: How can I restore from WAL log? [PG 7.3] Jim C. Nasby <jim@nasby.net>
  2006-09-29 21:03 ` Re: How can I restore from WAL log? [PG 7.3] Bruno Wolff III <bruno@wolff.to>
  0 siblings, 2 replies; 3+ messages in thread

From: Chan Michael @ 2006-09-28 14:16 UTC (permalink / raw)
  To: pgsql-admin

Hi,

I am new to PostgreSQL and now want to know how can I recover from a database crash.

I know pg_dump and pg_restore but with pg_dump all transactions between every pg_dump will be lost. I found WAL in the doc and seems with it I can archieve point-in-time recovery. But I don't know the exact steps of doing this.

Any input, link or tutorials will be greatly appreciated.

Thanks in advance.

Michael
 _______________________________________
 YM - Â÷½u°T®§
 ´Nºâ§A¨S¦³¤Wºô¡A§AªºªB¤Í¤´¥i¥H¯d¤U°T®§µ¹§A¡A·í§A¤Wºô®É´N¯à¥ß§Y¬Ý¨ì¡A¥ô¦ó»¡¸Ü³£ÉN¨«¥¢¡C
 http://messenger.yahoo.com.hk

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: How can I restore from WAL log? [PG 7.3]
  2006-09-28 14:16 How can I restore from WAL log? [PG 7.3] Chan Michael <michael_kychan@yahoo.com.hk>
@ 2006-09-28 18:58 ` Jim C. Nasby <jim@nasby.net>
  1 sibling, 0 replies; 3+ messages in thread

From: Jim C. Nasby @ 2006-09-28 18:58 UTC (permalink / raw)
  To: Chan Michael <michael_kychan@yahoo.com.hk>; +Cc: pgsql-admin

On Thu, Sep 28, 2006 at 10:16:19PM +0800, Chan Michael wrote:
> Hi,
> 
> I am new to PostgreSQL and now want to know how can I recover from a database crash.
> 
> I know pg_dump and pg_restore but with pg_dump all transactions between every pg_dump will be lost. I found WAL in the doc and seems with it I can archieve point-in-time recovery. But I don't know the exact steps of doing this.

Point in Time Recovery wasn't added until version 8.0.
-- 
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: How can I restore from WAL log? [PG 7.3]
  2006-09-28 14:16 How can I restore from WAL log? [PG 7.3] Chan Michael <michael_kychan@yahoo.com.hk>
@ 2006-09-29 21:03 ` Bruno Wolff III <bruno@wolff.to>
  1 sibling, 0 replies; 3+ messages in thread

From: Bruno Wolff III @ 2006-09-29 21:03 UTC (permalink / raw)
  To: Chan Michael <michael_kychan@yahoo.com.hk>; +Cc: pgsql-admin

On Thu, Sep 28, 2006 at 22:16:19 +0800,
  Chan Michael <michael_kychan@yahoo.com.hk> wrote:
> Hi,
> 
> I am new to PostgreSQL and now want to know how can I recover from a database crash.

If you are just talking about the server dying unexpectedly, you recover
by restarting it. Doing this should recover all transactions.

Note that if your hard drives a lying to you about write completion, this
might not work.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-09-29 21:03 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-28 14:16 How can I restore from WAL log? [PG 7.3] Chan Michael <michael_kychan@yahoo.com.hk>
2006-09-28 18:58 ` Jim C. Nasby <jim@nasby.net>
2006-09-29 21:03 ` Bruno Wolff III <bruno@wolff.to>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox