Re: Newbie: problem Connecting to Server
От | No Longer Frustrated |
---|---|
Тема | Re: Newbie: problem Connecting to Server |
Дата | |
Msg-id | 3e902570_3@newsfeed обсуждение исходный текст |
Ответ на | Re: Newbie: problem Connecting to Server ("Frustrated Beginner" <nowweare@access4cheap.com>) |
Список | pgsql-general |
So others might learn from this. The following solution was offered and helped considerably in my case: With an RPM install of PostgreSQL (which RedHat Database is), please consult README.rpm-dist (find it with 'rpm -ql postgresql |grep rpm'). The short of it: The RPM install scripts handle the user creation. All one must do is (as root): '/sbin/service postgresql start' to get an initdb done and postmaster started. Then edit /var/lib/pgsql/data/pg_hba.conf to allow access to the client IP address, and edit postgresql.conf (in the same directory) for tcpip_socket to be true (if you are doing TCP/IP connections, that is). To get postgresql started automatically at boot, do (assuming you want postgresql to run in runlevels 3, 4, and 5): '/sbin/chkconfig --level 345 postgresql on' List the currently valid runlevels with '/sbin/chkconfig --list postgresql' If it complains about postgresql not be a known service, execute '/sbin/chkconfig --add postgresql' -- if that doesn't work, check to see if the postgresql-server RPM is installed ('rpm -qa|grep postgresql'). -No Longer Frustrated "Frustrated Beginner" <nowweare@access4cheap.com> wrote in message news:3e8b9c82_1@newsfeed... > I am having this exact same problem. Any help would be greatly appreciated. > Thank you. > > > > "Ferindo Middleton Jr" <ferindo.middleton@verizon.net> wrote in message > news:pan.2003.03.31.01.23.34.434512@verizon.net... > > I'm running Redhat Linux 8. I have registration to the Redhat Network so > > I'm probably running the latest version of postgre sql available. I also > > have Redhat Databse v2.1 installed, but whenever I try to start a session, > > I get the following error message: > > > > psql: could not connect to server: No such file or directory > > Is the server running locally and accepting > > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > > > > Please help me configure my system so that I can connect and begin to use > > postgresql. > >
В списке pgsql-general по дате отправления: