1. J

    Migrating Postgresql data directory

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

    pg_dump on LAN server or workstation?

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

    Is it possible to selectively install packages using pkg?

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

    ZFS FreeBSD + ZFS + PostgreSQL, need suggestions.

    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:
  5. French Fries

    ZFS PostgreSQL and zfs/ufs performace

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

    ZFS FreeBSD with 3SSD for PostgreSQL

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

    Newsyslog equivalent for logrotate's copytruncate

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


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

    Solved PQconnectdb() causes program to crash

    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...
  10. Vincent See

    Solved Postgresql does not accept commands

    I was wondering if I have the wrong commands but I read the commands at 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...
  11. arya6000

    Increasing max_connections on Postgresql 9.5

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

    Solved Postgresql (95) - pg_ctl vs postgresql

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

    Running a jail with sysvipc_allow="YES"

    Hi, 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: where someone...
  14. mariourk

    PHP-5.6 and PostgreSQL-9.4

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