From: | Vittorio Zuccala' <vitto(dot)z(at)tiscalinet(dot)it> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Pgaccess doesn't connect |
Date: | 2003-03-09 14:11:06 |
Message-ID: | 20030309151106.05beeec8.vitto.z@tiscalinet.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello and sorry for my bad english ;-)
I've a lot of problems with my postgreSQL.
I use mandrake linux 9.0 with postgres 7.2.2 and i
eliminated postgres user password...
I logged as postgres user and i created "prova_db" database.
Then i created "indirizzi" table in which i put three addresses.
If i manage my postgres database as postgres user with "psql" command
all works fine.
Problems arrive if i do not log as postgres user but as my usual user (nathanvi).
If i launch pgaccess and try to open my database as in the attached PNG
my system responds in this way:
"Error trying to connect to database 'prova_db' on host localhost
PostgreSQL error message: Connection to database failed
could not connect to server running on host localhost
and accepting TCP/IP connection on port 5432?"
In the same way if i try to connect to database with a PERL script with Pg module
that i've attached as "prova_db_connessione2.pl" and i try to add a record, it responds:
Variabile result: PG_results=SCALAR(0x804c130)
What can i do?
Please help me....
PS Obviusly postgreSQL is running on my server and in /etc/services i find two
rows in which it declares that port 5432 is for postgres connection...
...
***********************************************************************
Vittorio Zuccala'
ICQ#20318568
YMess: nathanvit
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE+a0t6wmoaRob4t3wRAub0AJ4jHUj3H30GNz4dnHQF9QWu5Y4ATwCfWtH9
5nr/5V12N50uSdPfdQOeiA8=
=eZ+L
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | rrung | 2003-03-09 15:06:59 | Network not found |
Previous Message | Aspire Something | 2003-03-09 08:04:46 | Python in Postgresql |