Home Database Mysql Tutorial Fedora 17配置PostgreSQL自动启动

Fedora 17配置PostgreSQL自动启动

Jun 07, 2016 pm 05:20 PM
postgresql

使用Fedora包管理工具安装完Postgresql后,不管怎么折腾都无法随机器自动启动。今天花了点功夫仔细阅读了一些相关文件,终于找到

使用Fedora包管理工具安装完Postgresql后,不管怎么折腾都无法随机器自动启动。今天花了点功夫仔细阅读了一些相关文件,终于找到了解决的办法。其实也很简单。

根本原因是,我在安装完Postgresql后将数据库放到了/var/pgsql/data,而Postgresql默认的存放位置是/var/lib/pgsql/data。因而使用默认的安装配置无法找到数据库,所以启动失败。

在解决的过程中,最开始想通过自定义一个开机脚本来解决,可以网上的方案都有问题。根本原因是在Fedora15以后,使用Systemd替代了原来的init,因而网上的通过编写或修改rc脚本的方案不再可行。

在Systemd中,启动服务配置在/etc/systemd/system和/lib/systemd/system中。在/lib/systemd/system/postgresql.service 文件即是postgresql安装的默认服务配置文件。按照推荐的做法() 不应该直接修改此文件,而是应该复制到/etc/systemd/system,,然后修改之。

现在位置,改起来非常见到了:

sudo cp /lib/systemd/system/postgresql.service /etc/systemd/system

sudo servicectl enable postgresql.service #激活postgresql服务

用编辑器打开 /etc/systemd/system/postgresql.service,修改器PGDATA的设置为正确的路径(我的是/var/pgsql/data)

sudo systemctl --system daemon-reload

大功告成.

linux

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

MySQL and PostgreSQL: Best Practices in Web Development MySQL and PostgreSQL: Best Practices in Web Development Jul 14, 2023 pm 02:34 PM

MySQL and PostgreSQL: Best Practices in Web Development Introduction: In the modern world of web development, databases are an essential component. When choosing a database, common choices are MySQL and PostgreSQL. This article will cover best practices for using MySQL and PostgreSQL in web development and provide some code examples. 1. Applicable scenarios MySQL is suitable for most web applications, especially those that require high performance, scalability and ease of use.

MySQL and PostgreSQL: Performance comparison and optimization tips MySQL and PostgreSQL: Performance comparison and optimization tips Jul 13, 2023 pm 03:33 PM

MySQL and PostgreSQL: Performance Comparison and Optimization Tips When developing web applications, the database is an indispensable component. When choosing a database management system, MySQL and PostgreSQL are two common choices. They are both open source relational database management systems (RDBMS), but there are some differences in performance and optimization. This article will compare the performance of MySQL and PostgreSQL and provide some optimization tips. Performance comparison comparing two database management

MySQL and PostgreSQL: Data Security and Backup Strategies MySQL and PostgreSQL: Data Security and Backup Strategies Jul 13, 2023 pm 03:31 PM

MySQL and PostgreSQL: Data Security and Backup Strategies Introduction: In modern society, data has become an indispensable part of business and personal life. For database management systems, data security and backup strategies are crucial, both to protect data from loss or damage and to ensure the reliability and integrity of recovered data. This article will focus on the data security and backup strategies of two mainstream relational database systems, MySQL and PostgreSQL. 1. Data security: (1) User rights

Learn database functions in Go language and implement addition, deletion, modification and query operations of PostgreSQL data Learn database functions in Go language and implement addition, deletion, modification and query operations of PostgreSQL data Jul 31, 2023 pm 12:54 PM

Learn the database functions in the Go language and implement the addition, deletion, modification, and query operations of PostgreSQL data. In modern software development, the database is an indispensable part. As a powerful programming language, Go language provides a wealth of database operation functions and toolkits, which can easily implement addition, deletion, modification and query operations of the database. This article will introduce how to learn database functions in Go language and use PostgreSQL database for actual operations. Step 1: Install the database driver in Go language for each database

Using PostgreSQL in Go: The Complete Guide Using PostgreSQL in Go: The Complete Guide Jun 18, 2023 am 09:28 AM

Go language is a fast and efficient programming language suitable for building web services and back-end applications. PostgreSQL is an open source relational database management system that promises to provide higher reliability, scalability and data security. In this article, we’ll take a deep dive into using PostgreSQL with Go and provide some practical code examples and tips. Installing and setting up PostgreSQL First, we need to install and set up PostgreSQL. Can be found on the official website

How to use PostgreSQL database in PHP programming? How to use PostgreSQL database in PHP programming? Jun 12, 2023 am 09:27 AM

With the development of database technology, database management systems also present a variety of choices. Developers can choose the most suitable database according to their needs and preferences. As an advanced open source relational database system, PostgreSQL is attracting more and more attention and use by developers. So, how to use PostgreSQL database in PHP programming? 1. Install and configure the PostgreSQL database. Before using PostgreSQL, you need to install and configure it. first

PHP implements open source PostgreSQL relational database PHP implements open source PostgreSQL relational database Jun 18, 2023 am 08:40 AM

With the development of the Internet, the amount of data continues to grow, and the need for data management becomes increasingly urgent. Relational database is an important way of data management, among which PostgreSQL is popular for its flexibility, scalability and security. This article introduces how to use the PHP language to implement an open source PostgreSQL relational database. I hope it will be helpful to developers with corresponding needs. Overview PostgreSQL is a powerful relational database system that follows the SQL standard and has many

Database capacity planning and scaling: MySQL vs. PostgreSQL Database capacity planning and scaling: MySQL vs. PostgreSQL Jul 12, 2023 pm 01:43 PM

Database capacity planning and expansion: MySQL vs. PostgreSQL Introduction: With the rapid development of the Internet and the advent of the big data era, database capacity planning and expansion has become increasingly important. MySQL and PostgreSQL are two popular relational database management systems (RDBMS). They have different characteristics and applicable scenarios in database capacity planning and expansion. This article will compare the two databases and give some code examples to demonstrate their differences. 1. MySQ

See all articles