PGDATA, PGDATA2, pg_database

From: Grzegorz Przeździecki <Grzegorz(dot)Przezdziecki(at)crn(dot)pl>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: PGDATA, PGDATA2, pg_database
Date: 2002-07-19 16:28:20
Message-ID: 20020719162415.9B4BE14049@lupus.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Welcome
I need some information about PGDATA and PGDATA2 variable and system table
pg_database.

I'm read doc and have a question.
for example
PGDATA =/usr/data this is clouster_1
PGDATA2 =/usr2/data this is clouster_2

First question
Is pg_database i one for two clouster or one in clouster_1 and
second copy in clouster_2 with other database?

Second question.
I can run postmaster with param -D and path to databases location for example
clouster_1.
In this moment when I run select comand on pg_database I will see only
database from clouster one or database form clouster_1 and clouster_2 and I
will connect only to database from clouster_1???

Third question
What will hapend where I set variable PGDATA and PGDATA2 in my environment
and run postmaster -i -o '-F' & (for example)
I will see run select on pg_database all database or not and can conntect (\c
command from pgsql) to database from PGDATA and PGDATA2?

In doc for 7.2.1 wrote:

======================
Unlike most system catalogs, pg_database is shared across all databases of a
cluster: there is only one copy of pg_database per cluster, not one per
database.
=======================

Thanks

Sorry for my English

--
///////////////////////////////////////////////////
Hold down your horses.
Don't be in a hurry.
Read slow.
Read carefully.
These things are important.
It is not polite to read them that fast

Be human after all, not robot.
///////////////////////////////////////////////////

Browse pgsql-admin by date

  From Date Subject
Next Message Chad R. Larson 2002-07-19 17:38:06 Re: Tape/DVD Backup Suggestions?
Previous Message Tom Lane 2002-07-19 14:04:36 Re: Long update progress