fedora-docs-l10n/quick-docs/master/pages/postgresql — Chinese (Simplified) @ Fedora Weblate: Installation

	English	Chinese (Simplified)	Actions
	PostgreSQL
	Installation	安装
	The installation and initialization of the postgresql server is a little bit different in comparison to other packages and other Linux distros. This document aims to summarize basic installation steps relevant to recent Fedora Linux releases.
	sudo dnf install postgresql-server postgresql-contrib
	The postgresql server is not running and disabled by default. To set it to start at boot, run:
	sudo systemctl enable postgresql
	The database needs to be populated with initial data after installation. The database initialization could be done using following command. It creates the configuration files postgresql.conf and pg_hba.conf
	sudo postgresql-setup --initdb --unit postgresql
	To start the postgresql server manually, run
	sudo systemctl start postgresql
	User Creation and Database Creation
	Now you need to create a user and database for the user. This needs to be run from a `postgres` user account on your system.
	sudo -u postgres psql
	From here you can create a postgres user and database. Here, we will assume your computer's user account is called `lenny`. Note: you can also run this from the shell as well with `createuser lenny` and `createdb --owner=lenny carl`.
	postgres=# CREATE USER lenny WITH PASSWORD 'leonard'; postgres=# CREATE DATABASE my_project OWNER lenny;
	It might be good idea to add password for the `postgres` user while you're at it:
	postgres=# \password postgres

Loading…

None Suggestion removed during cleanup fedora-docs-l10n/quick-docs master/pages/postgresql Chinese (Simplified)	English Installation Chinese (Simplified) 2 characters edited Current translation 安装 a year ago
bobby285271 Translation added fedora-docs-l10n/quick-docs master/pages/postgresql Chinese (Simplified)	English Installation Chinese (Simplified) 2 characters edited Current translation Translated 安装 a year ago
bobby285271 Contributor joined fedora-docs-l10n/quick-docs master/pages/postgresql Chinese (Simplified)	Contributor joined a year ago
None Suggestion added fedora-docs-l10n/quick-docs master/pages/postgresql Chinese (Simplified)	English Installation Chinese (Simplified) 2 characters edited Current translation 安装 2 years ago