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

Syslog-ng and Logrotate creating sparse files

We've been using syslog-ng to log our postgres logs. On top of it we run logrotate every 5 minutes which also gzips the files. Recently, we've noted that these postgres logs contain a lot of null ...
1
vote
1answer
89 views

The more threads the less IOPS?

I've just started trying out AWS. I have a Postgres micro instance on RDS and I'm running a crawler on a c4.large. When I have just one spider (one thread), I get about 10 write IOPS. but if two ...
2
votes
1answer
115 views

Monitoring maximum number of locks in PostgreSQL with Nagios

I'm wondering if the limit for the number of locks in PostgreSQL is fixed, or if it depends on the number of open connections. The docs say the limit is max_locks_per_transaction * (max_connections + ...
0
votes
1answer
2k views

Does PostgreSQL perform on Windows as well as on Linux

This topic was brought up in 2011, and the consensus was that there were design considerations that would give PostgreSQL a leg up on Linux. It is now 2015, has that changed? If there are things that ...
0
votes
1answer
251 views

Support for Postgres broken in HHVM 3.6.0

I keep getting Uncaught exception: Could not open extension /etc/hhvm/extensions/pgsql.so: /etc/hhvm/extensions/pgsql.so: undefined symbol: _ZN4HPHP13PDOConnection5sweepEv When I try to start up ...
0
votes
1answer
438 views

Reduce the size of main/base mysterious buildup

Using PostgreSQL 9.3. I had a long-running query updating around 8M rows. Something obviously went wrong. 2 days later I got a low disk space alert. I stopped the query and this is what I saw. root@...
0
votes
1answer
37 views

Postgres replication via different interfaces

I have one PG master server that replicates itself to one slave server. Also I would like to replicate this master to slave that is in another network. Master has 2 interfaces, and there are ...
1
vote
0answers
141 views

PHPPGAdmin on Windows - authenticate users against Active Directory

I installed PHP, Apache 2.4, and PostgreSQL 9.4.1 on Windows machine which belongs to Windows domain. My pg_hba.conf: hostnossl all postgres 127.0.0.1/32 md5 hostnossl all all ...
23
votes
3answers
982 views

Risk of starting NTP on database server?

I've heard rumors of bad things happening to database and mail servers if you change the system time while they are running. However, I'm having a hard time finding any concrete information on actual ...
0
votes
1answer
127 views

VPS policy states CPU usage limitations

I have found a cheap vps solution to cover my needs. Reading through the policies of the vps service, I found that they state "CPU usage should not exceed 70%". Is there a way to prevent this? I plan ...
2
votes
2answers
1k views

Debugging a Postfix Saslauthd PAM-PGsql authentication failure

I've set up pam-pgsql to lookup passwords in my database for Postfix via Saslauthd. I can test credentials using the command line: $ sudo testsaslauthd -u user@email.com -p password 0: NO "...
3
votes
1answer
223 views

Best way to RAID 4 x Intel SSD 910 for PostgreSQL

I have a Linux (debian/ubuntu) server with 4 x Intel SSD 910 800GB pcie that I need to RAID together. The biggest problem with these card is that they give you 4x200GB drives that you cant hardware-...
2
votes
2answers
3k views

Zabbix cannot connect to a PostgreSQL database

