Re: [ADMIN] Autovaccum failure with Postgres 8.3.14? (max-fsm_pages issue?)

2012-11-24 Thread Subhasis Bhattacharya
Thanks Craig, We have plans to upgrade to a later version of postgres, but that could take a while. Meantime, I wanted to understand whether the autovacuum failure could be linked to the fact that the stats collector could not update (rename) the pgstats file? Thanks and Regards, Subhasis On

[ADMIN] System / Global psqlrc file location

2012-11-24 Thread CS DBA
Hi all; where does the system psqlrc file live? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] System / Global psqlrc file location

2012-11-24 Thread Raghavendra
On Sun, Nov 25, 2012 at 12:35 AM, CS DBA wrote: > Hi all; > > where does the system psqlrc file live? > > Thanks in advance > > > Default is ~/.psqlrc. (postgres user) You can check the sample file under /opt/PostgreSQL/9.2/share/postgresql/psqlrc.sample. If you want to read from any different l