On Wed, 2012-02-15 at 15:49 -0600, Duaine Hechler wrote:
On 02/15/2012 03:07 PM, Adam Tauno Williams wrote:
I have a single Postgres db that I would like to move it into /home. How can this be done ?
On Wed, 2012-02-15 at 14:41 -0600, Duaine Hechler wrote: pg_dump / pg_restore ? Seriously, that is the only way I'd move an individual database. But I'm not sure what you mean by "move it into /home". It's for my home business accounting and every time I upgrade, I keep getting into trouble - somehow - and have to scramble to get it restored.
Moving it won't help that. If you have a database you are regularly using you need to regularly pg_dump. Setup a script for yourself and potentially a cron task just to do that at some interval. -- System & Network Administrator [ LPI & NCLA ] <http://www.whitemiceconsulting.com> OpenGroupware Developer <http://www.opengroupware.us> Adam Tauno Williams -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org