onsdag 09 juni 2004 17:38 skrev Prabu Subroto:
It's solved... Thank you very...very much, my friend...
I still have one question. I also have one station at home with SuSE 8.2. Why this postgres from SuSE 8.2 does not have "pg_hba.conf"? and how can I use pgaccess to access into the postgres server? And its "postgresql.conf" is also different as the one from SuSE 9.2.
Thank you very much in advance.
You're welcome Here's a copy of my pg_hba.conf file, you can use it for reference. To access my server from <internet ip>, I've added a user with: createuser -aMP <user> Now I can access the server, remotely as that user as long as I'm located at the designed <internet ip> below. For using pgaccess, you start it, and select "connect to DB" (the leftmost icon). If you select "localhost" as the server, then you only need to fill in the database as ident->sameuser authendication will apply. If you select a name for the server, that will result in an IP listed in pg_hba.conf with password authendication, you will need to type in the username and password associated with that authendication. # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD # IPv6-style local connections: host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff: ffff:ffff trust # For local access local all all ident sameuser # For access via "intranet" requires a specific password for each # user. host all all 192.168.0.0 255.255.252.0 md5 # For acces over internet, requires a specific password # for the user. host all all <internet ip> 255.255.255.255 md5 hth, Örn