When PGSQL is installed, it creates two default tablespaces, postgres and pg_default. When a user creates a new database he is opted to select a tablespace from the above two. Do I need to create a different tablespace before creating a database in order to prevent playing with these default tablespaces? While backing up the database, with a new tablespace, is new tablespace also backed up and automatically created when the backup is restored on another machine? -- View this message in context: http://www.nabble.com/Tablespace-tf4219398.html#a12003755 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
