pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gerd Terlutter <gerd@MplusB.de>
To: Tran Anh Tu <trantu@vnu.edu.vn>
Cc: pgsql-php@postgresql.org
Subject: Help MMMEEE
Date: Fri, 12 Sep 2003 09:38:59 +0200
Message-ID: <3F617813.5030606@MplusB.de> (raw)
References: <WorldClient-F200309120740.AA40201555@vnu.edu.vn>
	<3F616FC5.8010805@MplusB.de>
	<WorldClient-F200309121427.AA27441630@vnu.edu.vn>

Tran Anh Tu wrote:

....
> When I start postgresql by the command:
>    /etc/init.d/postgresql start
> then I type with user root:
>    createdb demo 
> Have a error message:
>    user "root" does not exist
> What does this mean? please help me, thank you very much.

After install PG and run it, you have to su postgres, and then
..$createuser xxxx
password: xxxx
best you choose your 'normal'user-account (name), pw can be another. 
This PG-user has root-privilege on PG. Then you can adduser or create 
DBs as normal user. To start/stop PG, use
root# /etc/init.d/postgresql [start/stop/restart...]

>>Tran Anh Tu wrote:
>>
>>>But when I stop it and switch to user: postgres, and start it with 
>>>command: postmaster -i then it does not working because It don't know
>>>where the database is placed. A error message:
>>>
>>>postmaster does not know where to find the database system data.
>>>Please help me!
>>
>>tran@tux$su -
>>password:xxx
>>root#su postgres
>>tux:/root$ whoami
>>postgres
>>tux:/root$ cd
>>tux$pwd
>>/var/lib/postgres
>>tux$ls -al
>>does this help?
>>
>>greetings,
>>Gerd


-- 
--------------------------------------------------------
# Gerd Terlutter        | Mueller+Blanck Software GmbH #
# gerd@MplusB.de        | Gutenbergring 38             #
# gerd.terlutter@web.de | D-22848 Noderstedt           #
# tel:0171/6992579      | tel:+49 40 500 171-1         #
# Buero:040/500171-17   | fax:+49 40 500 171-71        #
--------------------------------------------------------





Message-ID: <3F617813.5030606@MplusB.de>
Permalink:  ../3F617813.5030606@MplusB.de/
Also on:    postgresql.org/message-id/3F617813.5030606@MplusB.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: gerd@MplusB.de, trantu@vnu.edu.vn
  Subject: Re: Help MMMEEE
  In-Reply-To: <3F617813.5030606@MplusB.de>
  References: <WorldClient-F200309120740.AA40201555@vnu.edu.vn> <3F616FC5.8010805@MplusB.de> <WorldClient-F200309121427.AA27441630@vnu.edu.vn> <3F617813.5030606@MplusB.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox