如何在Fedora Core中安装Postgresql

悠悠 2023-02-15 07:50 4阅读 0赞

在这里，我分享了我如何在fedora core中安装postgresql。 我花了一整天找出解决方案。 希望有帮助

1）首先，请获取PostgeSQL源代码n对其进行编译以进行安装或在fedora core中使用yum命令。

a）关于PostgeSQL源代码编译，请访问此处  
[http://www.mkyong.com/database/how-to-compile-postgresql-database-source-code-in-linux/][http_www.mkyong.com_database_how-to-compile-postgresql-database-source-code-in-linux]

b）关于Yum命令，更改为root并发出以下命令，它将连接到Internet并下载postgresql核心文件。

yum -y install postgresql postgresql-server php-pgsql

[![在Fedora-Step1中安装Postgres][Fedora-Step1_Postgres]][Fedora-Step1_Postgres_Fedora-Step1_Postgres][![在Fedora-Step1中安装Postgres][Fedora-Step1_Postgres 1]][Fedora-Step1_Postgres_Fedora-Step1_Postgres]

2）使用initdb -D / usr / local / pgsql / data命令创建数据库集群，在此之前，请创建/ usr / local / pgsql / data文件夹并分配“ postgres”用户拥有它。 “ postgres”是postgresql的默认用户。

mkdir /usr/local/pgsql/data
    chown postgres /usr/local/pgsql/data
    su - postgres
    initdb -D /usr/local/pgsql/data

[![在Fedora-Step2中安装Postgres][Fedora-Step2_Postgres]][Fedora-Step2_Postgres_Fedora-Step2_Postgres][![在Fedora-Step2中安装Postgres][Fedora-Step2_Postgres 1]][Fedora-Step2_Postgres_Fedora-Step2_Postgres]

3）启动postgresql服务器

pg_ctl /usr/local/pgsql/data -l -logfile start

如果要停止postgres服务器，请发出以下命令。

pg_ctl /usr/local/pgsql/data -l -logfile stop

4）创建数据库

createdb new_db

5）使用psql访问

psql new_db

6）发出一个选择版本（）； 命令，如果它显示postgresql版本，则意味着您已经在fedora中成功安装了postgresql。

[![在Fedora-Step3中安装Postgres][Fedora-Step3_Postgres]][Fedora-Step3_Postgres][![在Fedora-Step3中安装Postgres][Fedora-Step3_Postgres 1]][Fedora-Step3_Postgres]

标签： [fedora][] [postgresql][]

> 翻译自: [https://mkyong.com/database/how-to-install-postgresql-in-fedora-core/][https_mkyong.com_database_how-to-install-postgresql-in-fedora-core]

[http_www.mkyong.com_database_how-to-compile-postgresql-database-source-code-in-linux]: http://www.mkyong.com/database/how-to-compile-postgresql-database-source-code-in-linux/
[Fedora-Step1_Postgres]: http://imgconvert.csdnimg.cn/aHR0cDovL3d3dy5ta3lvbmcuY29tL3dwLWNvbnRlbnQvdXBsb2Fkcy8yMDA4LzA2L2luc3RhbGwtcG9zdGdyZXMtaW4tZmVkb3JhLXN0ZXAxLkpQRw?x-oss-process=image/format,png
[Fedora-Step1_Postgres_Fedora-Step1_Postgres]: http://www.mkyong.com/wp-content/uploads/2008/06/install-postgres-in-fedora-step1.JPG
[Fedora-Step1_Postgres 1]: http://imgconvert.csdnimg.cn/aHR0cHM6Ly93d3cubWt5b25nLmNvbS93cC1jb250ZW50L3VwbG9hZHMvMjAwOC8wNi9pbnN0YWxsLXBvc3RncmVzLWluLWZlZG9yYS1zdGVwMS5KUEc?x-oss-process=image/format,png
[Fedora-Step2_Postgres]: http://imgconvert.csdnimg.cn/aHR0cDovL3d3dy5ta3lvbmcuY29tL3dwLWNvbnRlbnQvdXBsb2Fkcy8yMDA4LzA2L2luc3RhbGwtcG9zdGdyZXMtaW4tZmVkb3JhLXN0ZXAyLkpQRw?x-oss-process=image/format,png
[Fedora-Step2_Postgres_Fedora-Step2_Postgres]: http://www.mkyong.com/wp-content/uploads/2008/06/install-postgres-in-fedora-step2.JPG
[Fedora-Step2_Postgres 1]: http://imgconvert.csdnimg.cn/aHR0cHM6Ly93d3cubWt5b25nLmNvbS93cC1jb250ZW50L3VwbG9hZHMvMjAwOC8wNi9pbnN0YWxsLXBvc3RncmVzLWluLWZlZG9yYS1zdGVwMi5KUEc?x-oss-process=image/format,png
[Fedora-Step3_Postgres]: http://www.mkyong.com/wp-content/uploads/2008/06/install-postgres-in-fedora-step3.JPG
[Fedora-Step3_Postgres 1]: http://imgconvert.csdnimg.cn/aHR0cHM6Ly93d3cubWt5b25nLmNvbS93cC1jb250ZW50L3VwbG9hZHMvMjAwOC8wNi9pbnN0YWxsLXBvc3RncmVzLWluLWZlZG9yYS1zdGVwMy5KUEc?x-oss-process=image/format,png
[fedora]: https://mkyong.com/tag/fedora/
[postgresql]: https://mkyong.com/tag/postgresql/
[https_mkyong.com_database_how-to-install-postgresql-in-fedora-core]: https://mkyong.com/database/how-to-install-postgresql-in-fedora-core/