hi, i cant afford to move the database to another location.. i will still end up on lack of disk space.. i was thinking if theres a way in version 7.3.4 to move tables on a different partition or when ever i create new tables it automatically create files on a diff partition..
tia, On Tuesday 14 December 2004 14:57, Michael Fuhr wrote: > On Tue, Dec 14, 2004 at 02:04:08PM +0800, Jerome Macaranas wrote: > > On Monday 13 December 2004 14:52, Shridhar Daithankar wrote: > > > You could use tablespaces in postgresql 8.0.. > > > > Im using 7.3.4 is there another way? > > See my earlier followup in this thread: > > http://search.postgresql.org/pgsql-general/2004-12/msg00534.php > > Here are links to the referenced documentation for 7.3: > > http://www.postgresql.org/docs/7.3/static/manage-ag-alternate-locs.html > http://www.postgresql.org/docs/7.3/static/app-initlocation.html > http://www.postgresql.org/docs/7.3/static/sql-createdatabase.html > > I'd recommend testing this before doing it on a production server. > I've never done it myself so I don't know if there are any potential > problems. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly