Обсуждение: Please help

Поиск
Список
Период
Сортировка

Please help

От
Daulat Ram
Дата:

 

Hello team,

 

I need help how  & what we can monitor the Postgres database via Nagios.

 

I came to know about the check_postgres.pl script but we are using free ware option of postgres. If its Ok with freeware then please let me know the steps how I can implement in our environment.

 

Regards,

Daulat

 

Re: Please help

От
Andreas Kretschmer
Дата:

Am 23.02.2018 um 20:31 schrieb Daulat Ram:
>
> Hello team,
>
> I need help how  & what we can monitor the Postgres database via Nagios.
>
> I came to know about the check_postgres.pl script but we are using 
> free ware option of postgres. If its Ok with freeware then please let 
> me know the steps how I can implement in our environment.
>
>

you can use check_postgres from https://bucardo.org/. Please read: 
https://bucardo.org/check_postgres/check_postgres.pl.html#license_and_copyright

Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



Re: Please help

От
PropAAS DBA
Дата:

Have you looked at the Nagios XI & Core packages?

https://www.nagios.com/solutions/postgres-monitoring/





On 02/23/2018 12:31 PM, Daulat Ram wrote:

 

Hello team,

 

I need help how  & what we can monitor the Postgres database via Nagios.

 

I came to know about the check_postgres.pl script but we are using free ware option of postgres. If its Ok with freeware then please let me know the steps how I can implement in our environment.

 

Regards,

Daulat

 


Please help

От
Daulat Ram
Дата:

Dear Experts,

 

Kndly help to resolve the issue reported during startup pgadmin4 server mode on ubuntu 16.04

 

dram@vipgadmin:~$ cd .pgadmin4

dram@vipgadmin:~/.pgadmin4$ chmod +x  lib/python2.7/site-packages/pgadmin4/pgAdmin4.py

dram@vipgadmin:~/.pgadmin4$ chmod 7777 lib/python2.7/site-packages/pgadmin4/pgAdmin4.py

dram@vipgadmin:~/.pgadmin4$ chmod -R 7777 lib/python2.7/site-packages/pgadmin4/pgAdmin4.py

dram@vipgadmin:~/.pgadmin4$ sudo systemctl daemon-reload

dram@vipgadmin:~/.pgadmin4$  sudo systemctl enable pgadmin4

dram@vipgadmin:~/.pgadmin4$ sudo systemctl start pgadmin4

dram@vipgadmin:~/.pgadmin4$ sudo systemctl status  pgadmin4

● pgadmin4.service - Pgadmin4 Service

   Loaded: loaded (/etc/systemd/system/pgadmin4.service; enabled; vendor preset: enabled)

   Active: failed (Result: exit-code) since Mon 2018-03-05 23:57:24 PST; 10s ago

  Process: 14190 ExecStart=/root/.pgadmin4/lib/python2.7/site-packages/pgadmin4/pgAdmin4.py (code=exited, status=200/CHDIR)

Main PID: 14190 (code=exited, status=200/CHDIR)

 

Mar 05 23:57:24 vipgadmin systemd[1]: Started Pgadmin4 Service.

Mar 05 23:57:24 vipgadmin systemd[1]: pgadmin4.service: Main process exited, code=exited, status=200/CHDIR

Mar 05 23:57:24 vipgadmin systemd[1]: pgadmin4.service: Unit entered failed state.

Mar 05 23:57:24 vipgadmin systemd[1]: pgadmin4.service: Failed with result 'exit-code'.

 

Regards,

Daulat

 

 

Re: Please help

От
Tomas Vondra
Дата:
Can you please use separate threads for your questions? That is, don't
start new thread by responding to an existing message (because the new
message then points using "References" header, which is what e-mail
clients use to group messages into threads). And use a proper subject
describing the issue ("Please help" tells people nothing).

That being said, how is this related to performance at all? It seems to
be about pgadmin, so please send it to pgadmin-support I guess.

regards

On 03/06/2018 09:01 AM, Daulat Ram wrote:
> Dear Experts,
> 
>  
> 
> Kndly help to resolve the issue reported during startup pgadmin4 server
> mode on ubuntu 16.04
> 
>  
> 
> dram@vipgadmin:~$ cd .pgadmin4
> 
> dram@vipgadmin:~/.pgadmin4$ chmod +x 
> lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
> 
> dram@vipgadmin:~/.pgadmin4$ chmod 7777
> lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
> 
> dram@vipgadmin:~/.pgadmin4$ chmod -R 7777
> lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
> 
> dram@vipgadmin:~/.pgadmin4$ sudo systemctl daemon-reload
> 
> dram@vipgadmin:~/.pgadmin4$  sudo systemctl enable pgadmin4
> 
> dram@vipgadmin:~/.pgadmin4$ sudo systemctl start pgadmin4
> 
> dram@vipgadmin:~/.pgadmin4$ sudo systemctl status  pgadmin4
> 
> ● pgadmin4.service - Pgadmin4 Service
> 
>    Loaded: loaded (/etc/systemd/system/pgadmin4.service; enabled; vendor
> preset: enabled)
> 
>    Active: failed (Result: exit-code) since Mon 2018-03-05 23:57:24 PST;
> 10s ago
> 
>   Process: 14190
> ExecStart=/root/.pgadmin4/lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
> (code=exited, status=200/CHDIR)
> 
> Main PID: 14190 (code=exited, status=200/CHDIR)
> 
>  
> 
> Mar 05 23:57:24 vipgadmin systemd[1]: Started Pgadmin4 Service.
> 
> Mar 05 23:57:24 vipgadmin systemd[1]: pgadmin4.service: Main process
> exited, code=exited, status=200/CHDIR
> 
> Mar 05 23:57:24 vipgadmin systemd[1]: pgadmin4.service: Unit entered
> failed state.
> 
> Mar 05 23:57:24 vipgadmin systemd[1]: pgadmin4.service: Failed with
> result 'exit-code'.
> 
>  
> 
> Regards,
> 
> Daulat
> 
>  
> 
>  
> 

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services