Hi, I'm trying to install SQL-Ledger.
As a prerequisite I am following these commands given in the FAQs
SuSE 8.1 installation
1. Install the following using YaST2:
- perl-DBD-Pg
- postgresql
- postgresql-contrib
- postgresql-devl
- postgresql-docs
- postgresql-libs
- postgresql-perl
- postgresql-server
- postgresql-test
2. Setup directories and paths for PostgreSQL:
> sux - (change to root)
- If not done by the installation, setup disk directory for your
db:
# mkdir /var/lib/pgsql/data
# chown postgres /var/lib/pgsql/data
3. Initialize the database, and start it, as below:
Note that there are man pages for initdb and pg_ctl.
# touch /var/log/pgsql
# chown postgres:postgres /var/log/pgsql
# sux postgres
- Initialize postgres:
> /usr/bin/initdb -D /var/lib/pgsql/data
(creating ... Success...)
- Start the postgres daemon:
> /usr/bin/pg_ctl -D /var/lib/pgsql/data -l /var/log/pgsql start
(start db)
(postmaster successfully started)
4. Quick-test the server (still as user postgres):
- > psql -d template1
(Welcome ... \q to exit psql)
\q
- Try setting up another db user:
> createuser <db-user> (<db-user> should match an existing Linux
user)
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) n
At this point " createuser <graham> " I get the response
syntax error near unexpected token 'newline'
I have not had any luck googling for this as regards my situation,
please bear in mind I dont clearly understand these commands,
I am entering them "parrot fashion".
Can anybody explain in "newbie speak" what is going wrong
and how to fix it?
One other thing i originally entered the first line in section 3 as
# # touch/var/log/pgsql
It did not appear to do anything
Thanks Graham
