Hi

I am trying to learn how to handle databases for a school project.
My question is rather simple: i have postgreSQL installed from netpkg, how do I start using it? What advice on user/file structure can you give me?
I have installed knoda to make life a little more grafical, but when I want to "connect" to a postgresql database it asks for host, database, username, password and TCP port. Now, I thought I could set up all that from _inside_ knoda...?

Thank you

DodoFXP

Hi :)

first , im totally noob on postgresql & sorry for my english ... :-[

Look for the postgresql.conf & pg_hba.conf : they must be configured
( don't worry , all the lignes are comment )

Then , start your postgre service ( or add postgre module in your startup service )

Open a terminal
now you can log into your postgresql account
$ su postgres ( by default )
-> password
cd /usr/bin/
./postmaster -D /var/lib/pgsql/data/ -p 5432 ( TCP port by default )

Open a new terminal
$ su postgres
-> password
psql -h 192.168.0.2 -U postgres ( cause im running local server with the user "postgres" )

in postgresql , you can create a new user & database

http://www.cyberciti.biz/faq/howto-add-postgresql-user-account/

Im using Pgadmin3 to manage my server but 'ill take a look to knoda
Here's my local Worlforge server running for first time (  )


EDIT : argh ! Knoda is for KDE ...

There was an error in the start script, which has been fixed. Its all cool now.