Re: [PERFORM] Check Pointer
Hi , Could you share the command, what you have used to confirm that, the checkpoint process is consuming 8GB. And also, please share the addition information like PostgreSQL version and the OS details. I am suspecting that, your shared_buffers value is 8GB, and the "top" command is showing the used memory as 8GB. Thanks. Dinesh -- *Dinesh Kumar* Software Engineer Ph: +918087463317 Skype ID: dinesh.kumar432 www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/> * Follow us on Twitter* @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and more <http://www.enterprisedb.com/resources-community> On Thu, May 30, 2013 at 5:39 PM, itishree sukla wrote: > Hi all, > > In our server Check pointer process is consuming 8 GB of memory, what > could be the possible reason? Can any one please help. > > Regards, > Itishree >
Re: [PERFORM] URGENT issue: pg-xlog growing on master!
> Hi, My pg_xlog dir has been growing rapidly the last 4 days, and my disk > is now almost full (1000Gb) even though the database is only 50Gb. I have a > streaming replication server running, and in the log of the slave it says: > > cp: cannot stat `/var/lib/postgresql/9.2/wals/00020E1B00A9': > No such file or directory > cp: cannot stat `/var/lib/postgresql/9.2/wals/00020E1B00A9': > No such file or directory > 2013-06-10 11:21:45 GMT FATAL: could not connect to the primary server: > could not connect to server: No route to host > Is the server running on host "192.168.0.4" and accepting > TCP/IP connections on port 5432? > > All the time. > > I have tried to restart the server, but that didn't help. I checked the > master, and the file /var/lib/postgresql/9.2/wals/00020E1B00A9 > does not exist! I'm pretty lost here, can someone help me solve this and > get my master server cleaned up. What is causing this, and what do I need > to do? > > IIRC, this kind of situation we may expect, when the archive command was failed at master side. Could you verify, how many files "00xxx.ready" reside under the master's pg_xlog/archive_status directory. And also, verify the master server's recent pg_log file, for finding the root cause of the master server down issue. Dinesh -- *Dinesh Kumar* Software Engineer Ph: +918087463317 Skype ID: dinesh.kumar432 www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/> * Follow us on Twitter* @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and more <http://www.enterprisedb.com/resources-community>
