Re: new installation help

[Joseph <..hidden..>]

I have postgresql-8.0.13, so that should be OK.

I'm just not that good working with postgresql: setting up users /
databases etc.

-- 
#Joseph

On Tue, 2007-09-11 at 03:51 +0200, Vladimir Botka wrote:
> Hello!
> 
> You need postgresql 8.x. lSMB 1.2.7 works for me with postgresql 8.2.
> 
> Cheers,
> 	-vlado
> 
> 
> Dne Mon, 10 Sep 2007 19:15:41 -0600
> Joseph <..hidden..> napsal(a):
> 
> > 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
> > 
> 
>