Pgsql DB User Function fix (find who's calling it)
€30-250 EUR
Teslim sırasında ödenir
I'm having issues with a specific user function in my Pgsql ( postgresql 8.4) database that needs fixing.
After transferring server and DB from real PC to the VM, all works except new server doesn't show statistics.
We found the problem source (most possibly) is stats update function in DB.
Found by adding "track_functions = pl" to /etc/postgresql/8.4/main/[login to view URL]
So old server has:
datacenter_new=# SELECT * FROM pg_stat_user_functions;
funcid | schemaname | funcname | calls | total_time | self_time
----------+------------+-----------------------+-------+------------+----------- 32645236 | ADMIN | _get_news_url | 44 | 43244836 | ADMIN | _util_update_stat_new | 27 | 1365 | 1365
32645239 | ADMIN | _util_update_stat | 27 | 37511 | 37511
calls
And new doesn't have any calls of _util_update_stat at all which makes Stats table empty
You need to track why is this happening & fix it.
Server is a bunch of [login to view URL] scripts, but seems it doesn't matter cause all scripts just READ this stats table (i guess)
Pgsql expirience is a must Perl expirience is a plus.
Plz no "manager" bids, don't waste your time, will talk with developers only. (if you are a "manager" it will be seen after the 2nd tech question Plz don't waste OUR time!!!!)
Thank you!
p.s. max budget is 100.
Proje NO: #38046025
Proje hakkında
Seçilen:
Hi there, i have experience in pgsql and Linux administration. I can check why stats are not being enabled in your new server for pgsql. Need root login details to troubleshoot the problem. Thank you
Bu iş için 15 freelancer ortalamada €142 teklif veriyor
My name is Muhammad Abdullah, an experienced IT professional with a strong grasp on Linux, making me well-versed in PostgreSQL. Given your project's specific need of fixing a user function and rectifying statistics iss Daha Fazla
Dear sir, I'm knowledgeable in PostgreSql, and Perl programming language. I can help to fix the issue is related to the pg_stat_user_functions view not showing any calls for the _util_update_stat function on the new s Daha Fazla
As an expert in PostgreSQL and Linux, I am confident in my ability to address the issues you're experiencing with your Pgsql user function. With a strong background in database management and optimization, I am well-ve Daha Fazla
Hi there, ★★★ Database Design & Development Expert ★★★ 7+ Years of Experience ★★★ I've read requirements and ready to work on your project. I have completed multiple projects across various domains like Manufacturing, Daha Fazla
Hello, I have experience of developing management system of custom Linux using perl with PostgreSQL. I can help you to resolve your issue. With six years of experience in Linux and network engineering, I believe I will Daha Fazla
★★★ Hi, there ★★★ I understand what exactly you need and I can start work on the spot. I'm a professional fullstack developer who has great experience in the PostgreSQL and MySQL fields. I can handle your task in no ti Daha Fazla
I have more than 14 years of IT experience with various database technologies. Working Knowledge of Oralce,postgres Databases. Strong experience in Oracle to postgres migration Strong Oralce Development Skills worki Daha Fazla
Experience in postgres and perl 15+ years experience in IT, Networks, and Software Development Cisco CCIE R&S, IP/MPLS, VOIP, IPTV, SDN/NFV, LTE/5G Core Networks Python, C/C++, Golang, Erlang, Java, DevOPs, GitlabCI, Daha Fazla