hi there
I lightly read this
http://www.postgresql.org/docs/8.1/static/backup-online.html
and am interested in creating an incremental backup of
WAL files, but my database is small so each of this
WAL files must be almost identical to the previous
one.
Is there a way to incrementally backup so t
lready taken a base or level 0 backup).
>
> On Monday 12 February 2007 13:42, pedro noticioso
> wrote:
> > hi there
> >
> > I lightly read this
> >
>
http://www.postgresql.org/docs/8.1/static/backup-online.html
> >
> > and am interested in creating
rtain amount of time that you can configure on
> postgresql.conf. So you can
> store WAL files, say, every 30 or 60 minutes,
> regardless of how big it is.
> This way maybe the DB speed won't be seriuosly
> affected.
>
> Small question, though. How are you taking
by setting an appropiate
> > archive_command in your
> > postgresql.conf (probably something copying the
> WAL
> > files somewhere you store
> > them). You MUST restart postgres after changing
> this
> > file.
> >
> > About the WAL file size: sorry, i don
Muchas gracia a todos los queme han respondido hasta
ahora
Thanks to all who have repplied so far
Ok entonces regreso y reinicio al procedimiento
completo para tratar de atinarle a lo que puede ser el
problema.
Ok so I go back and retry the complete procedure to
try to pin point what might be the
d at 2007-02-16
10:10:27 CST
LOG: could not read from log file 0, segment 5 at
offset 2416640: No such file or directory
LOG: invalid checkpoint record
PANIC: could not locate required checkpoint record
HINT: If you are not restoring from a backup, try
removing the file
"/usr/local/pgsql/
007-02-16
10:10:27 CST
LOG: could not read from log file 0, segment 5 at
offset 2416640: No such file or directory
LOG: invalid checkpoint record
PANIC: could not locate required checkpoint record
HINT: If you are not restoring from a backup, try
removing the file
"/usr/local/pgsql/data/back