Deprecated: Implicit conversion from float 1789176953.751962 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Creation of dynamic property IRP_HTMLContext::$isParentTable is deprecated in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/html/HTMLContext.php on line 53

Deprecated: Implicit conversion from float 1789176953.752149 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752183 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752211 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752233 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752255 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752276 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752297 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752319 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752339 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752381 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752417 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752439 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752476 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.75253 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752563 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752586 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752606 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752626 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752649 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752687 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752729 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752759 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752783 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752813 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752836 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752858 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752889 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752914 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752941 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752963 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.752988 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753016 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753044 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753064 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753083 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753102 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753122 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753145 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753165 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753186 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753204 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753225 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753269 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753301 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.753332 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.754161 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.75481 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1789176953.755105 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Halo teman teman kali ini saya akan membagikan bagaimana cara mensetting PostfreSQL dengan mudah dan Cepat pada system operasi Linux.

PostgreSQL, juga dikenal sebagai Postgres, adalah sistem manajemen basis data relasional sumber terbuka dan gratis yang menekankan ekstensibilitas dan kepatuhan SQL. Awalnya bernama POSTGRES, mengacu pada asal-usulnya sebagai penerus database Ingres yang dikembangkan di University of California, Berkeley.

Oke langsung saja kita masuk ke tutorial  untuk instalasi nya  

1. Install Postgresql

dnf module -y install postgresql:13

2. Start Service Postgresql

systemctl enable --now postgresql

3. Dengan pengaturan default, dimungkinkan untuk terhubung ke PostgreSQL Server hanya dari Localhost dengan otentikasi [peer]. Lihat situs resmi di bawah ini tentang detail metode otentikasi.

https://www.postgresql.jp/document/10/html/auth-pg-hba-conf.html

# listen only localhost by default
[root@myApp]# grep listen_addresses /var/lib/pgsql/data/postgresql.conf

#listen_addresses = 'localhost' # what IP address(es) to listen on;

# authentication methods by default
[root@myApp]# grep -v -E "^#|^$" /var/lib/pgsql/data/pg_hba.conf

local   all             all                                     peer
host    all             all             127.0.0.1/32            ident
host    all             all             ::1/128                 ident
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            ident
host    replication     all             ::1/128                 ident