| From: | Együd Csaba <csegyud(at)vnet(dot)hu> |
|---|---|
| To: | "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Moving the database from a filesystem to another |
| Date: | 2003-12-12 14:36:19 |
| Message-ID: | 000201c3c0c8$f8182530$230a0a0a@compaq |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi All,
one of my customers has a Postgres 7.2.3 DB on an RH7.1 box. Running df it
seems that the DB is not on the appropriate filesystem.
/dev/md1 5040352 2562316 2221992 54% /
/dev/md0 100020 8989 85867 10% /boot
/dev/md2 28831612 9800 27357244 1% /data
I suppose md2 was planned for storing the database, but it is on md1
($PGDATA = /var/lib/pgsql/data). Am I right?
md1 is about fulling up in some months, so I think it should be a good idea
to move the store to md2. How can I do this?
Is it enough to copy/move the directory /var/lib/pgsql/data to eg.
/data/pgsql/data and set $PGDATA to that directory?
Thank you,
-- Együd Csaba
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-12-12 14:51:48 | Re: ERROR: JOIN/USING types 'integer' and 'character |
| Previous Message | Chris Travers | 2003-12-12 13:57:06 | Re: [NOVICE] PostgreSQL Training |