postgresql

  1. Y

    FreeBSD11+Postgres+jail

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

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

    Solved Postgresql does not accept commands

    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...
  4. 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...
  5. 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...
  6. 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: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=48471 where someone...
    • japoc
    • Thread
    • ipc jail kernel pgsql postgresql private ipc shared memory sysvipc sysvipc_allow
    • Replies: 2
    • Forum: General
  7. 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...
Back
Top