Postgresql on SUSE

= Install = 1. Install it: yast -i postgresql-server 2. Start it: /etc/init.d/postgresql start

= Creating a new database = [...] postgresql-8.4.5-0.3.1                       Thu 30 Dec 2010 11:48:30 PM CET postgresql-server-8.4.5-0.3.1                Thu 30 Dec 2010 11:48:43 PM CET [...] /usr/bin/createdb /usr/bin/createlang /usr/bin/createuser /usr/bin/dropdb /usr/bin/droplang /usr/bin/dropuser /usr/bin/pg_dump [...] CREATE DATABASE test WITH TEMPLATE = template0 OWNER = postgres; \connect test
 * find out what software we could use
 * 1) rpm -qa --last | tac
 * 1) rpm -ql postgresql
 * let's try createdb
 * 1) createdb test
 * Proof the database test exists:
 * 1) pg_dumpall | grep test

= See also =
 * Distro specific tips & tricks
 * SuSE
 * PostgreSQL