From LQWiki

Contents 1 Install 2 Post emerge config 3 Changing the users password 4 Creating a new database 5 See also

Install

1. Standard emerge:

   emerge postgresql

2. Ebuild config:

   ebuild /var/db/pkg/dev-db/postgresql.*.*.*/postgresql.*.*.*ebuild config
     [be sure to change *.*.* to whatever version you just emerged]

3. Start postgres:

   /etc/init.d/postgresql start

Post emerge config

You have to edit your shadow file, and add /bin/bash as the user postgres's shell.

I guess this must be /etc/passwd but it is done by emerge;

postgres:x:70:70::/var/lib/postgresql:/bin/bash

Changing the users password

passwd postgresql does not work.

Creating a new database

(todo)

In /usr/share/postgresql are the sample conf files.

running ebuild blabla config created the data dir::

 /var/lib/postgresql/data

and the relevant conf files are there noe. (is this correct?)

See also

• Distro specific tips & tricks
• Gentoo
• PostgreSQL

This article is a stub and needs to be finished. Plunge forward and help it grow!