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
38 views

How to call ftp script from main script

I'm lookign for a way to create backups from several databases and send result files to server in Debian Linux 6 (Sqeeze) from crontab job There are databases named database1 .. database4 Backup from ...
2
votes
0answers
485 views

Postgresql 9.4 clusters not auto starting on Debian

I have Debian 8.2 x64 and Postgresql 9.4 (from repo). I've recreated default cluster in different location like this: # service postgresql stop # pg_dropcluster 9.4 main # pg_createcluster -d /srv/...
0
votes
0answers
127 views

How to recover a Standby in Postgres Slot Replication

I am using 4 nodes of Postgres 9.5 server in a Slot replication set up. One node is acting as a Master and three other nodes as Standby nodes. Everything ran fine for few days and suddenly one node ...
1
vote
1answer
124 views

Unable to restore postgresql data dump for Django app hosted on Azure VM

I am trying to restore a postgres data dump for a Django app of mine. The data dump was extracted from Heroku, and pg_restore is being run on an Azure VM with Linux on it. There are around 40 tables ...
1
vote
0answers
28 views

How to configure a PostgreSQL GIN index to support partial matches

I'm currently using a GIN index to do lightening fast full text search queries in PostgreSQL. It works great, with the only exception being it doesn't seem to handle partial-word searches. e.g. ...
1
vote
0answers
224 views

How to automate failover of master in PostgreSQL 9.5 on Windows?

I have 4 nodes (version - PostgreSQL 9.5 Beta) in a slot replication set up. Recently the master node, due to less disk space available, PostgreSQL started throwing errors and crashed in the end. As I ...
0
votes
2answers
71 views

Unable to get permissions even after changing permissions on a mounted directory in ubuntu 14.01

This is an ext4 fs and I am unable to gain permissions over the directory with the postgres user: mud@mud-i7-32gb:~$ sudo mount /dev/sdc1 /media/mud/ssd128 mud@mud-i7-32gb:~$ ls -l /media/mud/...
1
vote
0answers
13 views

Show or log long queries with values instead placeholders

I have any very long sql query in postgresql. I tried show what postgress do with: select * from pg_stat_activity unfortunately I see something like: select some_fields from anytable1 anytable2 ...
1
vote
1answer
65 views

Running postgres_database.present a second time causes error “has wrong parameters which couldn't be changed on fly”

Running a salt state that looks like the following to create a postgres database for django... django-db: postgres_database.present: - encoding: 'UTF-8' - owner: djangouser - db_user: ...
-1
votes
2answers
51 views

How to move PostgreSQL data directory?

My PostgreSQL installation by default uses /var/lib/pgsql directory to store data, backups and configuration files. As my disk space is running out, I have installed new hardware and mounted it in the ...
0
votes
0answers
23 views

Two PostgreSQL 9.5 beta 2 - short replication howto

Try configure native bi-direction (synchronous) replication between two postgresql 9.5 beta 2. Read many official documents, but still dont understand what I need configure in postgresql.conf Any ...
0
votes
1answer
111 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
793 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
243 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
124 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
127 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
24 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
603 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
157 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
38 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
37 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
126 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
113 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
47 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
33 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
61 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
30 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
102 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
254 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
81 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
262 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
34 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
79 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
37 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
191 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
125 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
67 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
221 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
428 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
63 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
50 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 ...
2
votes
2answers
275 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
509 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
258 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 ...