Thread: Getting started on Linux RH6.2 ...
Hello It is probably something quite silly but I have installed all the binaries from the RH6.2 installation disk and browsed through the manual. These are: postgresql-6.5.3-6.i386.rpm postgresql-python-6.5.3-6.i386.rpm postgresql-devel-6.5.3-6.i386.rpm postgresql-server-6.5.3-6.i386.rpm postgresql-jdbc-6.5.3-6.i386.rpm postgresql-tcl-6.5.3-6.i386.rpm postgresql-odbc-6.5.3-6.i386.rpm postgresql-test-6.5.3-6.i386.rpm postgresql-perl-6.5.3-6.i386.rpm from which you will see the version. Firstly the tree as described in the Administrators guide in /usr/doc/postgresql-6.5.3/admin/layout.htm is very much pruned - in fact the only directories under /usr/lib/pgsql are: drwx------ 2 postgres postgres 4096 Jul 23 21:56 backup drwxr-xr-x 3 root root 4096 Nov 22 11:19 perl5 drwxr-xr-x 4 root root 4096 Nov 22 11:18 pgaccess drwxr-xr-x 3 root root 4096 Nov 22 11:19 python drwxr-xr-x 9 root root 4096 Nov 22 11:18 test and there is no directory /usr/local/pgsql at all. So it is not surprising that when I try and run the postmaster, I get the message: postgres $ postmaster /usr/bin/postmaster does not know where to find the database system data. You must specify the directory that contains the database system either by specifying the -D invocation option or by setting the PGDATA environment variable. No data directory -- can't proceed. Clues/pointers anyone? I don't want to have to compile it all. Have RH dropped a thingy? John
----- Original Message ----- From: <j.logsdon@lancaster.ac.uk> > Hello > > It is probably something quite silly but I have installed all the binaries > from the RH6.2 installation disk and browsed through the manual. These > are: > > postgresql-6.5.3-6.i386.rpm postgresql-python-6.5.3-6.i386.rpm etc > from which you will see the version. There are newer releases - you might want to get hold of 7.0 rpms before using it in a live system. > Firstly the tree as described in the Administrators guide in > /usr/doc/postgresql-6.5.3/admin/layout.htm is very much pruned - in fact > the only directories under /usr/lib/pgsql are: [snip] > and there is no directory /usr/local/pgsql at all. RPM installs tend to put files in different places than when you compile - try rpm -ql <package-name> to see where things have been put. > postgres $ postmaster > /usr/bin/postmaster does not know where to find the database system data. > You must specify the directory that contains the database system either by > specifying the -D invocation option or by setting the PGDATA environment > variable. > > No data directory -- can't proceed. Two things spring to mind - "initdb" needs to be run to set up the database (you should have a "data" directory somewhere with datafiles within). Don't know if the RPMs have already run that or not. Second thing - check in /etc/rc.d/init.d/ for a postgres script - if so try running /etc/rc.d/init.d/postgres start - Richard Huxton