pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
backup and wal files
3+ messages / 3 participants
[nested] [flat]

* backup and wal files
@ 2005-12-14 09:57 f.guidi@libero.it <f.guidi@libero.it>
  2005-12-15 20:40 ` Re: backup and wal files Jim C. Nasby <jnasby@pervasive.com>
  0 siblings, 1 reply; 3+ messages in thread

From: f\.guidi\@libero\.it @ 2005-12-14 09:57 UTC (permalink / raw)
  To: pgsql-admin

Hello to all ...
I'm trying to install a backup system for my Postgresql 8.1.1 (on windows xp) using 3 wal files.

So i change these parameters in postgresql.conf
checkpoint_segments = 3
archive_command = 'copy "%p" "D:/PostgreSQL/backup/%f"'

I stop the database service and then restart it ...

Before restart i have 1 wal now i have 1 wal file ...

I start to generate data to populate wal files and postgres start to generate new wal files and copy them to the destination folder.

The problem is that files number don't stop to increase, now i have 10 wal files in pg_xlog and 9 files in backup folder ... 
why the backup files don't be deleted ?

thanks a lot in advance ...

Fabio




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

* Re: backup and wal files
  2005-12-14 09:57 backup and wal files f.guidi@libero.it <f.guidi@libero.it>
@ 2005-12-15 20:40 ` Jim C. Nasby <jnasby@pervasive.com>
  2005-12-21 23:29   ` Re: backup and wal files Simon Riggs <simon@2ndquadrant.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Jim C. Nasby @ 2005-12-15 20:40 UTC (permalink / raw)
  To: f.guidi@libero.it <f.guidi@libero.it>; +Cc: pgsql-admin

I haven't played with PITR, but I believe that if PostgreSQL doesn't get
the right return code from the archive_command it will keep the WAL
files around; maybe that's the problem.

On Wed, Dec 14, 2005 at 10:57:38AM +0100, f.guidi@libero.it wrote:
> Hello to all ...
> I'm trying to install a backup system for my Postgresql 8.1.1 (on windows xp) using 3 wal files.
> 
> So i change these parameters in postgresql.conf
> checkpoint_segments = 3
> archive_command = 'copy "%p" "D:/PostgreSQL/backup/%f"'
> 
> I stop the database service and then restart it ...
> 
> Before restart i have 1 wal now i have 1 wal file ...
> 
> I start to generate data to populate wal files and postgres start to generate new wal files and copy them to the destination folder.
> 
> The problem is that files number don't stop to increase, now i have 10 wal files in pg_xlog and 9 files in backup folder ...
> why the backup files don't be deleted ?
> 
> thanks a lot in advance ...
> 
> Fabio
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 

-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



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

* Re: backup and wal files
  2005-12-14 09:57 backup and wal files f.guidi@libero.it <f.guidi@libero.it>
  2005-12-15 20:40 ` Re: backup and wal files Jim C. Nasby <jnasby@pervasive.com>
@ 2005-12-21 23:29   ` Simon Riggs <simon@2ndquadrant.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Simon Riggs @ 2005-12-21 23:29 UTC (permalink / raw)
  To: Jim C. Nasby <jnasby@pervasive.com>; +Cc: f.guidi@libero.it <f.guidi@libero.it>; pgsql-admin

On Thu, 2005-12-15 at 14:40 -0600, Jim C. Nasby wrote:
> I haven't played with PITR, but I believe that if PostgreSQL doesn't get
> the right return code from the archive_command it will keep the WAL
> files around; maybe that's the problem.
> 
> On Wed, Dec 14, 2005 at 10:57:38AM +0100, f.guidi@libero.it wrote:
> > Hello to all ...
> > I'm trying to install a backup system for my Postgresql 8.1.1 (on windows xp) using 3 wal files.
> > 
> > So i change these parameters in postgresql.conf
> > checkpoint_segments = 3
> > archive_command = 'copy "%p" "D:/PostgreSQL/backup/%f"'
> > 
> > I stop the database service and then restart it ...
> > 
> > Before restart i have 1 wal now i have 1 wal file ...
> > 
> > I start to generate data to populate wal files and postgres start to generate new wal files and copy them to the destination folder.
> > 
> > The problem is that files number don't stop to increase, now i have 10 wal files in pg_xlog and 9 files in backup folder ...
> > why the backup files don't be deleted ?
> > 
> > thanks a lot in advance ...
> > 

Take a look in the PGDATA/pg_xlog/archive_status directory.

If the files all say ".ready" then your archive_command is not working
correctly for some reason.

Try running it manually to copy one of the files away.

Best Regards, Simon Riggs




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


end of thread, other threads:[~2005-12-21 23:29 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-14 09:57 backup and wal files f.guidi@libero.it <f.guidi@libero.it>
2005-12-15 20:40 ` Jim C. Nasby <jnasby@pervasive.com>
2005-12-21 23:29   ` Simon Riggs <simon@2ndquadrant.com>

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