Re: [GENERAL] Environmental Variables

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
>>
>>
>>
>>
>>
>>
>>
>
>