Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PostgreSQL with different data directories

Today I installed PostgreSQL to work with. When I was reading the documentation, I found there can be more than one data directory present. Is it more than one data directory for single installation ? Or I understood wrongly ?

In my installation, data directory is in

C:\Program Files\PostgreSQL\8.3\data

if it can be more than one data directory for single installation, how will be the directory structure ?

like image 581
Lolly Avatar asked Apr 11 '26 08:04

Lolly


1 Answers

I think you mean a tablespace, please check the manual: CREATE TABLESPACE

like image 52
Frank Heikens Avatar answered Apr 26 '26 13:04

Frank Heikens



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!