English logga in

Start

Data­baser

(Denna sida finns bara på engelska.)

postgresql

There is documentation under /usr/share/doc/postgresql-*. Its web pages are here.

To be able to create and access databases in postgresql you need to have a postgresql user. Ask admin about this when needed!

When you have a user who has the right to create databases in postgresql you can do that with createdb. It can be convenient to use a name of the database that is the same as your username to avoid name collisions. Also that is the default for psql when telling it which database to connect to.

You can run psql on any computer that is part of the CLUU system to access the same postgresql databases. The environment variable PGHOST tells which server to use.