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,
pgsql-admin by date
|Next:||From: Gaetano Mendola||Date: 2004-08-27 08:40:15|
|Subject: Re: backups and WAL|
|Previous:||From: Cris Carampa||Date: 2004-08-27 06:43:56|
|Subject: Compatibility between different versions of psql client and postgresql