Mailinglist Archive: opensuse (4288 mails)

[Alberto García Fumero <fumero@xxxxxxx>]

Hi y'all!
I have just installed PostgreSQL on this SuSE 7.3. But I can not use it. 
As I installed insung YAST2, I assume that the right variables are set 
correctly. At least that was what YAST2 said ;-))
I  admit I know almost nothing of it.
I tried to launch pgaccess as a simple user to begin with, but the error 
(horror) message I get when I try to create a database is:
"Error TCL en la ejecutando pg_exec create database nameofdatabase
Is not a valid postgresql connection"
Trying to understand (I hope) the instruction from some papers I got, I 
logged as user postgres and launched:
initdb --pglib=/usr/lib/pgsql --pgdata=/var/lib/pgsql

and this time the error message was:

initdb: invalid option: --pglib=/usr/lib/pgsql
Try 'initdb --help' for more information.

So I forgot all about pglib and tried:

postgres@fumero:/home/alberto> initdb  --pgdata=/var/lib/pgsql
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.

initdb: The directory /var/lib/pgsql exists but is not empty.
If you want to create a new database system, either remove or empty
the directory /var/lib/pgsql or run initdb with
an argument other than /var/lib/pgsql.

How should I interpret this?
TIA,
-- 
MSc. Alberto García Fumero
Centro de Información para la Educación
Ministerio de Educación
Usuario Linux No. 97 138
¿Windows? No, gracias!