RE: [cobalt-users] Moving PostgreSQL

["Gavin Nelmes-Crocker" <cobalt@xxxxxxxxxxxxxxxx>]

> I have an XTR machine which I am using to host a PHP/PostgreSQL system. I
> have everything up and running perfectly well, but I noticed that the
> postgres data is stored on /var, whose partition is significantly smaller
> than /home. I'd really like to move all of the data onto home, and was
> wondering if anyone had done this without breaking anything?
>
> Can I simply move everything and create a sym link from /var/lib/pgsql to
> /home/pgsql??

James I don't know what doing that will do - but bear in mind the postgres
database is on there for the GUI and admin purposes and for no other reason.
The fact that you can access it and use it in some ways a risk - if it is
one you are happy to take carry on.

My Advice to you would be to move your database over to MySQL and keep it
separate from the GUI and admin functions altogether, you are only asking
for pain.

Okay now onto what to do if you carry on.  Few people on this list including
myself have access to XTRs so I am going on my experience and knowledge from
when I worked at Cobalt and helped in the testing phase (twice as some
things were missed and something's were ignored) If postgress stores its
DB's in the same way as MySQL then I would think you would have no problem
you might have to make a hard link to get it to work.

Bear in mind if you try this don't do it with a live box and you may kill
it - several people on this list have had to rebuild the database on RaQ3
and 4 and there are some scripts to help but I don't know if any of them
have ever done it on an XTR so boldly go.

Regards

Gavin