Loading

Postgres is running on v10, in these server I have 4 databases are run

Sanjay Kumar

Hi All, Greetings!! Postgres is running on v10, in these server I have 4 databases are running, each database has seperate tablespace.Now if I want to upgrade to v11 will I change the tablespace to pg_default or normally after prechecks should I proceed for pg_upgrade?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
Accepted answer
Hello Sanjay,

I *think* pg_upgrade will handle them cleanly (you need to provide new directories on the respective filesystems, iirc). However, I recommend to go straight to 13, then you'll not have to fiddle around with this in a year again!