Hi,

I am using postgresql 8.1.
The data are in /var/lib/... and the partition is FULL.

How should I do to move the data ? Is it possible just by using a
symbolic link ?

Thanks,
Raphael

Raphael <raphperrin (AT) bluewin (DOT) ch> wrote:
Yes, you can do that. You can move the data directory somewhere else
and replace it with a symbolic link.

A second option would be to enlarge the file system (if possible).

Thirdly, you could just copy the data directory somewhere else and
start the postmaster with 'pg_ctl -D /new/db/location start'.

Mage sure that you retain permissions and ownership when you copy
(cp -p or similar).

Yours,
Laurenz Albe

Raphael wrote:

Another option, depending on distribution and usage pattern, could be to
use a separate tablespace for some tables.

http://www.postgresql.org/docs/8.2/s...blespaces.html

If, for instance, you have lots of historical data that you can move to
a slower storage, you can pick some tables and migrate them to that
partition.

Marco Mariani a écrit :

Thanks all, I will just move the data and make a symbolic link. I only
have one database for bacula.

Raphael

Raphael schrieb:
One more:

you can add a new harddrive, create a new fstab entry:

/dev/sdx /var/lib/pgsql ext3 ...

Then first temporary mount the new partition mount /dev/sdx
/tmp/newdrive, copy over the data from the olddrive:

cp /var/lib/pgsql/* /tmp/newdrive/

reboot ...

-Stefan