Data location problem
От | Brad.Murray@pccmentor.com (Brad.Murray) |
---|---|
Тема | Data location problem |
Дата | |
Msg-id | 0000DF61.010301@pccmentor.com обсуждение исходный текст |
Список | pgsql-general |
I have your Postgresql server running on my Linux (RH 5.2). I must say I am pleased with it's performance. I have, however, encountered a situation I can not figure out how to resolve. I have partitioned my system in the following manner: Filesystem 1024-blocks Used Available Capacity Mounted on /dev/hda2 35132 29158 4160 88% / /dev/hda3 3901 593 3107 16% /boot /dev/hda8 21438 6211 14120 31% /home /dev/hda6 347375 233681 95754 71% /usr /dev/hda5 550279 1006 520849 0% /usr/database /dev/hda7 50717 49921 0 100% /usr/src The idea is to have my Databases (data) reside on hda5 (for easy backup). postmaster etc. reside on hda6. I had originally setup a database ('diplinedb') in /usr/lib/ (will I was learning the system), then attempted to migrate it to /usr/database, using all of the "secondary location" instructions (initlocation, initdb, $PGDATA2). I start postmaster with either "postmaster -i -D $PGDATA2" (PGDATA2 = /usr/database) or "postmaster -i -D /usr/database" and still my data goes to /usr/lib. I think I read somewhere that postmaster will not traverse partitions (hda6 -> hda5), is this the case? If so, is there a way around this, or do I just need to bite the bullet and repartition the system so that my PGDATA2 and postmaster reside on the same partition? Thanks Brad
В списке pgsql-general по дате отправления: