On Sun, 12 Sep 1999 [EMAIL PROTECTED] wrote:
> Hi Peter,
> Thanks for your reply. I have another question. I have postgresql,
> postgresql-clients, postgresql-data, postgresql-devel of release 6.3.2-10
> with my redhat linux 5.2. I uninstalled them and installed postgresql,
> postgresql-devel, postgresql-server, postgresql-jdbc, postgresql-odbc,
> postgresql-perl of release 6.5.1-2. I could not find postgresql-clients and
> postgresql-data of release 6.5.1-2. Then when I run su -l postgres -c
> '/usr/bin/postmaster -S -D/var/lib/pgsql' I got the following error:
> /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/templete1/pg_class".
> I think I didn't install template database. Where can I download
> postgresql-data? Do I need postgresql-clients?
template1 is a special database that is used when creating new databases
(ie, you shouldn't create any tables in there as when you create a new
database, the table is copied as well).
To create it, you run initdb. This is normally run only once, and creates
all the system tables and the template1 database.
For example:
initdb --pgdata=/var/lib/pgsql --pglib=/usr/lib/pgsql
I think /usr/lib/pgsql is correct.
Oh, you must run this as the postgres user.
Peter
--
Peter T Mount [EMAIL PROTECTED]
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
----------------------------------------------------------------------
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
