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!
On Thu, 2002-05-16 at 16:26, Alberto García Fumero wrote:
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.
You used the correct parameters. As the pgdata directory is aleady populated, I assume that the base is already installed. Check for the postgresql status with: /etc/init.d/postgresql status If you get "running", then you are already running the database. The next step is to create users and databases for the users to use: postgres@fumero:/ > createuser alberto Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) n CREATE USER postgres@fumero:/ > exit alberto@fumero:~ > createdb alberto CREATE DATABASE alberto@fumero:~ > psql Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit alberto=> Now your'e connected to the database 'alberto' as user 'alberto'. Further documentation on how to create tables, access your data, datatypes and query design etc can be found in Bruce Momjians excellent book 'PostgreSQL', which can be read at http://www.postgresql.org in the documentation section, and can be bought in dead-tree form, ISBN 0-201-70331-9 -tosi
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!
-- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com
I have been batteling with the same problem. I got psql working, but pgaccess still can't connect. Making changes to postgresql.conf to allow postmaster to listen on tcpip and setting the port to 5432 does not seem to have the desired effect. If someone did get it to work or knows what the problem is, please let us know. On Thursday 16 May 2002 19:57, Tor Sigurdsson wrote:
On Thu, 2002-05-16 at 16:26, Alberto García Fumero wrote:
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.
You used the correct parameters. As the pgdata directory is aleady populated, I assume that the base is already installed.
Check for the postgresql status with:
/etc/init.d/postgresql status
If you get "running", then you are already running the database.
The next step is to create users and databases for the users to use:
postgres@fumero:/ > createuser alberto Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) n CREATE USER postgres@fumero:/ > exit alberto@fumero:~ > createdb alberto CREATE DATABASE alberto@fumero:~ > psql Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit
alberto=>
Now your'e connected to the database 'alberto' as user 'alberto'.
Further documentation on how to create tables, access your data, datatypes and query design etc can be found in Bruce Momjians excellent book 'PostgreSQL', which can be read at http://www.postgresql.org in the documentation section, and can be bought in dead-tree form, ISBN 0-201-70331-9
-tosi
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!
-- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com
Ok, pgaccess is using unix socket directories. edit /var/lib/postgresql/data/postgresql.conf as root and uncomment/set these parameters: unix_socket_directory = '/tmp' unix_socket_group = '' unix_socket_permissions = 0777 On Thursday 16 May 2002 22:46, Alexander Klayman wrote:
I have been batteling with the same problem. I got psql working, but pgaccess still can't connect. Making changes to postgresql.conf to allow postmaster to listen on tcpip and setting the port to 5432 does not seem to have the desired effect. If someone did get it to work or knows what the problem is, please let us know.
On Thursday 16 May 2002 19:57, Tor Sigurdsson wrote:
On Thu, 2002-05-16 at 16:26, Alberto García Fumero wrote:
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.
You used the correct parameters. As the pgdata directory is aleady populated, I assume that the base is already installed.
Check for the postgresql status with:
/etc/init.d/postgresql status
If you get "running", then you are already running the database.
The next step is to create users and databases for the users to use:
postgres@fumero:/ > createuser alberto Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) n CREATE USER postgres@fumero:/ > exit alberto@fumero:~ > createdb alberto CREATE DATABASE alberto@fumero:~ > psql Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit
alberto=>
Now your'e connected to the database 'alberto' as user 'alberto'.
Further documentation on how to create tables, access your data, datatypes and query design etc can be found in Bruce Momjians excellent book 'PostgreSQL', which can be read at http://www.postgresql.org in the documentation section, and can be bought in dead-tree form, ISBN 0-201-70331-9
-tosi
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!
-- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com
participants (3)
-
Alberto García Fumero
-
Alexander Klayman
-
Tor Sigurdsson