{"id":2921,"date":"2024-03-05T20:03:49","date_gmt":"2024-03-05T17:03:49","guid":{"rendered":"https:\/\/dataera.co\/blog\/2024\/03\/05\/postgresql-kurulumu\/"},"modified":"2025-09-29T12:33:12","modified_gmt":"2025-09-29T09:33:12","slug":"postgresql-installation-on-linux","status":"publish","type":"post","link":"https:\/\/dataera.co\/en\/postgresql-installation-on-linux\/","title":{"rendered":"PostgreSQL Installation on Linux"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
In this article, we will examine the installation of PostgreSQL, which has attracted attention with its ability to handle large-scale data, has increased its market share in recent years, and is completely open-source, on Linux systems.<\/div>
We will perform the RPM-based installation for enterprise Linux-based systems such as RedHat\/CentOS\/Scientific. Additionally, we will compile and install it from generic source code.<\/div>
\u00a0<\/div>
Installation on RedHat<\/strong><\/div>
\u00a0<\/div>
yum install https:\/\/download.postgresql.org\/pub\/repos\/yum\/10\/redhat\/rhel-7-x86_64\/pgdg-redhat10-10-2.noarch.rpm\nyum install postgresql10\nyum install postgresql10-server<\/pre>
The following commands are executed to start Postgres and enable it to start automatically at boot.<\/div>
\u00a0<\/div>
\/usr\/pgsql-10\/bin\/postgresql-10-setup initdb\nsystemctl enable postgresql-10\nsystemctl start postgresql-10<\/pre>
Installation is complete; now we can connect.<\/div>
\u00a0<\/div>
The default port of PostgreSQL is 5432. Let’s check if it’s running.<\/div><\/div>
\u00a0<\/div>
[root@yesrib ~]# netstat -ntlp |grep 5432\ntcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 17795\/postmaster\ntcp6 0 0 :::5432 :::* LISTEN 17795\/postmaster\nsudo su - postgres\n-bash-4.2$ psql\npsql (10.3)\nType \"help\" for help.<\/pre>
[sql]postgres=# select version();<\/div>
\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014
PostgreSQL 10.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit
(1 row)[\/sql]<\/p>
Installation from Source Code<\/strong><\/div>
\u00a0<\/div><\/div>
yum install -y readline-devel libtermcap-devel zlib zlib-devel\ntar xvfz postgresql-9.6.6\ncd postgresql-9.6.6\n.\/configure<\/pre>
mkdir \/pg966<\/pre>
.\/configure --prefix=\/pg966<\/pre>
make (make -h 8 ###for 8 core parallizm)\nmake install<\/pre>
cd contrib\nmake\nmake install<\/pre>
mkdir \/pg966\/data\nchown postgres.postgres \/pg966\/data<\/pre>
su - postgres\ninitdb -D \/data -E unicode<\/pre><\/div>
Success. You can now start the database server using:<\/div>
\u00a0<\/div>
Stop\/Start<\/strong><\/div>
\u00a0<\/div>
pg_ctl -D \/usr\/local\/pgsql966\/data -l logfile start\npg_ctl stop<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"
In this article, we focus on PostgreSQL, a fully open-source database that stands out for its ability to handle large volumes of data and has been increasing its market share in recent years, on Linux … Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":2329,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[52],"tags":[],"class_list":["post-2921","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel-en"],"_links":{"self":[{"href":"https:\/\/dataera.co\/en\/wp-json\/wp\/v2\/posts\/2921"}],"collection":[{"href":"https:\/\/dataera.co\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dataera.co\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dataera.co\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dataera.co\/en\/wp-json\/wp\/v2\/comments?post=2921"}],"version-history":[{"count":8,"href":"https:\/\/dataera.co\/en\/wp-json\/wp\/v2\/posts\/2921\/revisions"}],"predecessor-version":[{"id":3035,"href":"https:\/\/dataera.co\/en\/wp-json\/wp\/v2\/posts\/2921\/revisions\/3035"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dataera.co\/en\/wp-json\/wp\/v2\/media\/2329"}],"wp:attachment":[{"href":"https:\/\/dataera.co\/en\/wp-json\/wp\/v2\/media?parent=2921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dataera.co\/en\/wp-json\/wp\/v2\/categories?post=2921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dataera.co\/en\/wp-json\/wp\/v2\/tags?post=2921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}