PostgreSQL 11.1 Install on H1B1 (64-bit) Notes

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!!

1 Like

I successfully installed SQL Workbench/J and SQL Power Architect software to manage the PostgreSQL databases. After configuring both to get the fonts working correctly, look at the attached pic to see it in action:

SQL%20Workbench_J%20in%20action

Have fun everyone!!

3 Likes

… before i use oracle sqldeveloper can run on haiku… i’m not test again lately