Re: Pgaccess doesn't connect
Vittorio Zuccala' <vitto.z@tiscalinet.it>
From: Vittorio Zuccala' <vitto.z@tiscalinet.it>
To: pgsql-novice@postgresql.org
Date: 2003-03-10T14:05:58Z
Lists: pgsql-novice
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Il giorno Sun, 9 Mar 2003 19:06:16 -0500 (EST), tu oh prode brew@theMode.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-----