Connecting to PostGreSQL on same machine: Mac OSX

[Frank D. Engel, Jr.]

Actually, I could probably delete that line from mine and not miss it 
at all.  That line is for IPv6 addressing support.

The "local" line is to enable UNIX local domain sockets.

The first "host" line (the one before all the "ffff" stuff) is for the 
"localhost" address (which is typically implemented on a fake ethernet 
controller. referred to as a loopback device, independent of the actual 
ethernet card in your computer).

The second "host" line (with "ffff" stuff) is for the "localhost" 
address with IPv6 support.

The third "host" line is one which I added myself; this one supports 
access from the actual ethernet card (IPv4 addressing).  "host all all" 
should be as I have placed it here.  192.168.0.5 is the static IP 
address of my machine (but really any IP address known to be on your 
subnet should work fine), and "255.255.255.0" is the subnet mask of the 
machine.  "password" as opposed to "trust" means that a password should 
be required ("trust" assumes that everyone is being truthful and does 
not demand a password).


This info may be of interest to anyone trying to set up PostgreSQL:  to 
access PostgreSQL from Rev, you need TCP/IP to be enabled in 
postgresql.conf (tcpip_socket = true); you also need a line in 
pg_hba.conf which dictates how authentication should be handled; for 
local access, the defaults should be fine, except that after setting 
your database user 'postgres' password, you should really change 
"trust" to "password" everywhere.  As for network access, you need to 
add a line similar to the one I did, otherwise connections from across 
the network will not be accepted.  Of course, if you don't want others 
to access PostgreSQL on your machine from across the network, don't add 
that line.


And yes, for the problem you are describing, best to post it to a 
PostgreSQL mailing list or forum.  This is getting too far OT for this 
list.

On Dec 13, 2004, at 3:15 PM, Sivakatirswami wrote:

>
> I *had* deleted the line  with all the ffff:ffff:ffff:
>
> but.. seeing this.. I reinserted it..think, so, my pg_hba.conf looks 
> just like yours
>
>
-----------------------------------------------------------
Frank D. Engel, Jr.  <fde101 at fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten 
Son, that whosoever believeth in him should not perish, but have 
everlasting life.
$


-----------------------------------------------------------
Frank D. Engel, Jr.  <fde101 at fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten 
Son, that whosoever believeth in him should not perish, but have 
everlasting life.
$ 



___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com