postgresql

The order in how to create a postgresql schema can be not obvious. So here sql script as example, So you first create : 1. A user 2. A database 3. A schema 4. Grant rights from the user to the schema. 5. Last create a table CREATE USER john7 WITH PASSWORD 'john7'; CREATE DATABASE x7; \c x7...

Do you tune the default mariadb/mysql/postgresql configuration ? Which changes did you performed.

Hi, for some days I get "debendency incomplete" errors for a ton of packages. An example: postgresql13-client-13.21: "/usr/ports/devel/py-pytest-runner" non-existent -- dependency list incomplete postgresql13-client-13.21: "/usr/ports/devel/py-pytest4" non-existent -- dependency list...

I currently run a old school blog with PG <-> PHP <-> Apache nothing very fancy all without jails (which I think is what bytes me). I currently have : When I pkg update : I'll get complaints about I think one of the php packages is requiring that, but there is not update available for pg...

I want to install PostgreSQL in a thin jail using nullfs, and this requires me to know all the directories that the PostgreSQL package is going to be installed in and write to. Is there an easy way to determine this for PostgreSQL? For other packages?

Hi forum I'm a long time postgres user, and would really like to be able to use pgAdmin4 in FreeBSD. (pgAdmin3 has become seriously outdated, and no longer supports recent version/s of postgres.) Sadly, there's no package for pgadmin4, so I search for information and try to follow the pgAdmin4...

Managing our development projects is very easy nowadays, there are so many services to choose from, some with less or more features, but there is an open source project, self-hosted, with so many features that can be installed in a few minutes and the best part is that we can install it on...

I'm trying to provision a FreeBSD 13.1 VM over SSH by running shell commands. Among many other things I'm executing commands like these: pkg install -y postgresql15-server service postgresql initdb service postgresql start It gets to service postgresql start, prints the following and hangs...

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