[ADMIN] How to remove conflicts when installing postgres where some other installation of postgres is already running using silent installer

2011-05-25 Thread Ashish Kumar Singh
Hi List, I have a requirement where we need to install postgres where some other installation of postgres is already running using silent installation mechanism of postgres. Many times we found issues where script/configuration file are pointing to old installation not the new one. Is

Re: [ADMIN] pg_class reltuples/relpages not updated by autovacuum/vacuum

2011-05-25 Thread Tom Lane
Florian Helmberger writes: > I think I've pinned the problem down to the values pg_class holds for > the affected TOAST table: > relpages | 433596 > reltuples | 1868538 > These values are significantly too low. Interestingly, the autovacuum > logout reports the correct values: > pages: 0

Re: [ADMIN] How to remove conflicts when installing postgres where some other installation of postgres is already running using silent installer

2011-05-25 Thread Marcelo Leite
Hello there... If you perform a fresh installation from source code, you can have a better control of that issue. Cheers, Marcelo Leite

Re: [ADMIN] Seems like a large amount of xlog files

2011-05-25 Thread Fujii Masao
CC to pgsql-admin@postgresql.org On Wed, May 25, 2011 at 5:10 PM, Michael Holt wrote: > archive_timeout is not set. The default is to have it off right? Yes. My another guess is that those many files were generated by initial data load and have remained up to now. No? Anyway, you can check whe