Hello, I will explain how to install postgresql 12 on Centos 7. And how to create postgresql database is explained below.<\/p>\n
—————-postgresql single instace installations————————-<\/p>\n
repo package<\/p>\n
#yum install centos-release-scl-rh<\/p>\n
# yum install llvm-toolset-7-clang<\/p>\n
**********************************************************************************<\/p>\n
# yum install -y epel-release<\/p>\n
# yum install llvm5.0-devel<\/p>\n
**********************postgresql software installations**********************************<\/p>\n
yum install -y https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-7-x86_64\/pgdg-redhat-repo-latest.noarch.rpm<\/p>\n
yum install -y postgresql12-server postgresql12-client postgresql12-contrib postgresql12-devel<\/p>\n
<\/p>\n
mkdir \/postgres\/data
\nchown postgres:postgres \/postgres\/data<\/p>\n
passwd postgres
\npostgres
\npostgres<\/p>\n
******************************************************************************<\/p>\n
su – postgres<\/p>\n
vi .bash_profile<\/p>\n
# Get the aliases and functions
\nif [ -f ~\/.bashrc ]; then
\n. ~\/.bashrc
\nfi<\/p>\n
# User specific environment and startup programs<\/p>\n
PATH=$PATH:$HOME\/.local\/bin:$HOME\/bin:$PATH:\/usr\/pgsql-12\/bin\/
\nexport PGDATA=\/postgres\/data
\nexport PGUSER=postgres
\nexport PGDATABASE=postgres
\nexport PGPORT=5432
\nexport PGLOCALDIR=\/usr\/pgsql-12\/share\/locale
\nexport PATH<\/p>\n
******************************************************************************<\/p>\n
initdb -D \/postgres\/data<\/p>\n
pg_ctl status
\npg_ctl stop
\npg_ctl start<\/p>\n
<\/p>\n
# DB Version: 12
\n# OS Type: linux
\n# DB Type: web
\n# Total Memory (RAM): 32 GB
\n# CPUs num: 4
\n# Connections num: 500
\n# Data Storage: hdd<\/p>\n
listen_addresses = ‘*’
\nport = 5432
\nmax_connections = 500
\nshared_buffers = 8GB
\neffective_cache_size = 24GB
\nmaintenance_work_mem = 2GB
\ncheckpoint_completion_target = 0.7
\nwal_buffers = 16MB
\ndefault_statistics_target = 100
\nrandom_page_cost = 4
\neffective_io_concurrency = 2
\nwork_mem = 8388kB
\nmin_wal_size = 1GB
\nmax_wal_size = 4GB
\nmax_worker_processes = 4
\nmax_parallel_workers_per_gather = 2
\nmax_parallel_workers = 4
\nmax_parallel_maintenance_workers = 2<\/p>\n
pg_ctl restart<\/p>\n
\/postgres\/data\/pg_hba.conf<\/p>\n
host all all **************** md5
\nhost all all **************** md5
\nhost all all **************** md5<\/p>\n
pg_ctl reload<\/p>\n
psql<\/p>\n
CREATE DATABASE tayfun ENCODING=’UTF-8′ LC_COLLATE = ‘tr_TR.UTF-8′ LC_CTYPE=’tr_TR.UTF-8’ TEMPLATE template0;<\/p>\n
CREATE ROLE testuser PASSWORD ‘testuser123!’ SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;<\/p>\n
grant connect on database tayfun to testuser with grant option;<\/p>\n
alter database tayfun owner to testuser ;<\/p>\n","protected":false},"excerpt":{"rendered":"
Hello, I will explain how to install postgresql 12 on Centos 7. And how to create postgresql database is explained below. —————-postgresql single instace installations————————- repo package #yum install centos-release-scl-rh # yum install llvm-toolset-7-clang ********************************************************************************** # yum install -y epel-release # yum install llvm5.0-devel **********************postgresql software installations********************************** yum install -y https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-7-x86_64\/pgdg-redhat-repo-latest.noarch.rpm yum install -y postgresql12-server …<\/p>\n","protected":false},"author":36,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3896],"tags":[2606],"class_list":["post-34663","post","type-post","status-publish","format-standard","","category-postgresql","tag-postgresql"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/34663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/36"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=34663"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/34663\/revisions"}],"predecessor-version":[{"id":34665,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/34663\/revisions\/34665"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=34663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=34663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=34663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}