CommunityNews
Managing Multiple PostgreSQL Instances on FreeBSD
FreeBSD allows the management of multiple instances of PostgreSQL by means of
rc.conf(5).
The trick is to use profiles , that are available for the PostgreSQL rc script (/usr/local/etc/rc.d/postgresql) even if not well documented, at least in my opinion.
In order to understand how to deal with multiple PostgreSQL instances, consider a system with two cluster: test and prod .
In/etc/rc.confyou need to define thepostgresql_profilesvariable, where you list the clusters separated by spaces. Then, for each profile, you define the well knowpostgresql_xxxvariables, specifying the profile name before the variable suffix. For example, to define aPGDATA, that will be usually defined intopostgresql_datavariable, you need to specify apostgresql_<profile-name>_datavariable.
Therefore, in/etc/rc.confyou need to specify the following…
This thread was posted by one of our members via one of our news source trackers.
Popular Backend topics
Other popular topics
Categories:
Sub Categories:
Popular Portals
- /elixir
- /rust
- /ruby
- /wasm
- /erlang
- /phoenix
- /keyboards
- /rails
- /python
- /js
- /security
- /go
- /swift
- /vim
- /clojure
- /emacs
- /haskell
- /java
- /svelte
- /onivim
- /typescript
- /kotlin
- /c-plus-plus
- /crystal
- /tailwind
- /react
- /gleam
- /ocaml
- /flutter
- /elm
- /vscode
- /ash
- /opensuse
- /html
- /centos
- /php
- /deepseek
- /zig
- /scala
- /sublime-text
- /textmate
- /lisp
- /react-native
- /nixos
- /debian
- /agda
- /kubuntu
- /arch-linux
- /django
- /revery
- /ubuntu
- /manjaro
- /spring
- /deno
- /nodejs
- /diversity
- /lua
- /julia
- /c
- /slackware






