Обсуждение: i need help in using pg!!!

Поиск
Список
Период
Сортировка

i need help in using pg!!!

От
"atif ahmed"
Дата:
hi all
i installed postgresql 6.3.2-6 that comes with redhat 5.1 as a root. "i
tried to install it as a regular user but rpm wouldn't allow me"
anyway, after i installed it i logged into my regular account added the
following to my bash_profile:
PATH=$PATH:/usr/bin/postgresql
PGDATA=/var/lib/pgsql
PGLIB=/usr/lib/pgsql
and exported all the above.
when i tried to run the postmaster, it failed:these are the contents of
regress.log:
postmaster does not find the database system.
 Expected to find it in the PGDATA directory "/var/lib/pgsql", but
unable to open file with
pathname "/var/lib/pgsql/base/template1/pg_class".
No data directory -- can't proceed.

and these are the contents of server.log:-
postmaster does not find the database system.
Expected to find it in the PGDATA directory "/var/lib/pgsql",
but unable to open file with
pathname "/var/lib/pgsql/base/template1/pg_class".
No data directory -- can't proceed.

so the questions are:
i- what am i missing? or what did i do wrong?
ii- has any of you installed it from the redaht cd? if so, how did you
do it?


thanx in advance
mark

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

Re: [ADMIN] i need help in using pg!!!

От
Jeremiah Davis
Дата:
PGDATA=/var/lib/pgsql

Should read

PGDATA=/var/lib/pgsql/data

so the database would be /var/lib/pgsql/data/base, not /var/lib/pgsql/base

On Mon, 10 Aug 1998, atif ahmed wrote:

> hi all
> i installed postgresql 6.3.2-6 that comes with redhat 5.1 as a root. "i
> tried to install it as a regular user but rpm wouldn't allow me"
> anyway, after i installed it i logged into my regular account added the
> following to my bash_profile:
> PATH=$PATH:/usr/bin/postgresql
> PGDATA=/var/lib/pgsql
> PGLIB=/usr/lib/pgsql
> and exported all the above.
> when i tried to run the postmaster, it failed:these are the contents of
> regress.log:
> postmaster does not find the database system.
>  Expected to find it in the PGDATA directory "/var/lib/pgsql", but
> unable to open file with
> pathname "/var/lib/pgsql/base/template1/pg_class".
> No data directory -- can't proceed.
>
> and these are the contents of server.log:-
> postmaster does not find the database system.
> Expected to find it in the PGDATA directory "/var/lib/pgsql",
> but unable to open file with
> pathname "/var/lib/pgsql/base/template1/pg_class".
> No data directory -- can't proceed.
>
> so the questions are:
> i- what am i missing? or what did i do wrong?
> ii- has any of you installed it from the redaht cd? if so, how did you
> do it?
>
>
> thanx in advance
> mark
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>