Re: Moving the database from a filesystem to another

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: csegyud(at)vnet(dot)hu
Cc: "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Moving the database from a filesystem to another
Date: 2003-12-12 16:22:32
Message-ID: 87pteungzb.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Együd Csaba <csegyud(at)vnet(dot)hu> writes:

> 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?

Yes, this is pretty much all you need to do. Just make sure you
preserve the ownership and permissions when you copy the data over...

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bret Busby 2003-12-12 16:31:55 Re: [NOVICE] PostgreSQL Training
Previous Message Josué Maldonado 2003-12-12 16:13:47 Uninstall postgres 7.4