PGDATA, PGDATA2, pg_database
От | Grzegorz Przeździecki |
---|---|
Тема | PGDATA, PGDATA2, pg_database |
Дата | |
Msg-id | 20020719162415.9B4BE14049@lupus.pl обсуждение исходный текст |
Список | 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. ///////////////////////////////////////////////////
В списке pgsql-admin по дате отправления: