pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedbackup 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>
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-15 20:40 Jim C. Nasby <jnasby@pervasive.com>
parent: f.guidi@libero.it <f.guidi@libero.it>
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-21 23:29 Simon Riggs <simon@2ndquadrant.com>
parent: Jim C. Nasby <jnasby@pervasive.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