Ivan Tomica

Tag: PostgreSQL

Total 2 Posts

PostgreSQL online VACUUM with pg_repack

Those familiar with PostgreSQL know how it internally manages blocks for storing data and how when you delete some entry it is only marked dead (dead tuples). In order to reclaim space VACUUM needs to be run. Vacuuming database won’t give that space back to the operating system, instead, it

Continue Reading

Installing PostgreSQL in FreeBSD jail

To install and run PostgreSQL in FreeBSD jail you’ll need to enable allow.sysvipc system tuneable on that specific jail: List jails: jls Note jail ID and use following command to enable it for that running jail: jail -m jid=JAILID allow.sysvipc=1 This can also be accomplished by changing ezjail jail configuration

Continue Reading