Thread: Separating a single database into different disks

<div style="background-color:"><div class="RTE">I wanted to find out how I can split one database into different disk
partitions.I will very soon be running out of data space . What is the best (safest) way to do this. Any links to docs,
ideasappreciated !!!! Urgent!</div><div class="RTE">Thanks</div><div class="RTE">Sally</div><div
class="RTE"> </div><divclass="RTE"> </div></div><br clear="all" /><hr /><a
href="http://g.msn.com/8HMAENUS/2731??PS=">Thereare now three new levels of MSN Hotmail Extra Storage! Learn more.</a> 

What exactly is the SQL_ASCII encoding in postgres? I have a pg installation
with an SQL_ASCII server encoding and my database (also SQL_ASCII) seems to
be able to handle all types of encodings? how is this possible? is this what
the server & db encoding needs to be set to in order to handle various
encodings?
Also is there a way of dumping data from an SQL_ASCII db to a UNICODE db.
Creating a dump and converting with a tool like iconv is probably not an
option since the data in the SQL_ASCII db has unknown/inconsistant encoding.
Please let me know as soon as possible.
Thanks.
Salem
P.S. {I sent a similar e-mail earlier which wasn't posted on the site. ??}