Re: Probleme beim Installieren von Ogr: Inititalisierung von Postgres

Am Freitag, 11. Juli 2003 07:42 schrieb Heinz-Josef Claes:

> # createdb ogo
> psql: FATAL:  user "root" does not exist
> createdb: database creation failed

dann bist du zZ user "root". User root exisitert aber offensichtlich nicht in 
deiner standart postgresql version. 
Readme deiner postgresql-installation lesen!

Bei Debian ist folgendes:

Creating users
==============

PostgreSQL has its own list of users, who have no necessary connection
with any particular machine's Unix users.

When PostgreSQL is first installed, only one user exists -- 'postgres',
and the default security settings means that that user can only be accessed
from the Unix login 'postgres'.  'postgres' is the PostgreSQL "superuser",
in that it can do anything inside PostgreSQL, just as root can do anything
in Unix.

The Unix user 'postgres' is created as an account into which you cannot
log directly; you must use "su - postgres" from a superuser session.  If
you want people who are not Unix superusers to be able to log into the
Unix account 'postgres', you must assign a password to that account with
the command 'passwd postgres'.

To create other users, you must use either the createuser script from
Unix or the CREATE USER command inside PostgreSQL.

See the man pages:  createuser(1), create_user(7l)
------------------------------------------------------------------


mit anderen worten: 
$ su - postgres
$ createuser root
$ logout

ist natürlich eigentlich auch überflüssig weil du gleich als postgres auch die 
datenbank ogo anlegen kannst.

-- 
Liebe Grüße, Sven Schaffranneck

          ( [email protected] - http://www.inwg.de )
( Registered Linux User #281620 @ http://counter.li.org )


Genius, n.:
	A chemist who discovers a laundry additive that rhymes with "bright."