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
22 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
27 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
27 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
43 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
25 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
87 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
102 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 ...
0
votes
0answers
21 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
41 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
125 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 ...
0
votes
0answers
26 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
40 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
18 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 ...
2
votes
1answer
131 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 ...
0
votes
0answers
64 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
40 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
137 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
200 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
32 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 ...
0
votes
1answer
30 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
94 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
254 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) ...
1
vote
0answers
24 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 ...
0
votes
0answers
141 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
69 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 ...
1
vote
1answer
293 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
34 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
189 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
400 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
147 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
177 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
108 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
71 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
51 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
419 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 ...
0
votes
1answer
127 views

Slony PostgreSQL replication - Can I create an index on a table on a slave that isn't on the master?

I have just set up a slony replication set up between 2 postgres servers. One master, and one slave host. Data is being copied. We don't want to use this for data backup or anything, but want to do ...
0
votes
3answers
636 views

Postgresql: restoring database from dump fails

I am using psql (9.3.9) on Ubuntu 14.04. I created dump of a database using command: pg_dump db1 > db1.backup I deleted the db and recreated it. Trying to restore it with psql -d db1 -f ...
0
votes
1answer
77 views

Google Container engine - mysql / postgresql image failure to connect from remote machine

I'm quite new to the docker images, containers and all the logic behind linking the running containers together, so please be patient if this question sounds too stupid. I'm trying to setup a working ...
0
votes
2answers
191 views

Pros and cons of database choice for OwnCloud [closed]

OwnCloud provides 3 choices for its database: SQLite MariaDB PostgreSQL Obviously SQLite is not a practical choice, since it can rarely handle the load. What about the other two? Is MariaDB or ...
0
votes
1answer
144 views

postgresql: 'invalid page header' message even after drop and recreate

My Ubuntu 14.04 LTS server running postgresql 8.4.11 crashed, and after a reboot the application server running a query against postgresql reported the following error ERROR: invalid page header in ...
0
votes
0answers
115 views

How do I run slony as a service on Ubuntu with /etc/init.d/slony1

I am investigating setting up Slony-I replication for 2 PostgreSQL databased on Ubuntu Trusty 14.04. I have gotten the basic replication working. But I have to start the slon command manually on each ...
0
votes
1answer
143 views

PostgreSQL install from source on a systemd distro

On my current server I have 2 versions of postgresql installed, postgresql-9.1 and postgresql-9.2 I installed them from source from the postgresql website. The tar.gz folder supplies the install ...
0
votes
2answers
90 views

How to take backup of a table on a different schema in PostgreSQL

Please let us know in PostgreSQL how we can take backup of a table on a different schema. We have db named "geopostgrest" and under Schema named "1" (Not inside Public Schema) we need to take backup ...
1
vote
1answer
563 views

PostgreSQL failover with Kubernetes

I've got master slave replication working with Kubernetes, but would now like to implement failover. I have pods running with the service=postgresql and role=master or role=slave roles. When the ...
0
votes
1answer
38 views

postgres continuous backup scheduling

I have set up Postgres conintuous backup by making a base backup and archiving WAL files, as specified here. Our database is very low use (but very important to back up) so we produce a new WAL file ...
1
vote
0answers
43 views

How can I efficiently create daily write replicas of an RDS instance?

We're looking to create a replica of a postgres RDS instance that our developers can write to (not just a simple read replica that AWS can easily provide). Currently we run a script nightly that ...
2
votes
2answers
175 views

Database backup encryption

I've been trying to work out an effective database backup encryption scheme lately. I have a Postgres 9.4 server, I have most of the backup scheme fleshed out I think. Backups will be stored in a ...
0
votes
1answer
137 views

PgBouncer not listening with no errors in logs

I currently have Postgres working on my server want to move to connection pooling. Looking around and PgBouncer seems to be the tool of choice. I have set it up and it claims to start fine with the ...
0
votes
1answer
772 views

terminating connection because of crash of another server process

I have a java scraper that spawns around 1,500-2,100 threads, each of which connects to the same database via jdbc and makes inserts. These threads insert quite frequently. It seems like the db ...
1
vote
1answer
130 views

Use in-memory database or search engine for read only to make website faster

I have an application which require doing a lot of queries for every single page which make it slower. I have tried to use cache systems (Redis) but implementation are little bit complicated and will ...