Postgres перші кроки.

#pkg_add -r postgresql82-server

Add to /etc/login.conf’


postgres:\
:lang=en_US.UTF-8:\
:setenv=LC_COLLATE=C:\
:tc=default:

#cap_mkdb /etc/login.conf

Then add ‘postgresql_class=”postgres”‘ to /etc/rc.conf.

and ‘postgresql_enable=”YES”‘ to /etc/rc.conf

#/usr/local/etc/rc.d/postgresql initdb
#/usr/local/etc/rc.d/postgresql start

Edit pg_hba.conf

#su pgsql
#createdb test
#psql -h localhost -U pgsql -d test
test=# \q

Видаляємо тестову базу.
#dropdb test

Comments are closed.