Skip site navigation (1) Skip section navigation (2)

Data location problem

From: Brad(dot)Murray(at)pccmentor(dot)com (Brad(dot)Murray)
To: pgsql-ports(at)postgresql(dot)org
Subject: Data location problem
Date: 2000-02-18 12:26:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-ports
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

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-ports by date

Next:From: Thomas LockhartDate: 2000-02-18 14:27:45
Subject: Re: [PORTS] Postgres 6.5.3 succesfull install on IRIX 6.5.6f
Previous:From: Kevin (HxPro) WheatleyDate: 2000-02-18 09:00:11
Subject: Postgres 6.5.3 succesfull install on IRIX 6.5.6f

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group