Thread: Archiving WAL for 7.4.21
Dear All,
I've postgres 7.4.21 , is there is any way to archive WAL , I've tried to run =# select pg_switch_xlog();
ERROR: function pg_switch_xlog() does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
* What I know 7.4 is not supporting automatic archiving , so is there is any work around to switch WAL and copy the previous files to archive log, and what about restoration.
Thanks;
I've postgres 7.4.21 , is there is any way to archive WAL , I've tried to run =# select pg_switch_xlog();
ERROR: function pg_switch_xlog() does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
* What I know 7.4 is not supporting automatic archiving , so is there is any work around to switch WAL and copy the previous files to archive log, and what about restoration.
Thanks;
On Tue, Oct 28, 2008 at 02:25:05PM +0400, Mohd Alkhaldi wrote: > I've postgres 7.4.21 , is there is any way to archive WAL , I've tried No. A -- Andrew Sullivan ajs@commandprompt.com +1 503 667 4564 x104 http://www.commandprompt.com/
Mohd Alkhaldi escribió: > Dear All, > > I've postgres 7.4.21 , is there is any way to archive WAL , No. And even if you were to copy WAL logs by hand, it wouldn't work to restore them. You need to upgrade at least past 8.0. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.