akp geek wrote:
> thank you so much for all the inputs.. One final question is , Do we have to
> stop the database when we
> create the base backup?
No, see
http://www.postgresql.org/docs/9.0/static/continuous-archiving.html#BACKUP-BASE-BACKUP
Yours,
Laurenz Albe
--
Sent via pgsql-general mai
thank you so much for all the inputs.. One final question is , Do we have
to stop the database when we create the base backup?
Regards
On Wed, Dec 5, 2012 at 4:45 PM, Tom Lane wrote:
> akp geek writes:
> > thank you all. There is a mistake I did then. I created a base backup
> when
> > I sta
akp geek writes:
> thank you all. There is a mistake I did then. I created a base backup when
> I started the DB , that was exactly an year ago. I need to do that again
> and then delete the old files.
Yeah, you should be making new base backups a lot more frequently than
that, probably. Conside
thank you all. There is a mistake I did then. I created a base backup when
I started the DB , that was exactly an year ago. I need to do that again
and then delete the old files.
Regards
On Wed, Dec 5, 2012 at 4:25 PM, Tom Lane wrote:
> akp geek writes:
> > WAL archives is growing, not the
akp geek writes:
> WAL archives is growing, not the files in pg_xlog.
You need to prune the archives of files that are too old to be
interesting. This doesn't happen automatically since PG has no
idea what your archiving requirements are.
Be sure to keep WAL files at least back to the start o
WAL archives is growing, not the files in pg_xlog.
Regards
On Wed, Dec 5, 2012 at 3:38 PM, Albe Laurenz wrote:
> akp geek wrote:
> > We have postgres 9.0.4 since an year. Replication also set up and works
> fine.
> > On the master. The wal files are growing and it's almost gone to 90% of
>
akp geek wrote:
> We have postgres 9.0.4 since an year. Replication also set up and works fine.
> On the master. The wal files are growing and it's almost gone to 90% of the
>disk.
> How can I handle the situation. Can I delete the old files. Please advice
Are the WAL files (the ones in pg_xlo
akp geek wrote:
> We have postgres 9.0.4 since an year. Replication also set up and
> works fine. On the master. The wal files are growing and it's
> almost gone to 90% of the disk. How can I handle the situation.
> Can I delete the old files. Please advice
Replicating how? Are these WAL files in
