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)...
Internet ------ Host [A] ------ Host
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
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:
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...
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...
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:
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?
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...
I am learning how to install and use PostgreSQL server and I have run across a few different tutorials. One of them had me running postgresql commands from /usr/local/etc/rc.d. However, I initially didn't see the directory and the command wasn't working so I ended up finding pg_ctl and doing the...
I have to run many instances of PostgreSQL in different jails. And it seems it's not currently possible to run PostgreSQL in a jail without setting sysvipc_allow="YES" in the jail config.
(Or is it? I stumbled onto this: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=48471 where someone...
I'm trying to get Nginx with PHP-5.6 and PostgreSQL-9.4 working. I can install PostgreSQL-9.4 without any problems. But as soon as I install databases/php56-pgsql, pkg will downgrade databases/postgresql94-client to databases/postgresql94-client. And that causes some problems. For example...