{"id":4272,"date":"2021-01-14T11:33:24","date_gmt":"2021-01-14T17:33:24","guid":{"rendered":"https:\/\/www.logikalsolutions.com\/wordpress\/?p=4272"},"modified":"2023-11-27T18:17:26","modified_gmt":"2023-11-28T00:17:26","slug":"install-postgresql-on-manjaro","status":"publish","type":"post","link":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/","title":{"rendered":"How to Install PostgreSQL on Manjaro"},"content":{"rendered":"\n

How to install PostgreSQL on Manjaro (really any Arch distro) is not straight forward. Worse yet, most of the information you find online about how to do it is outdated fifteen minutes after it is published. You have to be sure the versions match before following the instructions.<\/p>\n\n\n

\n
\"\"
My version<\/figcaption><\/figure>\n<\/div>\n\n\n

You really need to do this one from the terminal.<\/p>\n\n\n\n

<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>pacman<\/span> <\/span>-Ss<\/span> <\/span>postgres<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
That will show you lots of stuff. If you just want to jump, run these two commands.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>pacman<\/span> <\/span>-Sy<\/span> <\/span>postgresql<\/span><\/span>\nsudo<\/span> <\/span>pacman<\/span> <\/span>-Sy<\/span> <\/span>libpqxx<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
The second one many will argue is not needed. Just install it. Technically it is for C\/C++ users doing server development, but quite a few programs using PostgreSQL as their back end need it. Don’t rely on packagers being smart enough to include it as a dependency. <\/p>\n\n\n\n
Oh, don’t get all happy and giddy. This is an Arch based distro, nothing is easy despite the “simplicity” motto.<\/p>\n\n\n
\n
\"\"
It’s still not going to work<\/figcaption><\/figure>\n<\/div>\n\n\n
Most other distros would be really nice and simple. After you installed the server, they would enable and start it for you. Not Arch based distros. Being kind to the user isn’t in the development mantra. <\/p>\n\n\n\n
Part of the reason is you cannot have “One package to rule them all!” This desktop thing is kind of an afterthought in the Arch world. A cute little thing to be passed along as a promotional item like a pen with a company name on it. The bulk of Arch based packaging and development appears to be focused on server markets. Here’s a good example.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>-u<\/span> <\/span>postgres<\/span> <\/span>-i<\/span><\/span>\ninitdb<\/span> <\/span>--locale<\/span> $LANG <\/span>-E<\/span> <\/span>UTF8<\/span> <\/span>-D<\/span> <\/span>'<\/span>\/var\/lib\/postgres\/data\/<\/span>'<\/span><\/span>\nexit<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
You should see something like this:<\/p>\n\n\n
\n
\"\"
Initializing PostgreSQL<\/figcaption><\/figure>\n<\/div>\n\n\n
Most desktop distros just do that (or something like it) for you as part of the POSTINST step. While some super desktop users will have multiple disk drives in their system and now how to automount NAS at boot, John and Jane Q. Public don’t.<\/p>\n\n\n\n
Those of you who happen to have a spare 6TB Western Digital Black internal disk drive in your machine will want to change the directory path because you probably installed that drive just for database use . . . unless you really<\/em> like funny cat videos.<\/p>\n\n\n\n
A Debian Detour<\/h2>\n\n\n\n
On Debian and most other desktop friendly distros, they choose to make the expert users suffer.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>mkdir<\/span> <\/span>\/media\/db_data\/postgres_data<\/span><\/span>\nsudo<\/span> <\/span>chown<\/span> <\/span>postgres:postgres<\/span> <\/span>\/media\/db_data\/postgres_data<\/span><\/span>\npsql<\/span> <\/span>-d<\/span> <\/span>postgres<\/span> <\/span>-c<\/span> <\/span>"<\/span> create tablespace bigspace location '\/media\/db_data\/postgres_data' <\/span>"<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Then you have to explicitly create your tables in that tablespace.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
createdb<\/span> <\/span>--tablespace<\/span> <\/span>bigspace<\/span> <\/span>tax_<\/span>$tax_year <\/span>'<\/span>Tax information for $tax_year<\/span>'<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Yes, parking my PostgreSQL data out on a second disk was painful. Most ordinary<\/em> users only have one disk. Adding insult to injury, if I had to re-install my OS due to drive failure and no current backup, there was actually no way to recover the data in the tablespace. At least there wasn’t back then. I’m very religious about backing up, but that failure caught me at the right time.<\/p>\n\n\n\n
OS\/2 Still Lives<\/h2>\n\n\n\n
There is a method to the madness with the way Manjaro\/Arch distros choose to do this. It just doesn’t work well for the average user. Server focused distros are pushing LVM<\/a>. <\/p>\n\n\n\n
I’m not really trusting this particular history of OS\/2<\/a> and its statements about LVM<\/a>. The reason for my distrust is I ran OS\/2 as my primary desktop for years. The reason is that I never ran a server edition of OS\/2, but I ran LVM for years.<\/p>\n\n\n\n
Logical Volume management was way more important in the OS\/2 days. You have to remember that an 80MEG hard drive was huge<\/em> then. Depending on what flavor of DOS you were running, you couldn’t even partition that entire drive as a single partition. According to this post<\/a> my memory is wrong, but I physically remember running into the partition size limit issue more than once. First time was with my first 40MEG drive and he second time was with my first 80MEG drive.<\/p>\n\n\n\n
With LVM and a SCSI controller allowing for up to six drives you didn’t have these issues. OS\/2 had a drive preparation that would let you dynamically add another drive to the LVM. Is that 80MEG drive getting full? Just add another. Once IBM ripped out most of the really bad Microsoft code, OS\/2Warp 4.5 was a really stable and capable OS. So naturally they abandoned it.<\/p>\n\n\n\n
Pieces of OS\/2 keep showing up because it was ahead of its time. It had better memory management and networking than any Microsoft product of the day or many years to follow. In particular, LVM was something of a crown jewel. As a parting thumb in the eye of Microsoft, IBM OpenSourced LVM and it found its way into Linux.<\/p>\n\n\n\n
The Method to the Madness<\/h2>\n\n\n\n
Some Linux distros are defaulting to LVM for the primary installation target, others are not. I will leave it up to the reader to click the links and do the research.<\/p>\n\n\n\n
This long winded tale is explaining why opted to not be nice to the user. A sysadmin is going to want to point PostgreSQL to an LVM or network storage appliance providing hundreds, perhaps thousands of Terabytes of storage. An ordinary desktop user has one disks.<\/p>\n\n\n\n
Your Final Step<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>systemctl<\/span> <\/span>enable<\/span> <\/span>--now<\/span> <\/span>postgresql.service<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
You should be good to go!<\/p>\n\n\n
\n
\"\"
Add yourself as a super user<\/figcaption><\/figure>\n<\/div>\n\n\n
There are those who offer up the argument for adding yourself to the postgres group. I’ve never done it. If you are really bothered by the createuser command not being able to change directory to your home then I guess you can. Just don’t forget to also change the group on your directory.<\/p>\n\n\n
\n
\"\"
groups and permissions<\/figcaption><\/figure>\n<\/div>\n\n\n
If you want to understand more about Linux groups and file permissions, start here<\/a>.<\/p>\n\n\n\n
The Arch Bug<\/h2>\n\n\n\n
When you install PostgreSQL on Manjaro you run into the Arch bug. Manjaro is Arch Linux based. When you hear about Linux being an “expert friendly” operating system with an uninviting community, you are most likely hearing a story about someone’s adventure into Arch. Just signing up for the user forum should tell you what you are in for.<\/p>\n\n\n\n
\"\"
Arch forum registration greeting<\/figcaption><\/figure>\n\n\n\n
Basically, the bug is Arch deciding to change a default from false to true. So, if you’ve been using my xpnsqt application to keep track of your expenses for filing taxes; (Tax season is just around the corner people!) you will see something like this when you try to load your CSV backup files.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
'\/home\/roland\/postgres_tax_backups\/tax_2019_payees.csv'<\/span> -<\/span>><\/span> <\/span>'<\/span>\/tmp\/tax_2019_payees.csv<\/span>'<\/span><\/span>\n <\/span>'\/home\/roland\/postgres_tax_backups\/tax_2020_categories.csv'<\/span> -<\/span>><\/span> <\/span>'<\/span>\/tmp\/tax_2020_categories.csv<\/span>'<\/span><\/span>\n <\/span>'\/home\/roland\/postgres_tax_backups\/tax_2020_expenses.csv'<\/span> -<\/span>><\/span> <\/span>'<\/span>\/tmp\/tax_2020_expenses.csv<\/span>'<\/span><\/span>\n <\/span>'\/home\/roland\/postgres_tax_backups\/tax_2020_payees.csv'<\/span> -<\/span>><\/span> <\/span>'<\/span>\/tmp\/tax_2020_payees.csv<\/span>'<\/span><\/span>\n <\/span>;;;;;<\/span><\/span>\n <\/span>;;;;;<\/span><\/span>\n <\/span>;;;;;<\/span>   <\/span>Loading<\/span> <\/span>1992<\/span><\/span>\n <\/span>;;;;;<\/span><\/span>\n <\/span>;;;;;<\/span><\/span>\n <\/span>creating<\/span> <\/span>tax<\/span> <\/span>tables<\/span><\/span>\n    <\/span>Importing<\/span> <\/span>\u2026<\/span>  <\/span>1992<\/span><\/span>\n <\/span>psql:import_it.sql:1:<\/span> <\/span>ERROR:<\/span>  <\/span>could<\/span> <\/span>not<\/span> <\/span>open<\/span> <\/span>file<\/span> <\/span>"<\/span>\/tmp\/tax_1992_payees.csv<\/span>"<\/span> <\/span>for<\/span> <\/span>reading:<\/span> <\/span>No<\/span> <\/span>such<\/span> <\/span>file<\/span> <\/span>or<\/span> <\/span>directory<\/span><\/span>\n <\/span>HINT:<\/span>  <\/span>COPY<\/span> <\/span>FROM<\/span> <\/span>instructs<\/span> <\/span>the<\/span> <\/span>PostgreSQL<\/span> <\/span>server<\/span> <\/span>process<\/span> <\/span>to<\/span> <\/span>read<\/span> <\/span>a<\/span> <\/span>file.<\/span> <\/span>You<\/span> <\/span>may<\/span> <\/span>want<\/span> <\/span>a<\/span> <\/span>client-side<\/span> <\/span>facility<\/span> <\/span>such<\/span> <\/span>as<\/span> <\/span>psql<\/span>'<\/span>s \\copy.<\/span><\/span>\n psql:import_it.sql:2: ERROR:  could not open file "\/tmp\/tax_1992_categories.csv" for reading: No such file or directory<\/span><\/span>\n HINT:  COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql<\/span>'<\/span>s<\/span> \\c<\/span>opy.<\/span><\/span>\n <\/span>psql:import_it.sql:3:<\/span> <\/span>ERROR:<\/span>  <\/span>could<\/span> <\/span>not<\/span> <\/span>open<\/span> <\/span>file<\/span> <\/span>"<\/span>\/tmp\/tax_1992_expenses.csv<\/span>"<\/span> <\/span>for<\/span> <\/span>reading:<\/span> <\/span>No<\/span> <\/span>such<\/span> <\/span>file<\/span> <\/span>or<\/span> <\/span>directory<\/span><\/span>\n <\/span>HINT:<\/span>  <\/span>COPY<\/span> <\/span>FROM<\/span> <\/span>instructs<\/span> <\/span>the<\/span> <\/span>PostgreSQL<\/span> <\/span>server<\/span> <\/span>process<\/span> <\/span>to<\/span> <\/span>read<\/span> <\/span>a<\/span> <\/span>file.<\/span> <\/span>You<\/span> <\/span>may<\/span> <\/span>want<\/span> <\/span>a<\/span> <\/span>client-side<\/span> <\/span>facility<\/span> <\/span>such<\/span> <\/span>as<\/span> <\/span>psql<\/span>'<\/span>s \\copy.<\/span><\/span>\n  setval <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Since roughly the 1970s \/tmp has been that unprotected no-mans land where you didn’t leave stuff sit for long. Most distros point temp environment variables for each user to \/tmp\/user-name and make that a directory owned by the user. This gives you some<\/em> protection.<\/p>\n\n\n\n
You know, the average schmoe using Linux at home or work doesn’t know much about Linux really. They’ve always used a desktop and only open a terminal when it is absolutely necessary.<\/p>\n\n\n\n
Sysadmins on the other hand, should know all about systemctl overrides. They also would have been the only one who wanted this turned on. Seriously, there is no account information with my xpnsqt thing. I suspect there is no account information in your recipe database. How about the database you created to keep track of your music collection? DVDs?<\/p>\n\n\n\n
When you install PostgreSQL on Manjaro – The Schmoe Tactic<\/h2>\n\n\n\n
At some point everyone is a schmoe because he universe likes to laugh at people. The schmoe approach will do just enough research to find out what value they need to change.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
cd<\/span> <\/span>\/usr\/lib\/systemd\/system<\/span><\/span>\nsudo<\/span> <\/span>cp<\/span> <\/span>postgresql.service<\/span> <\/span>postgresql.service_original<\/span><\/span>\nsudo<\/span> <\/span>jed<\/span> <\/span>postgresql.service<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
\n
\"\"
PrivateTmp needs to be false<\/figcaption><\/figure>\n<\/div>\n\n\n
Save an exit. The dutiful schmoe will then do the following:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>cp<\/span> <\/span>postgresql.service<\/span> <\/span>postgresql.service_fixed<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
When you install PostgreSQL on Manjaro – Shoulda Done<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>systemctl<\/span> <\/span>edit<\/span> <\/span>postgresql.service<\/span><\/span><\/code><\/pre><\/div>\n\n\n
\n
\"\"
Override file<\/figcaption><\/figure>\n<\/div>\n\n\n
The dark lore of the override file won’t be immediately obvious. You cannot just override the value. You have to override the value under a tag\/section whatever the name is this week.<\/p>\n\n\n\n
Yeah, Arch did this to you. Every other distro I’ve used realizes your typical desktop user won’t know how to fix this. Far too many will be a schmoe, constantly fixing that file.<\/p>\n\n\n\n
No Matter Which Approach<\/h2>\n\n\n\n
No matter which approach you take, your changes will not take effect until you either reboot or restart PostgreSQL.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>systemctl<\/span> <\/span>restart<\/span> <\/span>postgresql<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Related posts:<\/p>\n\n\n\n
How to install JED from AUR on Manjaro<\/a><\/p>\n\n\n\n
How to make Manjaro KDE work with NAS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
How to install PostgreSQL on Manjaro (really any Arch distro) is not straight forward. Worse yet, most of the information you find online about how to do it is outdated fifteen minutes after it is published. You have to be sure the versions match before following the instructions. You really need to do this one from the terminal. That will show you lots of stuff. If you just want to jump, run these two commands. … How to Install PostgreSQL on Manjaro<\/span>Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":4217,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[1904,1900,1381],"class_list":["post-4272","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-information-technology","tag-lvm","tag-manjaro","tag-postgresql","bnm-entry"],"yoast_head":"\nHow to Install PostgreSQL on Manjaro – Logikal Blog<\/title>\n<meta name=\"description\" content=\"When you need a real database on Linux you need PostgreSQL. This post will teach you how to install PostgreSQL on Manjaro.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Install PostgreSQL on Manjaro – Logikal Blog\" \/>\n<meta property=\"og:description\" content=\"When you need a real database on Linux you need PostgreSQL. This post will teach you how to install PostgreSQL on Manjaro.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/\" \/>\n<meta property=\"og:site_name\" content=\"Logikal Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-14T17:33:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-28T00:17:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.logikalsolutions.com\/wordpress\/wp-content\/uploads\/2021\/01\/i5-with-super-floppy.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1920\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"seasoned_geek\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"seasoned_geek\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/information-technology\\\/install-postgresql-on-manjaro\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/information-technology\\\/install-postgresql-on-manjaro\\\/\"},\"author\":{\"name\":\"seasoned_geek\",\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/c077f770ade13de7faaf616c3eac6842\"},\"headline\":\"How to Install PostgreSQL on Manjaro\",\"datePublished\":\"2021-01-14T17:33:24+00:00\",\"dateModified\":\"2023-11-28T00:17:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/information-technology\\\/install-postgresql-on-manjaro\\\/\"},\"wordCount\":1428,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/c077f770ade13de7faaf616c3eac6842\"},\"image\":{\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/information-technology\\\/install-postgresql-on-manjaro\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/i5-with-super-floppy.jpeg\",\"keywords\":[\"LVM\",\"Manjaro\",\"PostgreSQL\"],\"articleSection\":[\"Information Technology\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/information-technology\\\/install-postgresql-on-manjaro\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/information-technology\\\/install-postgresql-on-manjaro\\\/\",\"url\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/information-technology\\\/install-postgresql-on-manjaro\\\/\",\"name\":\"How to Install PostgreSQL on Manjaro – Logikal Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/information-technology\\\/install-postgresql-on-manjaro\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/information-technology\\\/install-postgresql-on-manjaro\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/i5-with-super-floppy.jpeg\",\"datePublished\":\"2021-01-14T17:33:24+00:00\",\"dateModified\":\"2023-11-28T00:17:26+00:00\",\"description\":\"When you need a real database on Linux you need PostgreSQL. This post will teach you how to install PostgreSQL on Manjaro.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/information-technology\\\/install-postgresql-on-manjaro\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/information-technology\\\/install-postgresql-on-manjaro\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/information-technology\\\/install-postgresql-on-manjaro\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/i5-with-super-floppy.jpeg\",\"contentUrl\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/i5-with-super-floppy.jpeg\",\"width\":1920,\"height\":1440,\"caption\":\"i5 with super floppy\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/information-technology\\\/install-postgresql-on-manjaro\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install PostgreSQL on Manjaro\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/\",\"name\":\"Logikal Blog\",\"description\":\"For people with attention spans longer than a Tweet\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/c077f770ade13de7faaf616c3eac6842\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/c077f770ade13de7faaf616c3eac6842\",\"name\":\"seasoned_geek\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ae9adac14079d84b909e635d7af986fe4568053af4fd9ff8d4109298c392493e?s=96&d=mm&r=r\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ae9adac14079d84b909e635d7af986fe4568053af4fd9ff8d4109298c392493e?s=96&d=mm&r=r\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ae9adac14079d84b909e635d7af986fe4568053af4fd9ff8d4109298c392493e?s=96&d=mm&r=r\",\"caption\":\"seasoned_geek\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ae9adac14079d84b909e635d7af986fe4568053af4fd9ff8d4109298c392493e?s=96&d=mm&r=r\"},\"description\":\"Roland Hughes started his IT career in the early 1980s. He quickly became a consultant and president of Logikal Solutions, a software consulting firm specializing in OpenVMS application and C++\\\/Qt touchscreen\\\/embedded Linux development. Early in his career he became involved in what is now called cross platform development. Given the dearth of useful books on the subject he ventured into the world of professional author in 1995 writing the first of the \\\"Zinc It!\\\" book series for John Gordon Burke Publisher, Inc. A decade later he released a massive (nearly 800 pages) tome \\\"The Minimum You Need to Know to Be an OpenVMS Application Developer\\\" which tried to encapsulate the essential skills gained over what was nearly a 20 year career at that point. From there \\\"The Minimum You Need to Know\\\" book series was born. Three years later he wrote his first novel \\\"Infinite Exposure\\\" which got much notice from people involved in the banking and financial security worlds. Some of the attacks predicted in that book have since come to pass. While it was not originally intended to be a trilogy, it became the first book of \\\"The Earth That Was\\\" trilogy: Infinite Exposure Lesedi - The Greatest Lie Ever Told John Smith - Last Known Survivor of the Microsoft Wars When he is not consulting Roland Hughes posts about technology and sometimes politics on his blog. He also has regularly scheduled Sunday posts appearing on the Interesting Authors blog.\",\"sameAs\":[\"https:\\\/\\\/theminimumyouneedtoknow.com\"],\"url\":\"https:\\\/\\\/www.logikalsolutions.com\\\/wordpress\\\/author\\\/seasoned_geek\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Install PostgreSQL on Manjaro – Logikal Blog","description":"When you need a real database on Linux you need PostgreSQL. This post will teach you how to install PostgreSQL on Manjaro.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/","og_locale":"en_US","og_type":"article","og_title":"How to Install PostgreSQL on Manjaro – Logikal Blog","og_description":"When you need a real database on Linux you need PostgreSQL. This post will teach you how to install PostgreSQL on Manjaro.","og_url":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/","og_site_name":"Logikal Blog","article_published_time":"2021-01-14T17:33:24+00:00","article_modified_time":"2023-11-28T00:17:26+00:00","og_image":[{"width":2560,"height":1920,"url":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-content\/uploads\/2021\/01\/i5-with-super-floppy.jpeg","type":"image\/jpeg"}],"author":"seasoned_geek","twitter_card":"summary_large_image","twitter_misc":{"Written by":"seasoned_geek","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/#article","isPartOf":{"@id":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/"},"author":{"name":"seasoned_geek","@id":"https:\/\/www.logikalsolutions.com\/wordpress\/#\/schema\/person\/c077f770ade13de7faaf616c3eac6842"},"headline":"How to Install PostgreSQL on Manjaro","datePublished":"2021-01-14T17:33:24+00:00","dateModified":"2023-11-28T00:17:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/"},"wordCount":1428,"commentCount":2,"publisher":{"@id":"https:\/\/www.logikalsolutions.com\/wordpress\/#\/schema\/person\/c077f770ade13de7faaf616c3eac6842"},"image":{"@id":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/#primaryimage"},"thumbnailUrl":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-content\/uploads\/2021\/01\/i5-with-super-floppy.jpeg","keywords":["LVM","Manjaro","PostgreSQL"],"articleSection":["Information Technology"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/","url":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/","name":"How to Install PostgreSQL on Manjaro – Logikal Blog","isPartOf":{"@id":"https:\/\/www.logikalsolutions.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/#primaryimage"},"image":{"@id":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/#primaryimage"},"thumbnailUrl":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-content\/uploads\/2021\/01\/i5-with-super-floppy.jpeg","datePublished":"2021-01-14T17:33:24+00:00","dateModified":"2023-11-28T00:17:26+00:00","description":"When you need a real database on Linux you need PostgreSQL. This post will teach you how to install PostgreSQL on Manjaro.","breadcrumb":{"@id":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/#primaryimage","url":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-content\/uploads\/2021\/01\/i5-with-super-floppy.jpeg","contentUrl":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-content\/uploads\/2021\/01\/i5-with-super-floppy.jpeg","width":1920,"height":1440,"caption":"i5 with super floppy"},{"@type":"BreadcrumbList","@id":"https:\/\/www.logikalsolutions.com\/wordpress\/information-technology\/install-postgresql-on-manjaro\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.logikalsolutions.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"How to Install PostgreSQL on Manjaro"}]},{"@type":"WebSite","@id":"https:\/\/www.logikalsolutions.com\/wordpress\/#website","url":"https:\/\/www.logikalsolutions.com\/wordpress\/","name":"Logikal Blog","description":"For people with attention spans longer than a Tweet","publisher":{"@id":"https:\/\/www.logikalsolutions.com\/wordpress\/#\/schema\/person\/c077f770ade13de7faaf616c3eac6842"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.logikalsolutions.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.logikalsolutions.com\/wordpress\/#\/schema\/person\/c077f770ade13de7faaf616c3eac6842","name":"seasoned_geek","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ae9adac14079d84b909e635d7af986fe4568053af4fd9ff8d4109298c392493e?s=96&d=mm&r=r","url":"https:\/\/secure.gravatar.com\/avatar\/ae9adac14079d84b909e635d7af986fe4568053af4fd9ff8d4109298c392493e?s=96&d=mm&r=r","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ae9adac14079d84b909e635d7af986fe4568053af4fd9ff8d4109298c392493e?s=96&d=mm&r=r","caption":"seasoned_geek"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/ae9adac14079d84b909e635d7af986fe4568053af4fd9ff8d4109298c392493e?s=96&d=mm&r=r"},"description":"Roland Hughes started his IT career in the early 1980s. He quickly became a consultant and president of Logikal Solutions, a software consulting firm specializing in OpenVMS application and C++\/Qt touchscreen\/embedded Linux development. Early in his career he became involved in what is now called cross platform development. Given the dearth of useful books on the subject he ventured into the world of professional author in 1995 writing the first of the \"Zinc It!\" book series for John Gordon Burke Publisher, Inc. A decade later he released a massive (nearly 800 pages) tome \"The Minimum You Need to Know to Be an OpenVMS Application Developer\" which tried to encapsulate the essential skills gained over what was nearly a 20 year career at that point. From there \"The Minimum You Need to Know\" book series was born. Three years later he wrote his first novel \"Infinite Exposure\" which got much notice from people involved in the banking and financial security worlds. Some of the attacks predicted in that book have since come to pass. While it was not originally intended to be a trilogy, it became the first book of \"The Earth That Was\" trilogy: Infinite Exposure Lesedi - The Greatest Lie Ever Told John Smith - Last Known Survivor of the Microsoft Wars When he is not consulting Roland Hughes posts about technology and sometimes politics on his blog. He also has regularly scheduled Sunday posts appearing on the Interesting Authors blog.","sameAs":["https:\/\/theminimumyouneedtoknow.com"],"url":"https:\/\/www.logikalsolutions.com\/wordpress\/author\/seasoned_geek\/"}]}},"_links":{"self":[{"href":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-json\/wp\/v2\/posts\/4272","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-json\/wp\/v2\/comments?post=4272"}],"version-history":[{"count":0,"href":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-json\/wp\/v2\/posts\/4272\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-json\/wp\/v2\/media\/4217"}],"wp:attachment":[{"href":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-json\/wp\/v2\/media?parent=4272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-json\/wp\/v2\/categories?post=4272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.logikalsolutions.com\/wordpress\/wp-json\/wp\/v2\/tags?post=4272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Why? Because every update will probably walk on this file. The dutiful schmoe can use a diff utility like Meld<\/a> to compare the before and after so they can remember what needed to be fixed.<\/p>\n\n\n\n
You may not have jed installed<\/a>. You should, but you probably didn’t install it. Use nano or whatever terminal emulator you have installed.<\/p>\n\n\n