database location problems
От | Devinder K Rajput |
---|---|
Тема | database location problems |
Дата | |
Msg-id | OF3D998D59.770F665E-ON86256C86.00019D25@ipaper.com обсуждение исходный текст |
Ответы |
Re: database location problems
|
Список | pgsql-novice |
Hi, I have installed 7.3 in /usr/local/pgsql. However, I want the system tables, config files, etc. located in the /data/db/system directory. I am able to do "initdb -D PGDATA" (PGDATA = /data/db/system) and it works fine. However, when I try to create a database, createdb tells me that it cannot find /usr/local/pgsql/data/global/1262 (which i assume is template1). However, I can do an initdb with PGDATA set to /usr/local/pgsql/data and then I am able to create databases, but this is not what I need. I also tried setting the datadir=/data/db/system before running ./configure. However, this creates a postgresql directory under /data/db/system and puts sample files there. And when I go to do an initdb with PGDATA set to /data/db/system, it complains that the directory is not empty. short version: I need: installation dir: /usr/local/pgsql system tables, config files, etc.: /data/db/system databases /data/db/<dbname> Can anybody please show me the light, so to speak. Thank you, Devinder Rajput Stores Division Corporate Offices Chicago, IL (773) 442-6474
В списке pgsql-novice по дате отправления: