[clue-talk] DB footprint Oracle,Mysql,Ingress

[Dave Price]

As I implied - I have had no problem porting entire dataspace to a larger
partition:

- stop database service  'sudo /etc/init.d/postgresql stop'
- copy entire dataspace to new partition: 'cp -rvf $PGDATA /mnt/newpartion'
- fix permissions on new data ... whatever user your postgres runs as
- rename the old partiiton ... cd $PGDATA ; cd .. ; sudo mv data data.sav
- make a link 'sudo ln -s /mnt/mynewpartion $PGDATA'
- start the database ... 'sudo /etc/init.d/postgresql start'

works similarly with mysql too ... lets you roll back


On 3/23/07, rex evans <rexfordevans at yahoo.com> wrote:
>
> Thanks Dave. Your info is encouraging:
> easy to add disk space to PostgreSQL and mySQL.
>
> For context, I should have said I would
> put this on a PC-type computer running
> Linux. It would be for development and
> experimentation only.
>
> I see that I already misspelled Ingres;
> oh well.
>
> Rex
>
>
>
>
>
> ____________________________________________________________________________________
> No need to miss a message. Get email on-the-go
> with Yahoo! Mail for Mobile. Get started.
> http://mobile.yahoo.com/mail
> _______________________________________________
> clue-talk mailing list
> clue-talk at cluedenver.org
> http://www.cluedenver.org/mailman/listinfo/clue-talk
>



-- 
aloha,
dave
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cluedenver.org/pipermail/clue-talk/attachments/20070323/fd0b1825/attachment-0002.html