Hi everybody, Sorry for this long mail. After reading you will realise that each and every word is important to clarify my problem. When I installed Postgresql using the RPM's on CHIP SPECIAL CD. The libraries got installed in /etc/var/lib directory. But after reading the documentation I created a directory /usr/local/pgsql and changed it's ownership to postgres user. I created this to keep all my pgsql data and library files at one place ( /usr/local/pgsql ). Afterwards I created two subdirectories lib and data in /usr/local/pgsql and moved all files from /etc/var/lib to /usr/local/pgsql/lib. Changed the ownership to postgres. Then I entered the following in /etc/profile ( setting of environment variable ) PGLIB=/usr/local/pgsql/lib PGDATA=/usr/local/pgsql/data export PGLIB PGDATA Now I logged in as postgres user and entered the following : $ initdb $ postmaster i Here from postgres login postmaster service started and then I created the user and the database. My problem now is when I restart the machine I get the following error : Starting postgresql service postmaster /usr/bin/postmaster does not find the database system. Expected to find it in the directory "/var/lib/pgsql/data", but unable to open file with pathname "/car/lib/pgsql/base/template1/pg_class". No data directory -- can't proceed. Now if I try to run postmaster from any other user login I get the following error : postmaster /usr/bin/postmaster does not find the database system. Expected to find it in the PGDATA directory "/usr/local/pgsql/data", but unable to open file with pathname "/usr/local/pgsql/data/base/template1/pg_class". No data directory -- can't proceed. This error is understandable since the Postmaster service can be started only by postgres user. Though the same error message is repeated notice the change in path of lib and data directories which is as per my environment variable path. Why during startup error message it shows a different path and afterwards a different path ? How should I start postgres service during startup ? NOTE : If I login as postgres and start postmaster it works fine. But the postgres service should start during startup isn't it. Otherwise after I start the computer I will have to first login as postgres and start postmaster service manually. Another problem is if I start pgaccess after manually starting postmaster I get the following error message : pgaccess Error in startup script: couldn't load file "libpgtcl.so": libpgtcl.so: cannot open shared object file: No such file or directory while executing "load libpgtcl.so" (procedure "main" line 6) invoked from within "main $argc $argv" (file "/usr/bin/pgaccess" line 4954) Please help me to solve the above problems. Thanking in advance. -- Shriram alias Rajesh Fowkar Kurtarkar Nagari, Bldg-C, Flat No. T4 Third Floor, Shantinagar(Santacruz), Ponda - Goa - 403 401. Phone : (0834)315932 Email : [EMAIL PROTECTED] ---------------------------------------------------------------- -------------------------------------------------------------------- For more information on Linux in India visit http://www.linux-india.org/ The Linux India mailing list does not accept postings in HTML format.
