Re: create the sql-ledger tables...

[Oscar B. <os...@el...>]

L.W.

For me the way to be sure (as a Postgresql beginner) that Pg was running
correctly was trying to use it with webmin (http://www.webmin.com/).
PLease make sure that you have created a Pg user (usually called =
postgres)
and that this user may create databases.

If you are root you would then do:

su - postgres

to change to the Pg user. You can NOT access Pg from root.

You would then see something like: [postgres@localhost pgsql]$

then just follow the manual by typing:

psql dbname < acc-Pg.sql

(where dbname ofcourse stands for the name of the database you have =
created
just before)

Obviously you can only do this when you are in de directory where you =
have
the file called acc-Pg.sql
For Mandrake 8.0 that should be: /var/www/sql-ledger/sql/

To leave the user postgres just type: exit on the commandline.

Enjoy,

Oscar

_______________________________________________________________________

Oscar Buijten

Tel:     +33.4.67.57.97.45
Fax:    +33.4.67.57.97.46
GSM: +33.6.20.84.15.22
Email: os...@el...

http://www.elbie.com