{"id":1369,"date":"2015-04-10T09:56:08","date_gmt":"2015-04-10T06:56:08","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1369"},"modified":"2015-04-12T22:11:21","modified_gmt":"2015-04-12T19:11:21","slug":"how-to-delete-psql-command-prompt-history-in-postgresql","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/how-to-delete-psql-command-prompt-history-in-postgresql\/","title":{"rendered":"How to Delete psql Command Prompt History in PostgreSQL"},"content":{"rendered":"<p>When you use psql command prompt, system automaticly saves your prompts. If you use password when user creates operation, this situation can occur security risk. Therefore, you can delete this prompts with editing psql_history file like below. <\/p>\n<p><strong>Find And Delete psql Prompts<\/strong><\/p>\n<blockquote><p>\n[root@pg ~]# locate .psql_history<br \/>\n\/var\/lib\/pgsql\/.psql_history<br \/>\n[root@pg ~]# vi \/var\/lib\/pgsql\/.psql_history\n<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>When you use psql command prompt, system automaticly saves your prompts. If you use password when user creates operation, this situation can occur security risk. Therefore, you can delete this prompts with editing psql_history file like below. Find And Delete psql Prompts [root@pg ~]# locate .psql_history \/var\/lib\/pgsql\/.psql_history [root@pg ~]# vi \/var\/lib\/pgsql\/.psql_history<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10],"tags":[93,88],"class_list":["post-1369","post","type-post","status-publish","format-standard","hentry","category-administration-postgresql","tag-postgresql","tag-postgresql-administration"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-m5","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1369"}],"version-history":[{"count":3,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1369\/revisions"}],"predecessor-version":[{"id":1373,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1369\/revisions\/1373"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1369"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}