Mailinglist Archive: opensuse (1483 mails)

[Andreas <maps.on@xxxxxxx>]

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@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse+owner@xxxxxxxxxxxx