PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (...

learn more… | top users | synonyms (1)

0
votes
1answer
104 views

'Invalid input syntax for type inet' db error in Django app with postgres when Gunicorn+Nginx(reverse proxy) installed

I have a Django app with postgres back-end where I'm configuring gunicorn to work behind nginx as reverse proxy. My machine runs Ubuntu 14.04. Everything seems to have worked, except I've run into a ...
2
votes
1answer
731 views

Cannot upgrade postgresql 9.4 -> 9.5beta2 after postgis 2.1.6 -> 2.2.0 upgrade

Here is my situation: I started with Postgresql 9.4.5 and Postgis 2.1.6. Everything running smoothly. Both are installed from source. I upgraded Postgis to 2.2.0 (download source, configure, make, ...
0
votes
1answer
220 views

Postgres 9.5 server not starting due to already active replication slot

I have a Postgres (version - 9.5 Beta) server replication set up where there are 3 slaves and a primary server. After all required configuration is done, I start 1st slave after taking base backup and ...
0
votes
1answer
113 views

psql: duplicate GSS authentication request

What does it mean by saying 'duplicate' ? How to troubleshoot this? guest@www:~$ klist Ticket cache: FILE:/tmp/krb5cc_1000 Default principal: user/admin@SOHONET Valid starting Expires ...
0
votes
1answer
18 views

How to start postgresql server with the socket at a different place?

Good morning. The title says it, but let me precise it. I am working with openbsd. The web server is chrooted in /var/www. So the good thing would be that postgresgl place its socket (and the lock, I ...
0
votes
0answers
8 views

How do I resynchronize a Bacula catalog?

I tried performing a Bacula upgrade, but found there were issues with our architecture. Our team tried powering through the upgrade testing backups, but eventually decided to do a downgrade and ...
0
votes
2answers
122 views

Docker Architecture for Multiple Apps with Postgres DB

I have over 30 apps written in various Ruby frameworks. All of them are internal apps so they receive very little traffic. I want to run each of them in a separate Docker container. All of them use ...
1
vote
1answer
22 views

Difference in time stamps via puppetdb query and mysql query

I store reports from nodes in puppetdb. I want to check time when reports received from specific node via the following query: curl -sk http://pdb:8080/v3/reports --data-urlencode 'query=["=", "...
1
vote
1answer
539 views

Can not start PostgreSQL replication resource with Corosync/Pacemaker

I'm setting up a PostgreSQL replication on two servers (CentOS 6.5) with HA by Corosync/Pacemaker. My software info: postgresql91-9.1.19-1PGDG.rhel6.x86_64 postgresql91-server-9.1.19-1PGDG.rhel6....
0
votes
1answer
140 views

Slot replication not working in Postgres 9.4

I am using Postgres 9.4 on Windows 2008 server. There are three such instances that I am using. One as master and the rest of the two are slave/standby. The version of Postgres is 9.4 in all the three ...
2
votes
1answer
37 views

Is there a way to write application logs like Tomcat and PostgreSQL to Tenable Log Correlation Engine?

My IT group uses Tenable's Log Correlation Engine and we have our Linux servers writing syslog to LCE. Is there a way to write our Tomcat and PostgreSQL application logs to LCE?
0
votes
1answer
35 views

How to debug remote connection failure to a postgresql database? [closed]

I'm a new user and I hope to get it right. However I've a problem with a remote access to postgresql. I've changed postgresql.conf (listen_addresses = '*') and I've changed pg_hba.conf (I've added ...
0
votes
1answer
114 views

psql: could not connect to server: Network is unreachable

I know it is a duplicate questions but their solution not working, What I'm doing is, connecting to a remote Postgresql database from my local ubunut machine: psql -h x.x.x.x -U username But it ...
0
votes
1answer
107 views

Millions of requests and MariaDB vs. PostgreSQL

I do not ask for comparison. I already know what PostgreSQL and MariaDB is and differences. I am looking this issue from another point. Such companies like Facebook uses MySQL (of course patched) but ...
0
votes
1answer
44 views

Is it possible to connect to a PostgreSQL server using FreeTDS driver and tsql?

Can I make a connection to a PostgreSQL server using FreeTDS, more specifically tsql command? I've been trying for a few days now, using many different configurations. Even though I am able to ...
0
votes
1answer
28 views

Output additional information if nagios/icinga check fails

We use check_postgres to monitor our PostgreSQL servers. Sometimes there are peaks in the number of locks and the check alerts. Up to now the check only tells us the number of locks. This does not ...
1
vote
1answer
40 views

Postgresql calculate kernel share memory?

We are running PGSQL 9.2 and following are hardware specs OS: CentOS7 64bit CPU: 24 Memory: 32GB Disk: SSD I want to calculate shmmax/shmall values then what would be the good way? I google it and ...
1
vote
0answers
31 views

Postgres and Media Linode servers regularly need restarting

I have a site running on several Linode virtual machines, including separate VMs running: Django (and apache) Django (for running memory-intensive scripts) Postgres Media server, with a private ...
1
vote
2answers
60 views

backup postgres database password issue

I've got a postgres database that I want to backup regularly. For that, I'd like to use the automated backup script here Usually I to proceed admin tasks I use these command: > sudo -i -u ...
0
votes
0answers
29 views

Could pgpool be locking tables

I had an issue today where I could not insert into a single table(I think the table was locked). This was resolved once I revered my application back to hitting the master server for all of my ...
1
vote
1answer
101 views

How can I serialize postgresql.conf multiple times during a Chef run when using cookbook postgresql?

I am creating a Chef recipe that does a couple of things, amongst others a big import of data into a Postgresql database. I am using the Supermarket 'postgresql' cookbook which allows me to create a ...
-1
votes
1answer
234 views

apache2 dbd failed to initialise error AH02654 using postgresql on debian jessie

I'm currently trying to set up an apache server with mirrorbrain on debian jessie, mirrorbrain uses dbd to connect to the database. Unofrtunately I get the following in the error log [Sun Oct 18 13:...
0
votes
0answers
26 views

pgPool2 only allowing one app to connect per database

I am running a master slave postgres server with pgpool2 for load balancing and multiple applications that connect to the same database. Pgpooling only seems to be allowing the first application for ...
1
vote
0answers
76 views

Solve PostgreSQL table bloat without affecting reads/writes?

I have a large postgresql table that I think has started to become bloated, and I'd like to fix that. Normally I could do a VACUUM FULL or CLUSTER, but I'm wondering if I can fix the bloat without ...
0
votes
2answers
238 views

symbol xmlOutputBufferGetSize, version LIBXML2_2.9.0 not defined in file libxml2.so.2 with link time reference

I've installed Apache2 and PHP5 via apt-get on Ubuntu 14 (amd64), Tomcat 6, and Postgres 8.4. I get this error message on an attempted restart: apache2: Syntax error on line 140 of /etc/apache2/...
0
votes
0answers
33 views

Can't connect to pgpool2 with psql

I am trying to test my pgpool connection remotely using psql but I keep getting this error: psql: could not connect to server: Operation timed out Is the server running on host "x.x.x.x" and ...
0
votes
0answers
75 views

pgpool-II aways show slave server as down but it is running

I have postgresql 9.3 running with a master/slave replication system setup and am trying to implement pgpool-II 3.2 as a load balancer. Pgpool is setup on the smae server as the master database. The ...
0
votes
0answers
34 views

cstore_fdw extension: FATAL: could not access file “‘cstore_fdw’”: No such file or directory

On MacOSX I've installed cstore_fdw extension to PostgreSQL 9.3.5, and it looks there was no error in the process ("/usr/local/pgsql/bin/" is incorrect path, but files were copied where they should be,...
2
votes
1answer
187 views

Slow Fsync w/ Google Cloud's Local SSD (Postgresql)

I'm getting unexpectedly low transactions per second on GCE's "Local SSD" option (comparing to SSD Persistent Disk) using simple "pgbench" tests: # With Local SSD # /dev/mapper/vg0-data on /data ...
1
vote
0answers
117 views

PostgreSQL Installation on Vagrant box with symbol linked config file

I have installed PostgreSQL 9.4 on Ubuntu Trusty 64 Vagrant box. The PostgreSQL config file are sitting on my Windows hosts and linked into Vagrant box by Vagrantfile. The PostgreSQL config files ...
2
votes
2answers
62 views

pg_dump compression; Server or Client side

When you are specifying compression on pg_dump, is the compression happening on the server side so that the transfer is quicker or is the pg_dump doing the compression? Thank you
1
vote
0answers
204 views

Ubuntu server 14.04 postgres Tainted

I run an Ubuntu 14.04 server, on which Postgresql 9.3 is installed. I am seeing kernel messages flooding kern.log and syslog, hundreds of lines a minute, until the server is out of free space. I'm at ...
0
votes
1answer
401 views

Zabbix + pg_monz shows service not running

I am trying to setup monitoring for my PostgreSQL installation with zabbix ang pg_monz. I've followed this standard installation guide(http://pg-monz.github.io/pg_monz/index-en.html#install). ...
0
votes
1answer
57 views

slapd configuration for back-sql: how to traslate examples from slapd.conf to slapd.d

I'm trying to configure slapd with back-sql (specifically postgresql backend). All documents I found (Postgresq LDAP Howto seems to be more complete) are related to old configuration that use slapd....
0
votes
1answer
45 views

What is postgres-9.4-postgis-2.1

What is postgres-9.4-postgis-2.1 ? what is the difference of postgres-9.4-postgis-2.1 and postgis sudo apt-get install postgres-9.4-postgis-2.1 and sudo apt-get install postgis which one enable ...
1
vote
2answers
236 views

Sharing SSH port tunnel with local network

I've successfully created a SSH tunnel to our cloud postgresql server on a local linux server, with this command: ssh -N -f -L 5431:localhost:xxxx mycloudserver.com (where xxxx is remote port) ...
4
votes
1answer
464 views

connecting to PostgreSQL fails with semctl … invalid argument

I ran initdb, tried to create a new superuser with createuser -sdrP myuser The error I'm getting is createuser: could not connect to database postgres: FATAL: semctl(3342342, 3, SETVAL, 0) failed:...
1
vote
0answers
30 views

Asynchronous database replication solution PostgreSQL [closed]

We have an application Client (Android) -> API (PHP) -> Database (PostgreSQL) that controls flow of people on big events (clubs, wedding parties, academic meetings etc...), that runs over the internet....
0
votes
0answers
243 views

ProFTPD SFTP with virtual users in Postgres sql database

First of all, I know that my question is similar to one posted previously but I couldn't solve my problem just with that (ProFTPd mod_sftp mod_sftp_sql). I am running debian 7.8 and I have a running ...
0
votes
0answers
105 views

Can't access PG Bouncer from my web server container

I'm running two docker containers. One for a flask app, and one running pgbouncer. It's important to note that I can connect to the pgbouncer setup using psql from the pgbouncer container. The ...
2
votes
1answer
538 views

How to run PostgreSQL on CentOS within Docker?

I ran centos:7.1.1503 and then yum install postgresql. Unfortunately, due to systemd problems I cannot run service postgresql start even after installing initscripts: Redirecting to /bin/systemctl ...
0
votes
1answer
38 views

PostgreSQL : Strange Sudden Data type AND select schema issue

Here is my problem : Actually I am using postgresql 9.4 and postGIS extension. I am creating a database, and adding new tables with no problems... with geometry data types... until now... Now, I ...
0
votes
1answer
289 views

Postgres /root": Permission denied

why on ubuntu 14.10 every time that i try to start the postgres on: sudo -p 'sudo password: ' -u postgres /usr/lib/postgresql/9.4/bin/initdb -D /mnt/postgresql/9.4/data show this: could not ...
0
votes
1answer
964 views

repmgr - after a failover switch, both nodes act as a master

I have a two node PostgreSQL cluster configured through repmgr. The database topology looks like this: db1 - 10.10.10.50 ( master ) db2 - 10.10.10.60 ( standby ) wit - 10.10.10.70 ( witness ) The ...
1
vote
1answer
236 views

Installing postgres 9.4 on ubuntu with a non-default database directory

I am trying to install and set up postgres 9.4 on ubuntu 14.04. What is the best way to install postgres whilst ensuring all created tables and databases (and anything else that could potentially ...
0
votes
0answers
289 views

Collectd not sending Postgres stats

I am trying to add postgres stats collection to collectd. I have collectd running on the server running postgres and it is successfully sending the metrics for; cpu, disk, memory, network etc to ...
1
vote
1answer
248 views

Install PostgreSQL pgAdmin Tools on Amazon RDS

Is there a way to install the optional adminpack (contrib) tools for utilizing pgAdmin on an Amazon RDS PostgreSQL instance? My gut says no because of this question. When you don't have the tools ...
0
votes
0answers
98 views

move all postgresql pgdata or only pg_xlog to raid0 and configuration of effective_io_concurrency in Azure

I setup 4 disks RAID0 in Azure VM (D11, 2 cores, 14GB ram) and moved pg_xlog to the RAID array and the rest of the pgsql/data on the OS disk which is a single disk. I wonder can I configure ...
0
votes
1answer
65 views

Load average spike causes very slow response on web application

we've a vm in Azure with D11(2 cores, 14GB ram) size to host our company new web erp system that consist of jboss and postgresql installed on centos 7, only 14 users login concurrently. From time to ...
0
votes
1answer
748 views

could not write temporary statistics file “pg_stat_tmp/pgstat.tmp”: No space left on device

The posgtres sudden stopped on the server and the logs shows the following error: 2015-08-18 02:29:22 IST ERROR: could not extend file "base/197893/198337": No space left on device 2015-08-18 02:29:...