Hi,
I m created tablespace on d drive. My database and tables are stored in to this tablespace. now i m uninstalled the postgresql8.4, and then install again. so how can i restore or recover my database and tables which is already created in tablespace..?

It mean Recover database and tables from tablespace after reinstall postgresql8.4.. ?

Is there any way to recover database and tables which is stored in tablespace on d drive.. ?

-- Hiren Lad

If you did not run pg_dump on your database(s) before uninstalling PostgreSQL, then they're gone.