Postgres installataion in SUSE 7.0, lacking dirs i ~postgres/data

Поиск
Список
Период
Сортировка
От Lars Forseth
Тема Postgres installataion in SUSE 7.0, lacking dirs i ~postgres/data
Дата
Msg-id 01032022084700.06152@Yoda
обсуждение исходный текст
Ответы Re: Postgres installataion in SUSE 7.0, lacking dirs i ~postgres/data  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hi!
My first posting seems to get no response, but I have been researching my
problem a little more. This evening I cleaned out all postgres related stuff,
and reinstalled, using yast1. From the /var/log/postgres file I can read this
afterwards:

"No data directory -- can't proceed.
/usr/bin/postmaster does not find the database system.  Expected to find it
in the PGDATA directory "~postgres/data", but unable
to open file with pathname "~postgres/data/base/template1/pg_class".

No data directory -- can't proceed."

Looking into this dir I get this:

"larsf@Yoda:~ > cd ~postgres/data
larsf@Yoda:/var/lib/pgsql/data > ls -al
total 12
drwxr-xr-x   2 root     root         4096 Mar 20 19:56 .
drwxr-xr-x   3 root     root         4096 Mar 20 19:56 ..
-rwx---rw-   1 postgres daemon         27 Aug  6  2000 pg_options
larsf@Yoda:/var/lib/pgsql/data >"

Looking for pg_class results in this:

"larsf@Yoda:/var/log > locate pg_class
/usr/include/pgsql/catalog/pg_class.h"

So it seems I'm lacking some dirs and files, presumably SUSEconfig has failed
in building the template1 standard database and database dir during install
of the RPM's; why?

What to do? Could somebody supply a stock data dir so I could copy it into
this dir, and get postgres up and running?

Regards, LarsF




--
--------------------------
Lars Forseth
http://www.uio.no/~forseth
MS WIN > /dev/null
TUX rules
--------------------------


В списке pgsql-novice по дате отправления:

Предыдущее
От: "Mark, Terry"
Дата:
Сообщение: RE: Weird (?) problem with order of conditions in SELECT
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgres installataion in SUSE 7.0, lacking dirs i ~postgres/data