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@xxxxxxxxx | Gutenbergring 38 #
# gerd.terlutter@xxxxxx | D-22848 Noderstedt #
# tel:0171/6992579 | tel:+49 40 500 171-1 #
# Buero:040/500171-17 | fax:+49 40 500 171-71 #
--------------------------------------------------------
