Re: Pgaccess doesn't connect

From: Vittorio Zuccala' <vitto(dot)z(at)tiscalinet(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Pgaccess doesn't connect
Date: 2003-03-10 14:05:58
Message-ID: 20030310150558.19212bd1.vitto.z@tiscalinet.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Il giorno Sun, 9 Mar 2003 19:06:16 -0500 (EST), tu oh prode brew(at)theMode(dot)com, picchiettando sui tasti hai scritto:

> The postgres user acts like the root user for the postgreSQL server, you
> only use it for admin things. I think you need to log into the postgers
> user account and CREATE USER (maybe it's create user) for nathanvi. Also
> I think then you'll have to make entries in pg_hba.conf to set where that
> user can access the db from (on the local machine, over tcp-ip, etc.). I
> think pgadmin requires tcp-ip access.

Thanks for the answer.
I create nathanvi user but i can't find pg_hba.conf
Where is it?
In my /etc directory there is a "pgsql" subdirectory in which there's only
a file named odbcinst.ini. Its rows are:
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1

Do you know others names of pg_hba.conf?

...
**********************************************************************
The UNIX Guru's view of sex:
unzip; strip; touch; finger; mount; fsck; more; yes; umount; sleep

**********************************************************************
L'unica accelerazione possibile per windows: (9.81 m/s2)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE+bJvGwmoaRob4t3wRAsovAJsGW2Exf8j5CZS8IIQ1Vb6CpRTOuQCfWVI2
VJ5wtUGt/D54IzRTEUNKDjk=
=wHPC
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-03-10 14:55:15 Re: select
Previous Message cristi 2003-03-10 11:29:28 export from postgres into dbf