Re: Moving the database from a filesystem to another - Mailing list pgsql-general

From Doug McNaught
Subject Re: Moving the database from a filesystem to another
Date
Msg-id 87pteungzb.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Moving the database from a filesystem to another  (Együd Csaba <csegyud@vnet.hu>)
List pgsql-general
Együd Csaba <csegyud@vnet.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

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: [NOVICE] PostgreSQL Training
Next
From: Bret Busby
Date:
Subject: Re: [NOVICE] PostgreSQL Training