As I implied - I have had no problem porting entire dataspace to a larger partition:<br><br>- stop database service 'sudo /etc/init.d/postgresql stop'<br>- copy entire dataspace to new partition: 'cp -rvf $PGDATA /mnt/newpartion'
<br>- fix permissions on new data ... whatever user your postgres runs as<br>- rename the old partiiton ... cd $PGDATA ; cd .. ; sudo mv data data.sav<br>- make a link 'sudo ln -s /mnt/mynewpartion $PGDATA'<br>- start the database ... 'sudo /etc/init.d/postgresql start'
<br><br>works similarly with mysql too ... lets you roll back<br><br><br><div><span class="gmail_quote">On 3/23/07, <b class="gmail_sendername">rex evans</b> <<a href="mailto:rexfordevans@yahoo.com">rexfordevans@yahoo.com
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Thanks Dave. Your info is encouraging:<br>easy to add disk space to PostgreSQL and mySQL.
<br><br>For context, I should have said I would<br>put this on a PC-type computer running<br>Linux. It would be for development and<br>experimentation only.<br><br>I see that I already misspelled Ingres;<br>oh well.<br><br>
Rex<br><br><br><br><br>____________________________________________________________________________________<br>No need to miss a message. Get email on-the-go<br>with Yahoo! Mail for Mobile. Get started.<br><a href="http://mobile.yahoo.com/mail">
http://mobile.yahoo.com/mail</a><br>_______________________________________________<br>clue-talk mailing list<br><a href="mailto:clue-talk@cluedenver.org">clue-talk@cluedenver.org</a><br><a href="http://www.cluedenver.org/mailman/listinfo/clue-talk">
http://www.cluedenver.org/mailman/listinfo/clue-talk</a><br></blockquote></div><br><br clear="all"><br>-- <br>aloha,<br>dave