New subject: [SLE] Installing PostgreSQL in a Linux Environment

29 Aug 2004

      Hiya Bob,

Thanks for your suggestion. When i tried to check if
the postmaster was running with the commands you gave
me, i got the following result:

newton@linux:~> rpm - qa | grep postmaster
newton@linux:~> rpm - qa | grep postgres
postgresql-jdbc-7.2-70
postgresql-odbc-7.2-70
postgresql-perl-7.2-70
postgresql-libs-7.2-70
postgresql-tcl-7.2-70
postgresql-python-7.2-70
postgresql-docs-7.2-70
postgresql-tk-7.2-70
postgresql-devel-7.2-70
postgresql-test-7.2-70
postgresql-tk-7.2-103
postgresql-test-7.2-103
postgresql-tcl-7.2-103
postgresql-jdbc-7.2-103
postgresql-docs-7.2-103
postgresql-7.2-70
postgresql-contrib-7.2-70
postgresql-server-7.2-70
newton@linux:~> px ax | grep postmaster
bash: px: command not found
newton@linux:~> su
Password:
linux:/home/newton # px ax | grep postmaster
bash: px: command not found
linux:/home/newton #

........................

I think the implication of the above is that the
system could not find the px command. I don't know
what else to do. Can you help again , plz?

Cheers,

Newton

--- Bob Hartung  wrote:
...
Newton,
   If you installed SuSE you probably installed
binary files with the 
rpm format.  In that case you can check the install
location of the 
files with:
       rpm -ql postgresql-xxxxxx
the exact file name can be had with:
rpm -qa | grep postgres
Once you have the file locations check the
postgresql file in 
/etc/init.d/... subdirectory.  Chances are that SuSE
has this all set up.
Now, check to see that postmaster (the postgresql
daemon) is running 
with:
px ax | grep postmaster
If the daemon is not running then you need to
check that it is set to 
start on boot.  This will require root access to
Yast.  I can't tell you 
much about that part as I use Fedora2.
After all is set up:
su to root and then
su postgres   to become the postgres user.
At this point you should be able to create a
database etc.  Once the 
postgres superuser has created a database you can
give yourself 
superuser rights.
Suggested Books:
Practical PostgreSQL,  o'Reilly
   Beginning Databases with Postgresql, Wrox [I 
think they're still 
publishing].
   DO NOT forget the documentation installed whether
you installed from 
the tar.gz or rpm files.  This has everything in it.
HTH
Bob Hartung
...
Hiya Dees,
I've seen the intelligent contributions you've
been
making to this community, and would wish to ask
for
your assistance to solve this problem.
I have, before now, been working in the windows
environment. Recently however, i installed SUSE
8.0 in
my desktop, and as one of the open source
softwares in
SUSE, also installed PostgreSQL. The problem is
...
have been unable to get it properly installed.
The manual i read says i should do carry out the
following steps:
1) Create the postgre user, using the following
   command:
    $ su - -c " useradd postgres "
This was successfully done.
2) Install the postgreSQL Source package. This i
have
   done successfully from the SUSE package.
3) Configure Source Tree. This I am supposed to do
   using:   $ ./configure
However, this has refused to work as shown by
...
following response i got from the system:
newton@linux:~> cd home
          newton@linux:~/home> cd bin
          newton@linux:~/home/bin> ./configure
          bash: ./configure: No such file or
Eyinagho Newton wrote:
that i
the
directory
...
newton@linux:~/home/bin> su
          Password:
          linux:/home/newton/home/bin #
./configure
...
bash: ./configure: No such file or
directory
...
linux:/home/newton/home/bin # ls
          .   PG_VERSION  global   pg_hba.conf
...
pg_xlog          postmaster.opts
          ..  base        pg_clog  pg_ident.conf
...
postgresql.conf
          linux:/home/newton/home/bin # exit
          exit
          newton@linux:~/home/bin> ls       
PG_VERSION  global   pg_hba.conf    pg_xlog
...
postmaster.opts
base        pg_clog  pg_ident.conf 
postgresql.conf
newton@linux:~/home/bin> ./configure --help
bash: ./configure: No such file or directory
newton@linux:~/home/bin>
What exactly haven't i done correctly? How do i go
about configuring the Source Tree?
Thanks
Newton
_______________________________
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter
now.
http://promotions.yahoo.com/goldrush
_______________________________
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now. 
http://messenger.yahoo.com

Re: [SLE] Installing PostgreSQL in a Linux Environment

Eyinagho Newton

Patrick Shanahan

Eyinagho Newton

Patrick Shanahan

Eyinagho Newton

Ken Schneider

Eyinagho Newton

Jon Clausen

tags

participants (4)