Thread: Newbie: problem Connecting to Server
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.
I sorta had the same problem using pgAccess. The way to correct my problem was to start the postmaster using the TCP/IP options.
I now use the following to start postmaster:
pg_ctl start -D /path to data -o -i
the -i option enables 'listening' on TCP ports.
From a beginner to a beginner
Marc
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Ferindo
Middleton Jr
Sent: Sunday, March 30, 2003 8:22 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Newbie: problem Connecting to Server
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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
Looks like no one has corrected you, alex, so, as it pertains to redhat, a user of which I am not, you may have directedFrustrated correctly. I just wanted to add to the comment below about "option -i" that the postgresql.conf file has a setting in it, "tcpip_socket"which can be set to the value true after being uncommented. That way you won't have to specify the option ifyou restart the PostgreSQL manually. > -----Original Message----- > From: alex b. [mailto:mailinglists1@gmx.de] > Sent: Thursday, April 03, 2003 3:42 PM > To: Frustrated Beginner > Cc: Postgresql General; Jonas Hoge > Subject: Re: [GENERAL] Newbie: problem Connecting to Server > > > Frustrated Beginner wrote: > > 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. > > > you guys first have to create a POSTGRESQL USER, under which the > server will run... > > in other words: the server (postmaster) must be running, which it is > not, apparently. > > /tmp/.s.PGSQL.5432 > is a unix socket, to which the client connects. the postgresql-server > creates that socket itself. > since you guys are running redhat, you should be able to set > the scripts > to started at boot time in different runlevels (runlevel editor) and > select postgresql to be started... as root as a matter of course. > > > > if none of that works, then try the following as root: > > first uninstall the postgresql, download the kernelheaders to your > current kernel, download the current postgresql-sources > (7.3.2), compile > that, and install (make install - as root) > > follow these directions (all as root): > - create the user "postgres" belonging to group "daemon" > - mkdir /usr/local/pgsql/logs > - mkdir /usr/local/pgsql/data > - chmod 700 /usr/local/pgsql/data > - echo "/usr/local/pgsql/lib" >> /etc/ld.so.conf > - ldconfig > - chown -R postgres:daemon /usr/local/pgsql > - su postgres -c '/usr/local/pgsql/bin/initdb -D > /usr/local/pgsql/data' > - su postgres -c '/usr/local/pgsql/bin/postmaster -D > /usr/local/pgsql/data >> /usr/local/pgsql/logs/server.log 2>&1' & > (all in one line) > > and you're done, you may now create a new and fresh database, > just like > this: > > - su postgres -c '/usr/local/pgsql/bin/createdb <databasename>' > > notice that "su postgres .." command... it is because postmaster (the > server binary) likes to be started as a user and not as root, > since that > would be a dangerous act. all programs can be exploited and > evil, evil > badboys could gain root privileges and destroy the whole world... > postgresql simply won't start as root - security issues. > > > > > ANYONE: please correct me, if I'm wrong!!!!! it is important, so I or > them won't mess up their systems.. > > > > cheers, > alex > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
On Thursday 03 April 2003 23:12, Tamir Halperin wrote:
> Looks like no one has corrected you, alex, so, as it pertains to redhat, a
> user of which I am not, you may have directed Frustrated correctly.
> > you guys first have to create a POSTGRESQL USER, under which the
> > server will run...
> > ANYONE: please correct me, if I'm wrong!!!!! it is important, so I or
> > them won't mess up their systems..
Somehow I missed this the first time around....
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').
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
Is postgreSQL even running ???? # ps ax | grep postgres "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.