Postgres file structure doubt

Hi everyone,

 

Got a doubt in my setup, please correct me if I'm wrong.

 

In my postgres setup,

/usr/local/pgsql (where postgres install)

/usr/local/pgsql/data (PGDATA)

/database/pg/mydata (tablespace which use for all the table I create)

/database/pg/myindex (index which use for all the table I create)

 

1) In this setup, the actual user data are store in PGDATA

the table structure & index are store in /database/pg/mydata & /database/pg/myindex

 

Am I correct?

 

2) So to backup (not pg_dump), I should make sure it include these 2 folder right?

 

3) I think my setup is not quite right, I should move the PGDATA to /database/pg right?

 

 

Regards

Louis