postgresql

Je databazovy server spusteny?

1. Nainstaluj postgresql (sudo apt-get install postgresql-8.2)

2. Pri instalacii by ti spravne malo vytvorit ucet postgres ale nema nastavene heslo takze sa nanho neda prihlasit. Takze pouzi su (sudo su postgres):

dvh@ubuntu:~$ sudo su postgres
Password: (sem heslo pre roota)
postgres@ubuntu:/home/dvh$ cd
postgres@ubuntu:~$ pwd
/var/lib/postgresql
postgres@ubuntu:~$ 

3. spusti psql a vytvor databazu "prva" a uzivatela "dvh" a umozni mu pripojenie do databazy "prva":

postgres@ubuntu:~$ psql
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=# create database prva;
CREATE DATABASE
postgres=# create user dvh;
CREATE ROLE
postgres=# grant all on database prva to dvh;
GRANT
postgres=# \q
postgres@ubuntu:~$ 

4. Odhlas uzivatela postgres, prihlas sa ako "dvh" do databazy "prva" a vytvor tabulku "osob", a vloz tam par viet a potom ich pre kontrolu vyselektuj.

postgres@ubuntu:~$ exit
dvh@ubuntu:~$ psql prva
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

prva=> create table osob (i_osob serial, n_meno char(30), n_priezv char(40));
POZNÁMKA:  CREATE TABLE vytvorí implicitnú sekvenciu "osob_i_osob_seq" pre sériový stĺpec "osob.i_osob"
CREATE TABLE
prva=> insert into osob values (default, 'Janko', 'Hrasko');
INSERT 0 1
prva=> insert into osob values (default, 'Ferko', 'Mrkvicka');
INSERT 0 1
prva=> insert into osob values (default, 'Janko', 'Mrkvicka');
INSERT 0 1
prva=> select * from osob;
 i_osob |             n_meno             |                 n_priezv                 
--------+--------------------------------+------------------------------------------
      1 | Janko                          | Hrasko                                  
      2 | Ferko                          | Mrkvicka                                
      3 | Janko                          | Mrkvicka                                
(3 rows)

prva=> \q

5. Prestuduj pg_hba.conf (je tam taka vec ako kto sa moze pripojit do databazy atd), postgresql.conf, dokumentaciu k postgres atd, este mozno vyuzijes tieto prikazy:

postgres@ubuntu:~$ initdb -D /var/pgsql/prva

alebo

postgres@ubuntu:~$ pg_ctl -D /var/pgsql/prva -l /var/pgsql/prva.log start

propadne (???)

postgres@ubuntu:~$ postmaster prva

Vela stastia.