Thread:
I am trying to install PostgreSQL 7.2 under Redhat The installation seems to work without problems. However, when I try to start the program I encounter the following error message >psql: connectDBStart() -- connect() failed: No such file or directory > Is the postmaster running locally > and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'? There is no such file in the /tmp/ directory. I am not sure how to find out if the postmaster is running. I am not entirely clear whether this inidicates that there is something wrong with installation or if something else is wrong. I am willing to try everything, including a complete reinstall. sincerely, KSG ------------------------------------------------------------ Kristian Skrede Gleditsch, Ph.D. Assistant Professor Department of Political Science University of California, San Diego La Jolla, CA 92093-0521, USA Tel: (858) 822 0535, Fax: (858) 534 7130 Email: kgleditsch@ucsd.edu http://weber.ucsd.edu/~kgledits/
"Kristian Skrede Gleditsch" <kgleditsch@ucsd.edu> writes:
> I am trying to install PostgreSQL 7.2 under Redhat
> The installation seems to work without problems. However, when I try to
> start the program I encounter the following error message
>> psql: connectDBStart() -- connect() failed: No such file or directory
>> Is the postmaster running locally
>> and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
> There is no such file in the /tmp/ directory.
It sounds like you didn't start the postmaster. pg_ctl is the usual
manual method for that. I can't tell from this whether you've installed
any boot scripts to start the postmaster at system boot --- but even if
you did, they'd not do anything until you reboot.
regards, tom lane
quote from Tom Lane: : It looks to me like psql is looking for the socket in some other : directory than where the postmaster created it. Do you perhaps : have an environment variable set that would override the compiled-in : default location? (I think PGHOST=/var/run/postgresql would cause : the above behavior in psql, but AFAIR the postmaster does not pay any : attention to PGHOST.) You should see postmaster in your process list if it is running. BR, aarni On Friday 03 May 2002 02:37 am, you wrote: > I am trying to install PostgreSQL 7.2 under Redhat > > The installation seems to work without problems. However, when I try to > start the program I encounter the following error message > > >psql: connectDBStart() -- connect() failed: No such file or directory > > Is the postmaster running locally > > and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'? > > There is no such file in the /tmp/ directory. I am not sure how to find out > if the postmaster is running. > > I am not entirely clear whether this inidicates that there is something > wrong with installation or if something else is wrong. I am willing to try > everything, including a complete reinstall. > > > sincerely, > KSG > > ------------------------------------------------------------ > Kristian Skrede Gleditsch, Ph.D. > Assistant Professor > Department of Political Science > University of California, San Diego > La Jolla, CA 92093-0521, USA > Tel: (858) 822 0535, Fax: (858) 534 7130 > Email: kgleditsch@ucsd.edu http://weber.ucsd.edu/~kgledits/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
I have installed PostgreSQL 7.2 but have problems getting the program to run properly. When I try start the postmater with pg_ctl I get the following error message FATAL 1: The data directory was initialized by PostgreSQL 7.2, which is not compatible with this version 7.1.3 I gather I must still have a version 7.1.3 on the system (does this come with Redhat?). Is there a way to remove the old version or upgrade everything to 7.2? regards, KSG > -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: Friday, May 03, 2002 07:18 > To: Kristian Skrede Gleditsch > Cc: pgsql-novice@postgresql.org > Subject: Re: [NOVICE] > > > "Kristian Skrede Gleditsch" <kgleditsch@ucsd.edu> writes: > > I am trying to install PostgreSQL 7.2 under Redhat > > The installation seems to work without problems. However, when I try to > > start the program I encounter the following error message > > >> psql: connectDBStart() -- connect() failed: No such file or directory > >> Is the postmaster running locally > >> and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'? > > > There is no such file in the /tmp/ directory. > > It sounds like you didn't start the postmaster. pg_ctl is the usual > manual method for that. I can't tell from this whether you've installed > any boot scripts to start the postmaster at system boot --- but even if > you did, they'd not do anything until you reboot. > > regards, tom lane > >
> I have installed PostgreSQL 7.2 but have problems getting the > program to run > properly. > > When I try start the postmater with pg_ctl I get the following > error message > > FATAL 1: The data directory was initialized by PostgreSQL 7.2, > which is not > compatible with this version 7.1.3 > > I gather I must still have a version 7.1.3 on the system (does this come > with Redhat?). Is there a way to remove the old version or upgrade > everything to 7.2? > > regards, > KSG PG does come with RedHat, and you may have chosen it in your install. Did you install PG 7.2 from source? If so, it will be in /usr/local/pgsql (unless you chose non-default options for ./configure), where the RedHat RPM is installed in several places (as the RPM standard suggests). Probably /usr/bin, where PG7.1 would be, is higher in your $PATH that /usr/local/pgsql/bin, where PG7.2 is. Try: # rpm -qa | grep -i postgres To find all RPMs on your system relating to PG. You can uninstall these with # rpm -e <list of RPMs> J. Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton Knowledge Management & Technology Consultant