[GENERAL] How to avoid Force Autovacuum

Hi All, We have one production database server , having 6 DBs, Postgres 9.2.1 version. This is my vacuum settings in Production database #autovacuum = on# Enable autovacuum subprocess? 'on' # requires track_counts to also be on. lo

Re: [GENERAL] How to avoid Force Autovacuum

eze analyze everyday. We are using Centos cat /etc/issue CentOS release 6.3 (Final) cat /proc/meminfo |grep Hugepagesize Hugepagesize: 2048 kB On Thu, Aug 8, 2013 at 6:59 AM, Sergey Konoplev wrote: > On Wed, Aug 7, 2013 at 2:46 AM, Vishalakshi Navaneethakrishnan > wrote: > > Da

Re: [GENERAL] How to avoid Force Autovacuum

/redhat_transparent_hugepage/defrag [always] never On Thu, Aug 8, 2013 at 10:57 AM, Sergey Konoplev wrote: > On Wed, Aug 7, 2013 at 9:32 PM, Vishalakshi Navaneethakrishnan > wrote: > > cat /etc/issue > > CentOS release 6.3 (Final) > > > > cat /proc/meminfo |grep Hugepagesize &

Re: [GENERAL] How to avoid Force Autovacuum

Hi All, select * from pg_database where datname = 'template0'; -[ RECORD 1 ]-+ datname | template0 datdba| 10 encoding | 6 datcollate| en_US.UTF-8 datctype | en_US.UTF-8 datistemplate | t datallowconn | f datconnlimit | -1 datlastsy

Re: [GENERAL] How to avoid Force Autovacuum

Kevin Grittner wrote: > > Vishalakshi Navaneethakrishnan wrote: > > > >> select * from pg_database where datname = 'template0'; > >> -[ RECORD 1 ]-+ > >> datname | template0 > >> datdba| 10 >

[GENERAL] Hot standby 9.2.1 PANIC: WAL contains references to invalid pages

Hi Team, For last 2 days we are facing issue with replication. WARNING: page 21 of relation base/1193555/19384612 does not exist CONTEXT: xlog redo insert: rel 1663/1193555/19384612; tid 21/1 PANIC: WAL contains references to invalid pages CONTEXT: xlog redo insert: rel 1663/1193555/19384612;

[GENERAL] Postgres DB Migration from 8.3 to 9.1

Hi Friends, We have our production environment database server in Postgres 8.3 version. we have planned to upgrade to lastest version 9.1. Dump from 8.3 and restore in Postgres 9.1 takes more than 5 hours. Any other quick method to upgrade from 8.3 to 9.1. We need to reduce our downtime below 1

Re: [GENERAL] Postgres DB Migration from 8.3 to 9.1

i found pg_upgrade binary missing in bin directoy. How can i get this ? Thanks in Advance. On Sat, Oct 13, 2012 at 3:37 AM, Scott Marlowe wrote: > On Thu, Oct 11, 2012 at 8:15 PM, Vishalakshi Navaneethakrishnan > wrote: > > Hi Friends, > > > > We have our production env

[GENERAL] Postgres Login Users Details

Hi all, I need to know who are all access database from different remote host. Example : User1@host1 logged / access db dbuser@dbname in Dbserver How can i get this information? Thanks in advance.. -- Best Regards, Vishalakshi.N

Re: [GENERAL] Postgres Login Users Details

PM, Vishalakshi Navaneethakrishnan > wrote: > > Hi all, > > > > I need to know who are all access database from different remote host. > > > > Example : > > > > User1@host1 logged / access db dbuser@dbname in Dbserver > > > > How can i get this inform

[GENERAL] Postgresql - 8.3 Replication in windows

Hi all, Can you please tell me , how to set up replication in win7, without slony tool.. -- Best Regards, Vishalakshi.N

[GENERAL] Postgres Index

Hi all, Can we create composite index for one text column and integer column? Thanks in advance.. -- Best Regards, Vishalakshi.N