Kevin Grittner pisze:
Ireneusz Pluta wrote:
Is there
any ready tool, which, for instance when given a path to database
cluster, would traverse all cluster directories and files and
check all page headers? I probably answered myself - manual VACUUM
[VERBOSE] would do - but it fails when
Tom Lane pisze:
Alvaro Herrera writes:
Yeah, maybe we should make it put the failed table at the end of the
list, for the next run. This is not simple to implement, if only
because autovac workers don't have any way to persist state from one run
to the next. But this kind of thing causes e
Hello,
I have a server, 8.4.3, where I get intermittent and rather rare cases
of "invalid page headers". Quick search over the pg lists shows a
general advice to "check your hardware". Yes, I need to schedule a
downtime and perform some checks.
However, let me also share with you what I noti
(b) How can I verify that my databases are being vacuumed by autovacuum?
pg_stat_user_tables should have a last_autovac column.
Also, you can see autovacuum related messages like:
DEBUG: autovacuum: processing database "postgres"
DEBUG: autovacuum: processing database "template1"
I had a problem with neverending forced autovacuum process, running as
preventing xid wraparound. As I finally (?) found, following some
advices given here: ->
http://forums.enterprisedb.com/posts/list/2028.page, that autovacuum in
question was not just one autovacuum, but many different autov
Sibte Abbas napisał(a):
On 6/20/07, Ireneusz Pluta <[EMAIL PROTECTED]> wrote:
Hello,
How can I make sure that autovacuum is running, beyond believing that
all autovacuum_ settings in
postgresql.conf are set correctly?
In the 8.1 I could see:
LOG: autovacuum: processing database &qu
some developers discussions about making changes to logging autovacuum activity, however
could not track the discussion tight enough to find what the final solution is.
Thanks
Ireneusz Pluta
---(end of broadcast)---
TIP 9: In versions below 8.0, the plan
Mondi Ravi napisał(a):
i can't find out command to show all databases,tables,users and
integrity constraints relationships;
yours sincerely
See tables and views of system catalogs:
http://www.postgresql.org/docs/8.2/interactive/catalogs.html
and use just SELECT statements on them to get what
Lukas napisał(a):
Hello,
we have one table in database (db has over 200 tables), which has one
byteA filed for storing user photos. We are making backup every night, but
it is now too large because of photos. We do not need to make backup of
photos every night, but the question is how to backup
Mike napisał(a):
Silly me - I installed 8.0 a year or so ago, and it is working just
fine. When I went to install 8.2, I can't remember the Windows NT
password I set up for the service account. I'm afraid if I change it
I'll bugger the 8.0 service. Has anybody encountered a similar
situation,
10 matches
Mail list logo
