Pgaccess doesn't connect

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-----

Responses

Browse pgsql-novice by date

  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