postgresql

Hi, FYI: if you run into issues like segfaults with postgresql client connections and you have KTLS enabled (enabled in kernel and "Options = KTLS" in openssl.cnf), disable KTLS (e.g. in openssl.cnf on the client side) and it will work again. Seems there is some kind of incombatibility for at...

Hi all, I have problem with PostgreSQL in my FreeBSD, previously it's working fine but now I can't start the PostgreSQL services. I'm using PostgreSQL version 13.8. When I try to run sudo service postgresql start, the result is: 022-11-10 13:51:36.604 WIB [32618] LOG: ending log output to...

I am doing a step-by-step upgrade of the postgresql-server port (12.8 -> 13.4_1) as described in /usr/ports/UPDATING. Everything works fine. But the command under root # su -l postgres -c "/usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /var/db/postgres/data13 -U postgres" returns...

I have this in /usr/local/etc/poudriere.d/PORTS-12-2-options/editors_libreoffice/options: # This file is auto-generated by 'make config'. # Options for libreoffice-7.1.1.2_3 _OPTIONS_READ=libreoffice-7.1.1.2_3 _FILE_COMPLETE_OPTIONS_LIST=COINMP CUPS DOCS GNOME GTK3 JAVA KF5 LTO MMEDIA PGSQL QT5...

Hi, I would like to install powerdns and its postgres backend in the same jail. I installed powerdns with pkg, and pkg info indicates postgres support was enabled on build. 12.2-RELEASE-p1 However, when every version of postgresXX-server available in the pkg repository conflicts with powerdns...

Hello All, I use iRedMail to run a personal domain. iRedMail on FreeBSD compiles all the necessary packages from Ports. LLVM is a dependency for Postgres, amongst others. The full installation of LLVM is not required in the context above. Things like cross-compile, debugger are not used...

I'm running 12.0-RELEASE-p9 and I cannot find any package for the stable version of PostgreSQL 12: % pkg search postgresql12 pgtcl-postgresql12-2.1.1_2 TCL extension for accessing a PostgreSQL server (PGTCL-NG) postgresql12-client-12.r1 PostgreSQL database (client)...

Hi, Simple setup: Internet ------ Host [A] ------ Host Host A: Is a simple firewall/gateway/router/DNS server Runs PF & HAproxy Has the private network IP address 192.168.7.1 Connects to the ISP's gateway on the other end Host B Is running databases/postgresql11-server. Has the private...

I have set up a jail specifically for PostgreSQL. PostgreSQL-9.5 is installed via the pkg manager. When I try to initialise it I get this: /usr/local/etc/rc.d/postgresql oneinitdb The files belonging to this database system will be owned by user "pgsql". This user must also own the server...

This is my first attempt at a public service post. Sometimes, one discovers that the database directories are better off in a different location than the current/default, e.g. when one decides to use a new zfs partition for the db files. The process of moving the data files needs a bit of...

Hi folks. Looking to have a daily backup of my postgresql database on a server. It's on a LAN and I want to store the backups on a workstation volume. Should I induce the pg_dump on the FreeBSD server, or the Mac workstation? I'd like to learn how to do it from the server. I have file...

The problem: I installed PowerDNS and it installed PostgreSQL 9.something client. It was successful and everything worked. (I don't actually need PostgreSQL with PowerDNS because I'm using bind zone files to configure my domains.) Then, I installed PostgreSQL 10. PostgreSQL 10 worked, but it...

Requirement: Install a FreeBSD system with zfs, and then run PostgreSQL. The system has two same hard disks, so I want a zfs mirror. In order to improve the PostgreSQL performance, what should I do this with this:

Dear friends, I am migrating from Debian GNU/Linux to FreeBSD. I could be using KfreeBSD, but I prefer blending-edge and also become part of a community, so I will not stick to Debian, although I appreciate the spirit. The server board has 32 CPUs, 32GB of RAM, 1 x SSD and 5 x SATA disc...

Hello. I have a server with only 3 SSD, I want to run only PostgreSQL on it. But I don't have idea what options of ZFS to use for best performance. Did anyone here such a setup, and can give me a hint? Best regards.

Hello, there. I'm trying to configure newsyslog to rotate PostgreSQL logs, but I ran into a problem: PostgreSQL can't be told to reopen its log files, unless by rebooting it, but I can't do that on a production server. Under Linux, it is done using the copytruncate logrotate option, which...

Hi, I been surfing the net looking for an answer for this: I want to run PostgreSQL in a jail. creating directory /usr/local/pgsql/data ... ok creating subdirectories ... ok selecting default max_connections ... 10 selecting default shared_buffers ... 400kB creating configuration files ... ok...

I'm a little all over the place with this question so please read to the end. This is a program that connects to the database but really wasn't as I just found out. I have a program in C that talks to nginx, locally, to serve web pages via FastCGI and this works well. I use spawn-fcgi for the...

I was wondering if I have the wrong commands but I read the commands at https://www.postgresql.org/docs/9.1/static/sql-createtable.html and I still make mistakes, can anyone point out how should I go on with this? I am trying to install Bacula and Postgresql using this guide...

Currently I'm running Postgresql 9.5 on Debian 8 on Linode. The OS crashed on me a few times and I need to get it on a stable system ASAP as the database is being used in production. I'm researching to make the switch to FreeBSD as it sounds like it's one of the most stable operating systems...