Thanks Kevin, this makes sense and could very well be the cause of the
issue. The oddity is that this activity seemed to occur right when there
was some code upgraded on the application, however since we can't
confirm it's the code causing this, it could just be a coincidence.
- Brian F
On 02
On Wed, Feb 22, 2012 at 7:08 PM, Philip Edelbrock
wrote:
> The question is, is there a way to keep availability of the app 100% yet keep
> the database maintained without the drive filling up? Or is it just the
> nature of the beast that a full vacuum needs to be done periodically?
Short answe
We're having a problem with database maintenance. If we do a full vacuum, it
takes down the app until it completes (which is a bit to be expected as a full
vacuum locked the app out of the database). However, if we don't do a periodic
full vacuum, our drive gets filled up.
The question is, i
Brian Fehrle wrote:
> I have a very active database that generates between 200 and 400
> WAL files that are archived for backups. Yesterday, the average
> number of WAL files being generated skyrocketed.
>
> We took a look at some WAL files using the strings command, and
> notice quite a bit of
Hi all,
I have a very active database that generates between 200 and 400 WAL
files that are archived for backups. Yesterday, the average number of
WAL files being generated skyrocketed.
We took a look at some WAL files using the strings command, and notice
quite a bit of data from a specific
Gera Mel Handumon wrote:
> constraints primary key and foreign key lost.
>
> The backup and restore procedure on the same server 64bit
> postgresql 9.1.2 running on Windows 2008.
>
> No error during backup and restore.
>
> What Happen?
There's not enough information in your post for anyone
Good Day!
constraints primary key and foreign key lost.
The backup and restore procedure on the same server 64bit postgresql
9.1.2 running on Windows 2008.
No error during backup and restore.
What Happen?
TIA
-
"Share your knowl