Re: Probleme beim Installieren von Ogr: Inititalisierung von Postgres

Danke,

su - postgres

hilft.
(Ich habe hier ÃŒbrigens SuSE 8.2)

mfg,
Heinz-Josef Claes


Am Fre, 2003-07-11 um 08.18 schrieb [email protected]:
> 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.