From: "Janet" <janet(at)chinasystems-cn(dot)com>
To: "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject:
Date: 2000-05-23 06:21:44
Message-ID: 001001bfc47f$2b1a5560$21f327ca@janet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

I don't know if there is the right place to ask my question. If not, please
accept my apology.

I'm totally new to Linux. And I have troubles using the PostgreSQL.

I installed Redhat 6.0 and find there is postgresql already installed on my
computer.
Running the following command I get:
////////////////////////////////////////////////////
$rpm -ql postgresql
/etc/rc.d/init.d/postgresql
/usr/bin/cleardbdir
/usr/bin/createdb
/usr/bin/createuser
/usr/bin/destroydb
/usr/bin/destroyuser
/usr/bin/initdb
/usr/bin/initlocation
/usr/bin/pg_passwd
/usr/bin/pg_version
/usr/bin/postgres
/usr/bin/postmaster
/usr/doc/postgresql-6.4.2
.....
(All the /usr/doc entried are omitted here since they are too many)
......
/var/lib/pgsql
///////////////////////////////////////////

I thought it's ok to start the postgresql server, so I run the following
command but it complains:
(the command was found in the "/etc/rc.d/init.d/postgresql" file)
//////////////////////////////////////////////
$postmaster -i -D/var/lib/pgsql
/usr/bin/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.
////////////////////////////////////////////

I read the installation instruction of the PostgreSQL but it teaches you how
to install from the beginning and expect you to use the file
"postgresql-v6.4.tar.gz", which I haven't got on my computer.

I also tried to run the following command:
$initdb
but it cannot work yet.

Someone told me I should establish a data store for the PostgreSQL. What's
that? How to?

Do I need to download "postgresql-v6.4.tar.gz" to re-install the PostgreSQL?
Or how can I
solve my problem? What's in the earth wrong? What's indeed the PGDATA mean?

Any suggestion or hints are appreciated greatly!

With my best regard:
Janet

Responses

  • Re: at 2000-05-23 06:53:51 from Robert B. Easter
  • Re: at 2000-05-23 08:33:50 from Mike Mascari

Browse pgsql-general by date

  From Date Subject
Next Message Eric Jain 2000-05-23 06:37:16 plperl and eval
Previous Message Tom Lane 2000-05-23 05:11:39 Re: tricky CHECK condition