[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

new installation help



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