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)

1
vote
2answers
57 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
28 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
99 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
215 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
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
64 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
211 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
32 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
69 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
29 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
176 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
98 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
53 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
188 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
348 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
49 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
39 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
204 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
426 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
29 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
228 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
96 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
484 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
36 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
262 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
833 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
218 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
260 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
220 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
96 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
62 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
637 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
215 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
1k 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
96 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
422 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
372 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
155 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
228 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
145 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 ...
3
votes
1answer
799 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
43 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
54 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
178 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
206 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
1k 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
204 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 ...
0
votes
0answers
102 views

Using PostgreSQL at web host, editing pg_hba.conf

I have a domain at HelioHost.org, where I want to connect to a PostgreSQL server, which they supposedly support. But I get the following error message when looking at my PHP files in Firefox: ...
0
votes
0answers
185 views

How to install Nomtimatim in postgresql (windows)

I am trying to do geocoding in the postgresql, and I have already installed TIGER geocoder successfully. Then, I want to use Nomtimatim in postgresql. However,since the installed guide ...
0
votes
1answer
133 views

.pgpass file does not set default username to connect as

(Debian 8) My .pgpass file is at my home folder (admin) I and using the right format as indicated in the documentation hostname:port:database:username:password The same fields I put there work ...