Обсуждение: online backup - v810 vs. v814
Hi, I do an online backup with v814 and v810. I've noticed that there is a file showing up in the PGDATA directory/pg_xlog/00000000010000251000000C2.0021CDDE.backup owned by postgres 284 bytes in size that shows up in v810. That file isn't showing up in v814. Is that by design? ~DjK psql -d somedb "SELECT pg_start_backup()
That looks to be a file hanging around from a previous PITR backup. That file should be in your xlog archive. cat the contents and you'll see which backup it belongs to. Andy. Mr. Dan wrote: > Hi, > > I do an online backup with v814 and v810. I've noticed that there is > a file showing up in the PGDATA > directory/pg_xlog/00000000010000251000000C2.0021CDDE.backup owned by > postgres 284 bytes in size that shows up in v810. That file isn't > showing up in v814. Is that by design? > > ~DjK > > > psql -d somedb "SELECT pg_start_backup() > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > !DSPAM:37,44cf7a71143292031717456! > >
Hey Andy, Sorry for the confusion. That file and the one in archive_status (*.backup.done) are from v810. I'm wondering why my PITR backup in v814 doesn't leave me with similiear files. Neither *.backup in pg_xlog or *.backup.done in archive_status shows up. I was wondering if that was by design or I have a problem. ~DjK >From: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk> >Reply-To: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk> >To: "Mr. Dan" <bitsandbytes88@hotmail.com> >CC: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] online backup - v810 vs. v814 >Date: Tue, 01 Aug 2006 17:05:45 +0100 > >That looks to be a file hanging around from a previous PITR backup. That >file should be in your xlog archive. > >cat the contents and you'll see which backup it belongs to. > >Andy. > >Mr. Dan wrote: >>Hi, >> >>I do an online backup with v814 and v810. I've noticed that there is a >>file showing up in the PGDATA >>directory/pg_xlog/00000000010000251000000C2.0021CDDE.backup owned by >>postgres 284 bytes in size that shows up in v810. That file isn't >>showing up in v814. Is that by design? >> >>~DjK >> >> >>psql -d somedb "SELECT pg_start_backup() >> >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 3: Have you checked our extensive FAQ? >> >> http://www.postgresql.org/docs/faq >> >>!DSPAM:37,44cf7a71143292031717456! >> >> >
hi mr d, yes i would say you have a problem with the 8.1.4's archive-command - sorry most of my keyboard keys have stopped working so i can't use capitals or punctuation lol. check your latest logs on the 8.1.4 server for errors in archiving that file. when you've done a backup, that .backup file should be archived with the archive-command, the same as the normal wal logs - the .backup.done file is not written because postgres couldn't archive the file for some reason - check your logs is about the best i can advise. sorry for the amateurish email - i'm off to replace my keyboard andy. Mr. Dan wrote: > Hey Andy, > > Sorry for the confusion. That file and the one in archive_status > (*.backup.done) are from v810. I'm wondering why my PITR backup in > v814 doesn't leave me with similiear files. Neither *.backup in > pg_xlog or *.backup.done in archive_status shows up. I was wondering > if that was by design or I have a problem. > > ~DjK > > > > > >> From: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk> >> Reply-To: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk> >> To: "Mr. Dan" <bitsandbytes88@hotmail.com> >> CC: pgsql-admin@postgresql.org >> Subject: Re: [ADMIN] online backup - v810 vs. v814 >> Date: Tue, 01 Aug 2006 17:05:45 +0100 >> >> That looks to be a file hanging around from a previous PITR backup. >> That file should be in your xlog archive. >> >> cat the contents and you'll see which backup it belongs to. >> >> Andy. >> >> Mr. Dan wrote: >>> Hi, >>> >>> I do an online backup with v814 and v810. I've noticed that there >>> is a file showing up in the PGDATA >>> directory/pg_xlog/00000000010000251000000C2.0021CDDE.backup owned by >>> postgres 284 bytes in size that shows up in v810. That file isn't >>> showing up in v814. Is that by design? >>> >>> ~DjK >>> >>> >>> psql -d somedb "SELECT pg_start_backup() >>> >>> >>> >>> ---------------------------(end of >>> broadcast)--------------------------- >>> TIP 3: Have you checked our extensive FAQ? >>> >>> http://www.postgresql.org/docs/faq >>> >>> >>> >>> >> > > > > !DSPAM:37,44cf9118143292966821177! > >