# HG changeset patch # User Oleksandr Gavenko # Date 1423762089 -7200 # Node ID d99b4a277679a44d8e0f9fca219adbd9bbdaf2be # Parent f24fa90e806b09fb7f2d172cc3fbb27f9baa7503 Installing on Debian. diff -r f24fa90e806b -r d99b4a277679 postgre.rst --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/postgre.rst Thu Feb 12 19:28:09 2015 +0200 @@ -0,0 +1,29 @@ +.. -*- coding: utf-8; -*- +.. include:: HEADER.rst + +========== + Postgre. +========== +.. contents:: + +Installing on Debian. +===================== + +Install and create new user and database:: + + $ sudo apt-get install postgresql postgresql-client + $ sudo su - postgres + postgres=# CREATE USER "mypguser" WITH PASSWORD 'mypguserpass'; + postgres=# CREATE DATABASE "mypgdatabase" OWNER "mypguser"; + postgres=# \q + +Connect as user ``mypguser`` to new database:: + + $ su - mypguser + $ psql mypgdatabase + +.. + + https://wiki.debian.org/PostgreSql + Debian wiki instructions. +