Re: A question on PSQL 8.3 setup

On Thu, Jul 23, 2009 at 01:08:26AM -0600, Jong Chun Park wrote:
> I need to configure PSQL to store all DB-related data into
> /home/pgsql/data instead of somewhere in / such as /var/lib/
> postgresql/8.3/... or /usr/local/pgsql/data.

Assuming you're using the standard builds in Ubuntu, I'd probably do
something like:

1) make your directory if you haven't got one already:
mkdir /home/postgres
chown postgres:postgres /home/postgres

2) shut down postgres
/etc/init.d/postgres-8.3 stop

3) copy the existing database cluster over to its new location
cp -a /var/lib/postgresql/8.3 /home/postgres

4) move the old cluster out of the way for safe keeping and put a
symlink back in place
mv /var/lib/postgresql/8.3 /var/lib/postgresql/8.3-old
ln -s /home/postgres/8.3 /var/lib/postgresql/8.3

5) start PG again
/etc/init.d/postgres-8.3 start

if that all works then you've got the option of dumping the old data
that was stashed away above and update the config file to point straight
to the new location.

--
Sam http://samason.me.uk/