{"id":2491,"date":"2022-06-01T09:52:48","date_gmt":"2022-03-12T05:40:04","guid":{"rendered":""},"modified":"2025-02-02T00:46:18","modified_gmt":"2025-02-01T23:46:18","slug":"how-to-install-postgresql-and-phppgadmin-on-fedora-34","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/how-to-install-postgresql-and-phppgadmin-on-fedora-34\/","title":{"rendered":"Linux VPS & VPS Windows Setup Guide | NetCloud24 PostgreSQL and phpPgAdmin on Fedora 34"},"content":{"rendered":"

\u00a0<\/p>\n<\/p>\n

\u00a0<\/h1>\n

PostgreSQL<\/strong> is a powerful, open-source relational database system. phpPgAdmin<\/strong> is a web-based administration tool for PostgreSQL. In this guide, we will walk you through the steps to install both PostgreSQL and phpPgAdmin on Fedora 34.<\/p>\n

Step 1: Update Your System<\/h2>\n

Start by ensuring your system is up to date:<\/p>\n

sudo dnf update -y<\/code><\/pre>\n
Step 2: Install PostgreSQL<\/h2>\n
Install PostgreSQL using the following command:<\/p>\n
sudo dnf install postgresql-server postgresql-contrib -y<\/code><\/pre>\n
Initialize the PostgreSQL database:<\/p>\n
sudo postgresql-setup --initdb<\/code><\/pre>\n
Start and enable PostgreSQL:<\/p>\n
sudo systemctl start postgresql\r\nsudo systemctl enable postgresql<\/code><\/pre>\n
Step 3: Configure PostgreSQL<\/h2>\n
To allow remote access, edit the PostgreSQL configuration file:<\/p>\n
sudo nano \/var\/lib\/pgsql\/data\/postgresql.conf<\/code><\/pre>\n
Find and change the line:<\/p>\n
listen_addresses = 'localhost'<\/code><\/pre>\n
to:<\/p>\n
listen_addresses = '*'<\/code><\/pre>\n
Next, modify the pg_hba.conf<\/code> file to allow remote connections:<\/p>\n
sudo nano \/var\/lib\/pgsql\/data\/pg_hba.conf<\/code><\/pre>\n
Add the following line to allow access for all users:<\/p>\n
host    all             all             0.0.0.0\/0               md5<\/code><\/pre>\n
Step 4: Install phpPgAdmin<\/h2>\n
Install phpPgAdmin using the following command:<\/p>\n
sudo dnf install phppgadmin -y<\/code><\/pre>\n
Configure your web server to serve phpPgAdmin:<\/p>\n
sudo nano \/etc\/httpd\/conf.d\/phppgadmin.conf<\/code><\/pre>\n
Update the configuration as needed, ensuring you allow access from your desired IP range.<\/p>\n
Step 5: Start and Enable the Web Server<\/h2>\n
If you’re using Apache, start and enable it:<\/p>\n
sudo systemctl start httpd\r\nsudo systemctl enable httpd<\/code><\/pre>\n
Step 6: Access phpPgAdmin<\/h2>\n
Open your web browser and navigate to:<\/p>\n
http:\/\/your_server_ip\/phppgadmin<\/code><\/pre>\n
You should now see the phpPgAdmin login page.<\/p>\n
Conclusion<\/h2>\n
You have successfully installed PostgreSQL and phpPgAdmin on Fedora 34. This powerful combination allows you to manage your PostgreSQL databases easily through a web interface.<\/p>\n
If you’re looking for a reliable hosting solution for your PostgreSQL applications, consider using . With Windows VPS<\/strong>, you can efficiently host your applications and ensure high performance. Whether you need  or Windows VPSVirtual Private Servers<\/strong>, you’ll find a solution that fits your requirements.<\/p>\n
For larger deployments or enterprise needs, explore <a href=”https:\/\/ie.netcloud24.com” target<\/p>\n
\n
Author:<\/strong> \u0141ukasz Bodziony<\/p>\n
Website:<\/strong> Windows VPS<\/a><\/p>\n
\u0141ukasz Bodziony is the CEO and founder of NETCLOUD24<\/a>, a global VPS hosting brand proudly originating from Poland. With extensive experience in cloud computing, virtualization, and server management, he delivers high-performance Windows VPS<\/strong> and Remote Desktop Services (RDS)<\/strong> solutions to clients across Europe, North America, and beyond.<\/em><\/p>\n
His expertise covers a wide range of technologies, including Microsoft Azure<\/strong>, Proxmox VE<\/strong>, Amazon Web Services (AWS)<\/strong>, and numerous other virtualization and cloud platforms.<\/em><\/p>\n
Beyond running his hosting business, \u0141ukasz also provides professional paid server configuration and optimization services<\/strong> for companies and individuals. Outside of work, he is dedicated to caring for his children and building a secure future for them.<\/em><\/p>\n
If you are interested in working with him or need expert assistance with your hosting, cloud environment, or server setup, feel free to reach out via Windows VPS<\/a>.<\/em><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"
\u00a0 \u00a0 PostgreSQL is a powerful, open-source relational database system. phpPgAdmin is a web-based administration tool for PostgreSQL. In this guide, we will walk you through the steps\u2026<\/p>\n","protected":false},"author":1,"featured_media":3421,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[],"tags":[14,12,11,23,20,21,22,17,7,8,6,10,18,19,15,24,16,5,13,9],"class_list":["post-2491","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-cheapvps","tag-cloudvps","tag-hostingvps","tag-rds","tag-rdscal","tag-remotedesktop","tag-remotedesktopvps","tag-servervps","tag-ukvps","tag-virtualserver","tag-vpshosting","tag-vpsserver","tag-vpssolutions","tag-vpswindows","tag-vpswithwindows","tag-windowsrds","tag-windowsserver","tag-windowsvps","tag-windowsvpshosting","tag-windowsvpsuk"],"jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/2491","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=2491"}],"version-history":[{"count":0,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/2491\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media\/3421"}],"wp:attachment":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=2491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=2491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=2491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}