First off I am running CentOS 6.5 and attempting to use Zabbix 2.2.4. Any hostnames have been replaced with examples. I have installed the following RPMs onto my Zabbix machine ( hostname will be zbx-...
1
vote
1answer
180 views

How do I know if Postfix has MySQL/PostgreSQL support?

I'm not sure if my Postfix installation has MySQL or PostgreSQL support. How do I find out?
1
vote
1answer
218 views

Install i686 postgres libraries on 64 bits CentOS7

I am trying to get a i686 compiled binary to run on my x86_64 CentOS7 install. When starting it complains it cannot find (dynammically load) the libpq library. I tried installing the i686 Postgres ...
3
votes
1answer
558 views

How to specify a client certificate to psql?

I have a Postgres server with a user dev which requires a client certificate to log in. I'm using the command psql "sslmode=require user=dev host=db.prod", which gives me psql: FATAL: connection ...
0
votes
1answer
39 views

Where should the DB server be and its updates scripts should run from where?

I currently have a web application and database on the same server. I am moving the database to a new server that is spec'd for being a database. Now i have nightly scripts that run on the web ...
1
vote
1answer
174 views

How can I select one of multiple PostgreSQL in my CentOS server? [closed]

I had postgresql 8.4 in centos system. Aadditionally I needed postgresql 9.3. I want new version, But excute 8.4 version instead 9.3 version. How can I change default version?
2
votes
1answer
4k views

Why can't I create a superuser in AWS Postgresql instance?

I have an AWS EC2 instance connecting to an RDS instance (Postgresql). When I created the RDS instance, I told it the DB root's username was: my_user1 and the password was password1. Now I'm ...
0
votes
0answers
266 views

Installing PostgreSQL on Centos 5

I'm following the instructions from here. I try and run yum localinstall http://yum.postgresql.org/9.4/redhat/rhel-5-i386/pgdg-centos94-9.4-1.noarch.rpm which returns the fault cannot open file... ...
0
votes
1answer
3k views

What could cause “idle in transaction” in a pentaho pdi process?

I am running an ETL process using cron on a daily basis on my server every 2 hourly. The ETL process populates a reporting database which runs Greenplum. I have noticed that the ETL process normally ...
2
votes
1answer
3k views

Postgres on OS X can't find postgis extension control file

Using mac OSX Yosemite 10.10.1. I uninstalled and re-installed both postgres and postgis with homebrew. I understand that postgres is looking in the wrong place for the postgis control file. Also ...
1
vote
1answer
3k views

Importing Data Dump Using pgAdmin

I looked around and found the following code on how to import a data dump using pgadmin: CREATE OR REPLACE FUNCTION db_to_csv(path TEXT) RETURNS void AS $$ tables RECORD; gmdeclare statement TEXT;...
1
vote
0answers
95 views

How to change username on RDS instance

I have a single RDS postgresql instance with username 'psql' owning the database. How do you change the username?
0
votes
1answer
2k views

postgresql LDAP authentication

I am trying to give an LDAP authentication to my postgresql database. Here is my pg_hba.conf config file local all all md5 local all postgres md5 host all all 0.0.0.0/0 ldap ldapserver=...
0
votes
0answers
351 views

Is it possible to do an Online Index Rebuild in Postgresql

Is it possible to do an Online Index Rebuild in Postgresql or is your only option to do a drop and recreate? Thank you.
0
votes
1answer
51 views

Secure Database Password Contained Inside a File

I've got a Linux based application (Java) that connects to an external database (PostgreSQL) in the same LAN. However, due the sensitiveness of the database contents I would like to avoid the admins ...
2
votes
1answer
482 views

Postgres Restore Not Restoring Binary Data

This is a very urgent situation. We have a postgres 9.4 database installed on a CentOs machine. We are trying to take a backup from a Heroku Postgres database and restore it to the database on ...
1
vote
1answer
2k views

How to apply PostgreSQL “GRANT ALL ON ALL TABLES” to new tables?

As discussed in the question at GRANT SELECT to all tables in postgresql, as of PG 9.0 you can mass-grant privileges on all existing tables to user u, using a command like: GRANT ALL ON ALL TABLES IN ...
5
votes
1answer
2k views

unable to connect to public postgresql rds instance

I created a basic test PostgreSQL RDS instance in a VPC that has a single public subnet and that should be available to connect over the public internet. It uses the default security group, which is ...
1
vote
1answer
386 views

PostgreSQL 9.2 causes CPU utilization to go to 100%

We have a Java EE application (a online digital library portal) with Hibernate 4.3 which connects to a PostGres 9.2 database. Upon load testing with a load of 175 concurrent users logging in and ...
2
votes
1answer
753 views

PostgreSQL failed to start. unable to load private key file << server.key >> : key values mismatch

I am trying to install PostgreSQL on my Linux Debian 7.2 server but it fails. this is what I did : user ~ $ sudo apt-get install postgresql Lecture des listes de paquets... Fait Construction de l'...
2
votes
1answer
5k views

How do I link a security group to my AWS RDS instance

I have a postgres db setup on RDS. It is running great. However, I want to link this to a set of autoscaled EC2 instances sitting behind an ELB that all reside in a single EC2 security group. I've ...
2
votes
2answers
380 views

AWS RDS Postgres Upgrade without losing data

I currently have a Postgresql v9.3.3 running on AWS RDS. I've learned that if I upgrade Postgres to 9.3.5 that I can create read replicas. However, I am afraid of losing data. Can I just select "...
1
vote
1answer
808 views

What this error means in PostgreSQL?

ExecStart=/usr/pgsql-9.4/bin/pg_ctl start -D ${PGDATA} -s -w -t 300 (code=exited, status=1/FAILURE) This error appears after changes in /var/lib/pgsql/9.4/data/postgresql.conf or pg_hba.conf And ...
-1
votes
1answer
186 views

I cannot change privileges for folder with chmod on CentOS

On CentOS 7 server for the folder /var/lib/pgsql/9.3/data/ I do: sudo chmod -Rf 755 /var/lib/pgsql/9.3/data/ But it doesn't change privileges for folder. But sometimes it changes for 10-15 minutes. ...
1
vote
0answers
323 views

Unable to perform replication in Bucardo in a Master-Slave setting

When I was trying to perform replication from Master to Server, the replication was able to run on the Master server, but the table in the slave database did not receive and apply the changes. ...
0
votes
2answers
77 views

Data Directory PostgreSQL 9.1 to Windows 2008 Server R2

"My predecessor" has installed PostgreSQL 9.1, now I would like to know what is the "Data Directory" installation. Now I am using this interface: Can I know using this interface the Data Directory?...
0
votes
1answer
227 views

Allow passwordless 'peer' auth where matches, but require password for other users

I have what I think is a simple Postgres authentication requirement, but I can't figure out the pg_hba.conf incantation to make it work. I have a database user (role) named dbuser which is the owner ...
0
votes
1answer
150 views

Wal-E cron job not executing

I have a cron job setup that is suppose to be running the wal-e backup-push command. The command works fine if manually ran through the command line. As the postgres user of course. So I setup a cron ...
1
vote
0answers
691 views

Upgraded Postgresql from 9.1 to 9.4 on Ubuntu and now extensions are looking in the wrong folder

When I run CREATE EXTENSION "uuid-ossp"; I get ERROR: could not open extension control file "/usr/share/postgresql/9.1/extension/uuid-ossp.control": No such file or directory The extensions ...
0
votes
1answer
892 views

Monitoring PostgreSQL replication with Nagios and check_postgres shows intermittent delay

I have a master and hot standby setup with PostgreSQL 9.3, and I'm attempting to monitor the state of replication on the standby using the check_postgres tool and the "hot_standby_delay" action. This ...
1
vote
0answers
366 views

autopostgresqlbackup postgres authentication error

I am trying to use autopostgresqlbackup on ubuntu on an ec2 instance. I can log in with psql on the command line and it is picking up my .pgpass file and everything looks fine. When I run 'sudo ...
0
votes
1answer
704 views

Ubuntu 2 Node Cluster Postgresql 9.3 with pacemaker and Streaming Replication

I'm trying to setup a 2 Node Cluster with Postresql 9.3 and Streaming Replication. Streaming Replication is successfully configured. Master is listen up and is sending to slave. I can do failover ...
1
vote
1answer
270 views

Website performance sluggish - High CPU and Disk Usage

Over the past couple of days my website's performance has been very sluggish, with queries taking a lot of time to execute. My CPU usage hit around 100% 4 times this week. Here is the output of top at ...
2
votes
0answers
634 views

postgres dropping connections from Windows clients

Postgres appears to be losing connections from clients. The clients get an error, normally that the connection was closed by the server, while at the same time the server gets a log entry. Example: ...
0
votes
1answer
400 views

PostgreSQL queries slower than before?

I am using PostgreSQL 9.3 server on my production server. Everything had been working fine for the past couple of months. But since the past week or so, PostgreSQL seems to have becomes very slow with ...
0
votes
0answers
413 views

Memory usage of Postgresql and play framework

I am running a play framework application and a Postgresql server on a VPS which has 2vCores and 2GB of RAM and I'm having memory issues. I limited my play application to 1024MB with the parameter : ...
4
votes
1answer
2k views

What is the size of an IO Operation (IOP) in AWS EBS?

My research suggests that both the standard and the maximum (kernel limitations) block size for modern file systems (ext4, xfs) is 4KB. However, AWS allows IO operations as large as 256KB and says ...
1
vote
1answer
728 views

backup postgresql via docker exec

How would you go about taking automatic rotated backups of a postgresql database running inside a docker 1.3 container? I'm mostly interested in the overall approach vs. the details of actual the ...