Zen

Source string Source string

12/10000 · 12

The string is read only.

English Actions
PostgreSQL
Jiyoung Joung; niko d; Héctor H. Louzao P
Users of Fedora Server Edition find additional information in xref:fedora-server::services/setup-postgresql.adoc[Setting up PostgreSQL Database Server]
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…

User avatar None

Source string added

  1. fedora-docs-l10n/quick-docs
  2. master/pages/postgresql
  3. English
Installation
4 years ago
Browse all string changes

Things to check

Multiple failing checks

Following checks are failing:
Inconsistent: French, Czech, Spanish, Chinese (Simplified), Italian

Reset

Glossary

English English
No related strings found in the glossary.

String information

Source string description
type: Title ==
Flags
no-wrap, read-only
Source string location
./pages/postgresql.adoc:14
String age
4 years ago
Last updated
10 months ago
Source string age
4 years ago
Translation file
pot/master/pages/postgresql.pot, string 4