For those who are interested in installing and using PostgreSQL in Haiku, here are the installation steps that I captured from the terminal:
Welcome to the Haiku shell.
~> mkdir /boot/pgdb
~> initdb -D /boot/pgdb -U postgres -W
The files belonging to this database system will be owned by user “user”.
This user must also own the server process.
The database cluster will be initialized with locale “en.UTF-8”.
The default database encoding has accordingly been set to “UTF8”.
The default text search configuration will be set to “english”.
Data page checksums are disabled.
Enter new superuser password:
Enter it again:
fixing permissions on existing directory /boot/pgdb … ok
creating subdirectories … ok
selecting default max_connections … 100
selecting default shared_buffers … 128MB
selecting dynamic shared memory implementation … posix
creating configuration files … ok
running bootstrap script … ok
performing post-bootstrap initialization … ok
syncing data to disk … ok
WARNING: enabling “trust” authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
–auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg_ctl -D /boot/pgdb -l logfile start
~> pg_ctl -D /boot/pgdb -l logfile start
waiting for server to start… done
server started
~> createdb -h 127.0.0.1 -e library -U postgres -W
Password:
SELECT pg_catalog.set_config(‘search_path’, ‘’, false)
CREATE DATABASE library;
~>
~> psql -h 127.0.0.1 library -U postgres -W
Password:
psql (11.1)
Type “help” for help.
library=#
library-# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------±--------±---------±---------±---------±--------------------
library | postgres | UTF8 | en.UTF-8 | en.UTF-8 |
postgres | postgres | UTF8 | en.UTF-8 | en.UTF-8 |
template0 | postgres | UTF8 | en.UTF-8 | en.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en.UTF-8 | en.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
(4 rows)
library-#\q
~> pg_ctl -D /boot/pgdb -l logfile stop
waiting for server to shut down… done
server stopped
~> exit
I have used postgreSQL version in BeOS, ZetaOS, and now in Haiku! It is extremely fast in Haiku…I will eventually start tuning the instance once I migrate some of my larger DBs into it.
Enjoy!!