I think I've solved the problem. Here is how I did it I edited the "/etc/rc.d/init.d/postgresql" file and added "-o -i" to the start and restart command lines. The "-o" is a "pg_ctl" option for passing directives, in this case "-i" to the "postmaster". Just in case I also added an entry in the "pg_hba.conf" host all "local IP Address" "mask" trust It is working. >>> fredbriand@blueboxstudio.net 11/22/02 12:57AM >>> Hi, all this seems quite strange. In my configuration files, only pg_hba was modified, as for postgresql.conf, every line is commented. What is the exact error message when you try to connect? Because even if postmaster start without the -i option, you should still be able to connect to the serveur with unix-sockets in local, as specified in your pg_hba.conf. I may mystake because I configured my serveur some times ago (i'm still using RH73!) and that's not the kind of thing I modify for fun, but if I remember well, and I think I do, postgresql's default conf is not to accept tcp/ip connections. If you wish to, just modify pg_hba. Yet if it still does'nt work, I suppose you can add the -i in the /etc/init.d/postgresql. Just find a line by the end of the "start" section that says: su -l postgres -s /bin/sh -c ..... If modifications to the start script can be added, it should be there, but I don't know the exact command line, and to be quite honnest I don't think this will work because the script uses pg_ctl and not postmaster. Here is my pg_hba.conf file, you may try that first :-) # # PostgreSQL HOST-BASED ACCESS (HBA) CONTROL FILE # # local all ident sameuser host all 127.0.0.1 255.255.255.0 trust host all 192.168.123.0 255.255.255.0 password Have fun, and tell us what you get. fred Gordon Messmer a écrit: > On Thu, 2002-11-21 at 14:28, Daniel WELLS wrote: > >>O.K. Maybe I haven't expressed myself very well. My question , >>while you may have given me an answer, it wasn't clear enough for me >>to follow. > > > The advice was incorrect, look at the file: > /var/lib/pgsql/data/postgresql.conf > > > > -- Psyche-list mailing list Psyche-list@redhat.com https://listman.redhat.com/mailman/listinfo/psyche-list -- Psyche-list mailing list Psyche-list@redhat.com https://listman.redhat.com/mailman/listinfo/psyche-list
