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