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.