Mainpage
Searchform
History
Versions
Categories
Contents
Deutsch
SuSE Linux: Versions since 5.3
Apparently it is not so easy to start working with PostgreSQL ...
In /var/log/server.log
the following error message appears :
/usr/bin/postmaster does not find the database system. Expected to find it in t he PGDATA directory "/var/lib/pgsql/data", but unable to open file with pathname "/var/lib/pgsql/data/base/template1/pg_class". No data directory -- can't proceed.
In order to facilitate future updates or to install pure PostgreSQL client machines, the database system PostgreSQL was split into several packages :
You forgot to install the package "pg_datab
" during the
first installation.
Install the package "pg_datab
" and try again to start
the postmaster
(as user "root
") :
rcpostgres start
Now login (via su
) as user "postgres
" :
su - postgresand create a PostgreSQL user with your own user name (use your login name instead of
LOGNAME
) :
createuser LOGNAME
Answer all questions. Then you can create a PostgreSQL database as regular user (LOGNAME). Login as user LOGNAME and execute the following command :
createdb address
Connect to the database via one of the interfaces delivered with PostgreSQL :
psql address
or under X with pgaccess
.
Further information about PostgreSQL is available at
/usr/doc/packages/postgres
. Especially interesting is the
HTML documentation : /usr/doc/packages/postgres/html/index.html.
See also:
Keywords: DATABASE, POSTGRESQL, SQL
Categories:
Applications
Mainpage
Searchform
History
Versions
Categories
Contents
Deutsch