Re: [opensuse] Moving one Postgres db

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 <http://www.youtube.com/watch?v=nwWwNcMjlsI&feature=related> -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org