Rural Hunter escribió:
> 2. Since db1 is a very large database(it is the main db the user is
> using) I can not afford to take long time to vacuum full on that. So
> I thought about to try on other small dbs first.
>
> 3. I stop the instance.
>
> 4. I use "echo 'vacuum full;' | postgres --single
On Sat, Sep 14, 2013 at 6:05 PM, Rural Hunter wrote:
> 于 2013/9/15 1:06, Kevin Grittner 写道:
>
>> Rural Hunter wrote:
>>
>> Why in the world would you want to use VACUUM FULL in this circumstance?
>> the db name in the error message wrong?
>>
> I just googled around and found the solution. What's
于 2013/9/15 1:06, Kevin Grittner 写道:
Rural Hunter wrote:
Why in the world would you want to use VACUUM FULL in this circumstance?
the db name in the error message wrong?
I just googled around and found the solution. What's the other option?
There are two possibilities -- either you had a long
You should consider using the cleanup command in your recovery.conf file,
this will make sure that wal files no longer needed by the secondary server
are eliminated.
If you need the wal files for PITR, yo could also setup your archive
command to rchive the wal files to two different locations. a s
Rural Hunter wrote:
> Let me put here the whole scenario:
> 1. I was called by our application users that all the updating was
> failing. So I went to check the db. Any update transaction including
> manual vacuum is blocked out by the error message:
> ERROR: database is not accepting commands to
On Sat, Sep 14, 2013 at 11:19 AM, Keith Ouellette <
keith.ouelle...@airgas.com> wrote:
> My company is using PostgreSQL 9.1 for one of our applications. We have
> it set up replicating between two sites using WAL and Pacemaker to manage
> the cluster and failover. I have noticed that archive fold
My company is using PostgreSQL 9.1 for one of our applications. We have it set
up replicating between two sites using WAL and Pacemaker to manage the cluster
and failover. I have noticed that archive folder is growing very large 16G out
of the 19G that the data directory is in total. We have the