[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
new installation help
- Subject: new installation help
- From: Joseph <..hidden..>
- Date: Mon, 10 Sep 2007 19:15:41 -0600
I'm trying to give it a try and create new installation (currently still
running sql-ledger).
MANUAL INSTALL
==============
1) Untar went OK :-)
Maybe I'm picky but it would be convenient to post complete set of
instruction on what use suppose to type; it makes easier for newbies.
eg.
# chown apache:apache -R /usr/local/ledgersmb
I can contribute installation instruction for "gentoo" but right now I
got stuck on point #2
2.) Create a postgresql admin database role, by convention named
'ledgersmb':
$ createuser --no-superuser --createdb --no-createrole -U postgres --pwprompt --encrypted ledgersmb
createuser: unrecognized option `--no-superuser'
createuser --help
createuser creates a new PostgreSQL user.
Usage:
createuser [OPTION]... [USERNAME]
Options:
-a, --adduser user can add new users
-A, --no-adduser user cannot add new users
-d, --createdb user can create new databases
-D, --no-createdb user cannot create databases
-P, --pwprompt assign a password to new user
-E, --encrypted encrypt stored password
-N, --unencrypted do not encrypt stored password
-i, --sysid=SYSID select sysid for new user
-e, --echo show the commands being sent to the server
-q, --quiet don't write any messages
--help show this help, then exit
--version output version information, then exit
Connection options:
-h, --host=HOSTNAME database server host or socket directory
-p, --port=PORT database server port
-U, --username=USERNAME user name to connect as (not the one to create)
-W, --password prompt for password to connect
Since I'm already running sql-ldeger I have user "postgres" on my
system, though I'm not sure about the rest of the command:
--pwprompt --encrypted ledgersmb
Apology for the basic questions but postresql is not something I do on
day to day basis, like most of us.
There is a second part:
If you prefer to work in postgresql's psql console, the equivalent SQL
statement to create the ledgersmb role is:
=> CREATE ROLE ledgersmb LOGIN PASSWORD 'MYROLEPASSWORD' NOINHERIT
CREATEDB;
==> is postgre prompt, isn't it?
Shouldn't I type before: su postgres
..hidden.. /home/joseph $ CREATE ROLE ledgersmb LOGIN PASSWORD 'MYROLEPASSWORD' NOINHERIT CREATEDB;
bash: CREATE: command not found
--
#Joseph