[Wylug-help] PostresSQL under Mandrake question

[Corrado & Rina]

Already did all of that. As I told you, I read the documentation
thoroughly ... :-( ...

It does not work at all.

The only different bit is, that I allow the user to create a db.

I wonder if the problem is related to some security setup ...

Corrado

(Well, PostgresSQL is an implementation of a relational database,
following Codd's 12 rules, and for this reason I would like to use it
for my course. MySQL is an implementation of a database, which works
really well and does not follow Codd's 12 rules.)

steve kirk wrote:

>On Tuesday 15 Oct 2002 6:15 pm, Corrado & Rina wrote:
>
>
>>Hy all,
>>
>>I always used MySQL as DBMS.
>>
>>Now, for a courses I am running, I would like to ask the students to use
>>PostgresSQL, which apparently is more compliant with SQL:1999
>>specifications.
>>
>>After a successful installation of version 7.2 under MDK 9.0, the
>>problems began.
>>
>>How do you connect to the server??? I am using psql line client, and
>>after following step by step the never-ending PGSQL documentation and
>>the less awkward MDK documentation, but  still I am at the same point. I
>>create users, but the server which is finely running, does not accept
>>connection. Furthermore, I did not find anywere the name/password of the
>>default server administrator (well, the name should be postgres, but the
>>password??????????).
>>
>>I am nearly fed up ... I begin to understand why MySQL has been so
>>succesful and PosgreSQL ... a bit less ...
>>
>>Corrado
>>
>>
>
>well postgres is an open source version of a real DB (unlike MySQL) so
>possibly success is relative
>
>but briefly
>
>$ su
>$ <pwd>
>$ su - postgres
>$ createdb fred
>$ createuser fred
><answer questions about ability to create db and other users>  - no is
>probably a good answer here
>
>DB fred is now created with access allowed to user fred
>
><----------------------->
>
>fred $> psql --help
>gives a short list of psql commands
>
>fred $> psql
>fred is in postgres with access to his own DB
>
>simple n'est pas ?
>
>
>