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

Okay, if you run "ps ax" do you have a line reading something like "/usr/bin/postmaster -S
-D/var/lib/pgsql -i"?. Second, if you do "ls /var/lib/pgsql/base" (as root), do you see a subdirectory called template1?

Regards,

Mike Anderson

-----Original Message-----
From: Duncan Kinder [SMTP:dckinder@mountain.net]
Sent: Friday, August 13, 1999 2:39 PM
To: Michael R. Anderson
Cc: pgsql-general@hub.org
Subject: Re: [GENERAL] Environmental Variables

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