moving postgresql main folder out of /var/lib/postgresql/9.4

Question

I have a debian installed server, where I have used apt to install pgsql9.4 a few months ago. Now, after a month, I see that the folder totals to 19GB:

/var/lib/postgresql/9.4/main

is taking up all my space of rootfs (19GB). Agreed, I am writing some heavy UTf-8 stuff onto the instance.

It is probably daft to ask, but, is there a way I can move this folder/installation in postgres to another disk? and still not affect my db? Can this be even done?

Community · Accepted Answer · 2020-06-20 09:12:55Z

5

Sure you can.

Stop the PostgreSQL server.

/etc/init.d/postgresql stop
Move the data directory somewhere else.

mv /var/lib/postgresql/9.4/main /storage/ssd/
Make a symlink pointing to the new location.

ln -s /storage/ssd/main /var/lib/postgresql/9.4/main
Start the PostgreSQL server.

/etc/init.d/postgresql start

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Feb 9, 2015 at 16:48

Kouber Saparev

8,2552 gold badges32 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JohnJ Over a year ago

Wow.. that was simple.. I thought it would be complicated! Thanks so much.. Works like a charm.. :) Accepted your answer.

Collectives™ on Stack Overflow

moving postgresql main folder out of /var/lib/postgresql/9.4

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related