Skip site navigation (1) Skip section navigation (2)

backups and WAL

From: pablobarbachano(at)yahoo(dot)es
To: pgsql-admin(at)postgresql(dot)org
Subject: backups and WAL
Date: 2004-08-27 08:03:07
Message-ID: 20040827080307.GA7494@vayven.info (view raw or flat)
Thread:
Lists: pgsql-admin
Hi, first of all thanks for postgresql, it has never given a problem
and is performing great.

Now my question: my employer wants to do backups every 12 hours, and
save the logs evry 2 hours to... Can I simply save the logs 
(cp pg_xlog/* ...) or do I need something more elaborate?

Now in a restore situation ... I restore the database, and then what?
put the saved files back in the pg_xlog/ dir, then start postmaster
and magically all starts working? Am I correct or completely insane?
The documentation is not clear in that aspect...

Thanks in advance,
Pablo.

Responses

pgsql-admin by date

Next:From: Gaetano MendolaDate: 2004-08-27 08:40:15
Subject: Re: backups and WAL
Previous:From: Cris CarampaDate: 2004-08-27 06:43:56
Subject: Compatibility between different versions of psql client and postgresql server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group