On 02/15/2012 06:17 PM, Andreas wrote:
Am 15.02.2012 21:41, schrieb Duaine Hechler:
I have a single Postgres db that I would like to move it into /home.
How can this be done ?
rather easy
make a backup of your database with pg_dump just in case ideally we won't need it, though
shut down the pg server
rcpostgresql stop move the datadirectory somewhere else start yast --> applications --> postgresql --> postgresql_datadirectory set the path to where you like it --> Finish close yast restart the pg server rcpostgresql start
done
WOW .... that was easy. Now, will I have to change that is I need to reinstall from scratch ? Thanks, Duaine -- Duaine Hechler Piano, Player Piano, Pump Organ Tuning, Servicing& Rebuilding Reed Organ Society Member Florissant, MO 63034 (314) 838-5587 dahechler@att.net www.hechlerpianoandorgan.com -- Home& Business user of Linux - 11 years -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org