{"id":1957,"date":"2015-01-06T20:53:03","date_gmt":"2015-01-06T18:53:03","guid":{"rendered":"http:\/\/www.profelis.com.tr\/tr\/blog\/?p=1957"},"modified":"2023-02-01T10:58:13","modified_gmt":"2023-02-01T07:58:13","slug":"postgresql-101-bagli-kullanicilar","status":"publish","type":"post","link":"https:\/\/profelis.com.tr\/en\/2015\/01\/06\/postgresql-101-bagli-kullanicilar\/","title":{"rendered":"PostgreSQL 101: Ba\u011fl\u0131 Kullan\u0131c\u0131lar"},"content":{"rendered":"<h2>PostgreSQL 101: Ba\u011fl\u0131 Kullan\u0131c\u0131lar<\/h2>\n<p>PostgreSQL sistem g\u00f6r\u00fcn\u00fcmlerinden birisi olan\u00a0<strong>pg_stat_activity<\/strong>\u00a0\u00e7al\u0131\u015fmakta olan t\u00fcm PostgreSQL arka plan i\u015flemlerinin bir listesini tutar. Bu i\u015flemlere hangi sorgular\u0131n \u00e7al\u0131\u015fmakta oldu\u011fu, ba\u011fl\u0131 olan kullan\u0131c\u0131lar ve ne zaman ba\u011fland\u0131klar\u0131, \u00e7al\u0131\u015fmakta olan i\u015flem (transaction) ve sorgular\u0131n ba\u015flang\u0131\u00e7 zaman\u0131 gibi bilgiler dahildir.<\/p>\n<p>Belirli bir kullan\u0131c\u0131n\u0131n PostgreSQL veritaban\u0131na ba\u011fl\u0131 olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in:<\/p>\n<div class=\"page\" title=\"Page 206\">\n<div class=\"layoutArea\">\n<div class=\"column\">\n<pre>SELECT dbname FROM pg_stat_activity WHERE usename = 'tolga';<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>E\u011fer bu sorgu bir sonu\u00e7 d\u00f6nd\u00fcr\u00fcyorsa, tolga kullan\u0131c\u0131s\u0131 sisteme ba\u011fl\u0131 demektir. dbname s\u00fctunu kar\u015f\u0131l\u0131\u011f\u0131 d\u00f6nen de\u011fer ise tolga kullan\u0131c\u0131s\u0131n\u0131n ba\u011fl\u0131 oldu\u011fu veritaban\u0131 veya veritabanlar\u0131n\u0131 g\u00f6sterir.<\/p>\n<h2>&#8220;Hangi bilgisayardan ba\u011fl\u0131lar?&#8221; sorusunun cevab\u0131n\u0131 ar\u0131yorsak<\/h2>\n<p>Genellikle, birden fazla s\u00fcre\u00e7 ayn\u0131 kullan\u0131c\u0131 ad\u0131 ile ayn\u0131 veritaban\u0131na ba\u011flanamkta olabilir. Bu durumda ba\u011flant\u0131lar\u0131n hangi uzak sistem \u00fczerinden yap\u0131ld\u0131\u011f\u0131n\u0131 bilmek isteyebilirsiniz. <strong>pg_stat_activity<\/strong> g\u00f6r\u00fcn\u00fcm\u00fc buna dair bilgileri de g\u00f6stermektedir. \u015e\u00f6yle ki, ba\u011fl\u0131 sistemin IP adresi ve ba\u011flant\u0131 portlar\u0131 bu g\u00f6r\u00fcn\u00fcmde yer al\u0131r. IP adresi ile ayn\u0131 kullan\u0131c\u0131 ad\u0131 ile ba\u011flan\u0131lan veritabanlar\u0131na kimin nereden bapland\u0131\u011f\u0131n\u0131 g\u00f6rebilirsiniz. Di\u011fer taraftan port numaralar\u0131 ayn\u0131 uzak istemciden ba\u011flanan ayn\u0131 adl\u0131 kullan\u0131c\u0131n\u0131n farkl\u0131 oturumlar\u0131n\u0131 g\u00f6sterir. Bu durumda a\u015fa\u011f\u0131daki sorgu:<\/p>\n<pre>SELECT dbname, username, client_addr, client_port FROM pg_stat_activity ;<\/pre>\n<p>client_addr ve client_port ilgili istemciyi ve portunu, hatta uzak makinadaki s\u00fcre\u00e7 numaras\u0131n\u0131 dahil g\u00f6sterebilir.<\/p>","protected":false},"excerpt":{"rendered":"<p>PostgreSQL sistem g\u00f6r\u00fcn\u00fcmlerinden birisi olan\u00a0pg_stat_activity\u00a0\u00e7al\u0131\u015fmakta olan t\u00fcm PostgreSQL arka plan i\u015flemlerinin bir listesini tutar. Bu i\u015flemlere hangi sorgular\u0131n \u00e7al\u0131\u015fmakta oldu\u011fu, ba\u011fl\u0131 olan kullan\u0131c\u0131lar ve ne zaman ba\u011fland\u0131klar\u0131, \u00e7al\u0131\u015fmakta olan transaction ve sorgular\u0131n ba\u015flang\u0131\u00e7 zaman\u0131 gibi bilgiler dahildir.<\/p>","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75,45],"tags":[48,60],"class_list":["post-1957","post","type-post","status-publish","format-standard","hentry","category-postgresql","category-yazi","tag-enterprisedb","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/1957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/comments?post=1957"}],"version-history":[{"count":0,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/1957\/revisions"}],"wp:attachment":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media?parent=1957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/categories?post=1957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/tags?post=1957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}