Hi,
We have requirement to perform File system based restore of entire PostgreSQL database server to a different mount point.
-> I know that if no user created tablespaces are involved, we have just need to restore the entire DATA directory to new mount point, modify configuration parameters if required and then start the server.
-> If user created table-space directories are involved, then we will have to manually adjust the symbolic links (under pg_tblspc) to the new tablespace directory path and bring up the server.
Adjusting symbolic links is a workaround ( hook! ), is there a any official documentation on how 'PostgreSQL server restore to a different mount point' can be achieved ?
Thanks
Girish