[GENERAL] PostgrSQL server : CPU and Memory

Hi , I am a developer and I want to monitor metrics related to CPU and Memory of PostgreSQL server only using SQL queries. Do we have any system tables which can give us the data? I have found this one https://aaronparecki.com/2015/02/19/8/monitoring-cpu-memory-usage-from-postgres but dont know

Re: [GENERAL] Fwd: Mail to be posted in PostgreSQL community

Hi Venkata, Thanks for prompt reply. OS user is administrator user. So, I don't know why there are issues. Can anyone suggest me steps to do the same? On 15-Nov-2016 2:26 pm, "Venkata B Nagothi" wrote: > > On Tue, Nov 15, 2016 at 4:15 PM, kaustubh kelkar > wrote: > &

Re: [GENERAL] Fwd: Creating multiple instances of postresql on Windows environment

Hi, The issue is not with server , it is running fine . Issue is not with port either , for local machine, I guess firewall won't affect. On Tue, Nov 8, 2016 at 8:14 PM, Adrian Klaver wrote: > On 11/07/2016 07:27 PM, kaustubh kelkar wrote: > >> >> Hi , >>

[GENERAL] Fwd: Mail to be posted in PostgreSQL community

Hi, Trying to create multiple database instances of PostgreSQL 9.6 In this case , trying to create 2nd instance with port 5434/5435. *1st attempt:* *Create new database cluster : * C:\Program Files\PostgreSQL\9.6\installer\server>initcluster.vbs postgres postgr es 12345 "C:\Program File

[GENERAL] Fwd: Creating multiple instances of postresql on Windows environment

Hi , I am a PostgreSQL user who wants to create multiple instances of PostgreSQL database server. I am using PostgreSQL 9.4 and above. I tried to create more than 2 instances on Linux environment in which I was successful. But, for windows environment, I tried with the help of pgAdmin4 and with t