Thread: RE: [GENERAL] Environmental Variables
Since you installed from rpms, everything is in /var/lib/pgsql. You do not need to set any environment variables. Juststart working. Regards, Mike Anderson -----Original Message----- From: Duncan Kinder [SMTP:dckinder@mountain.net] Sent: Friday, August 13, 1999 3:13 AM To: pgsql-general@hub.org Subject: [GENERAL] Environmental Variables I installed the items to be found at ftp://ftp.postgresql.org/pub/RPMS/ , which are rpm files for Postgres, into Redhat Linux. While they appear to have been installed directly, there is no /usr/local/pgsql/ or /usr/local/pgsql/bin directory. Rather various files have been installed in /usr/bin/. But I am not sure all have been installed. In any event, the documentation at http://www.postgresql.org/doxlist.html states: "Add the following lines to your login environment: shell, ~/.bash_profile: PATH=$PATH:/usr/local/pgsql/bin MANPATH=$MANPATH:/usr/local/pgsql/man PGLIB=/usr/local/pgsql/lib PGDATA=/usr/local/pgsql/data export PATH MANPATH PGLIB PGDATA" For me, this is impossible, as I do not have any /usr/local/pgsql directory. Nor will the postmaster start until and unless I provide it with the correct environmental information. Since I have installed from rpm's, there must be a set, known set of environmental features. I would appreciate being provided with this information. Regards, Duncan C. Kinder dckinder@mountain.net
I uninstalled and reinstalled the packages. I got the following response to my command "createdb mydb" (from my account "dckinder"): "Connection to database 'template1' failed. conectDB() -- connect() failed: No such file or directory Is the postmaster running at 'localhost' and accepting connections on Unix socket '5432'?" This is a single Redhat box. I am not connecting it over a network. I have access to root. Regards, Duncan C. Kinder dckinder@mountain.net ----- Original Message ----- From: Michael R. Anderson <mike@ferrar.wvsc.edu> To: 'Duncan Kinder' <dckinder@mountain.net> Cc: <pgsql-general@hub.org> Sent: Friday, August 13, 1999 7:24 AM Subject: RE: [GENERAL] Environmental Variables > Since you installed from rpms, everything is in /var/lib/pgsql. You do not need to set any environment variables. Just start working. > > Regards, > > Mike Anderson > > -----Original Message----- > From: Duncan Kinder [SMTP:dckinder@mountain.net] > Sent: Friday, August 13, 1999 3:13 AM > To: pgsql-general@hub.org > Subject: [GENERAL] Environmental Variables > > I installed the items to be found at > ftp://ftp.postgresql.org/pub/RPMS/ , which are rpm files for Postgres, into > Redhat Linux. > > While they appear to have been installed directly, there is no > /usr/local/pgsql/ or /usr/local/pgsql/bin directory. Rather various files > have been installed in /usr/bin/. > > But I am not sure all have been installed. > > In any event, the documentation at http://www.postgresql.org/doxlist.html > states: > > "Add the following lines to your login environment: shell, ~/.bash_profile: > > PATH=$PATH:/usr/local/pgsql/bin > MANPATH=$MANPATH:/usr/local/pgsql/man > PGLIB=/usr/local/pgsql/lib > PGDATA=/usr/local/pgsql/data > export PATH MANPATH PGLIB PGDATA" > > For me, this is impossible, as I do not have any /usr/local/pgsql directory. > > Nor will the postmaster start until and unless I provide it with the correct > environmental information. > > Since I have installed from rpm's, there must be a set, known set of > environmental features. I would appreciate being provided with this > information. > > > > > Regards, > > Duncan C. Kinder > dckinder@mountain.net > > > > > > >
Have you checked that PostGres is running? You can do so with the following command: ps auxw |egrep postmaster\|postgres If it isn't, log in as the user you installed PostGres under (probably PostGres) and try to start it. You might find that you've forgotten to run initdb or that your startup scripts are trying to run PostGres as root. At 03:39 PM 8/13/99, Duncan Kinder wrote: >I uninstalled and reinstalled the packages. > >I got the following response to my command "createdb mydb" (from my >account "dckinder"): > > >"Connection to database 'template1' failed. >conectDB() -- connect() failed: No such file or directory >Is the postmaster running at 'localhost' and accepting connections on Unix >socket '5432'?" > >This is a single Redhat box. I am not connecting it over a network. I have >access to root. > > >Regards, > >Duncan C. Kinder >dckinder@mountain.net > > > >----- Original Message ----- >From: Michael R. Anderson <mike@ferrar.wvsc.edu> >To: 'Duncan Kinder' <dckinder@mountain.net> >Cc: <pgsql-general@hub.org> >Sent: Friday, August 13, 1999 7:24 AM >Subject: RE: [GENERAL] Environmental Variables > > >> Since you installed from rpms, everything is in /var/lib/pgsql. You do >not need to set any environment variables. Just start working. >> >> Regards, >> >> Mike Anderson >> >> -----Original Message----- >> From: Duncan Kinder [SMTP:dckinder@mountain.net] >> Sent: Friday, August 13, 1999 3:13 AM >> To: pgsql-general@hub.org >> Subject: [GENERAL] Environmental Variables >> >> I installed the items to be found at >> ftp://ftp.postgresql.org/pub/RPMS/ , which are rpm files for Postgres, >into >> Redhat Linux. >> >> While they appear to have been installed directly, there is no >> /usr/local/pgsql/ or /usr/local/pgsql/bin directory. Rather various files >> have been installed in /usr/bin/. >> >> But I am not sure all have been installed. >> >> In any event, the documentation at http://www.postgresql.org/doxlist.html >> states: >> >> "Add the following lines to your login environment: shell, >~/.bash_profile: >> >> PATH=$PATH:/usr/local/pgsql/bin >> MANPATH=$MANPATH:/usr/local/pgsql/man >> PGLIB=/usr/local/pgsql/lib >> PGDATA=/usr/local/pgsql/data >> export PATH MANPATH PGLIB PGDATA" >> >> For me, this is impossible, as I do not have any /usr/local/pgsql >directory. >> >> Nor will the postmaster start until and unless I provide it with the >correct >> environmental information. >> >> Since I have installed from rpm's, there must be a set, known set of >> environmental features. I would appreciate being provided with this >> information. >> >> >> >> >> Regards, >> >> Duncan C. Kinder >> dckinder@mountain.net >> >> >> >> >> >> >> > >