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
|
