"dev.pho" <dev(dot)pho(at)gmail(dot)com> wrote:
> I was wondering if I could restore the database from the location
> of the tablespace.
It's not clear exactly what you want to do. Have you read through
the documentation on backup and restore?:
http://www.postgresql.org/docs/8.4/interactive/backup.html
Perhaps you want to follow the instructions for "File System Level
Backup", or maybe PITR?
-Kevin