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
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 ...
4
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
360 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
694 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 ...
2
votes
1answer
4k 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
359 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
731 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
168 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
297 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
73 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 ...
0
votes
1answer
203 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
141 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
678 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
808 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
327 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
634 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
258 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
585 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
386 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
373 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
1k 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
682 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 ...
0
votes
1answer
708 views

Postgres Remote Connection Timeout

I've been reading tutorials extensively to help figure out my problem, but to no avail. I have a Redhat VM that I've installed Postgres on that I'm trying to make available for remote connections. ...
5
votes
1answer
5k views

Cannot connect to PostgreSQL unix domain socket

I'm trying to connect to PostgreSQL Unix domain socket from a PHP web application. Relevant system components: CentOS 7 x64 (SELinux enforced) postgresql93 9.3.5-2PGDG.rhel7 nginx 1.6.2-1.el7.ngx ...
1
vote
0answers
3k views

How to upgrade from Postgres 9.1 to 9.3 allowing read access during upgrade

"PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit" is working in Debian 6.0 Squeeze It contains 12 databases accessed by 100 users from internet. ...
1
vote
1answer
255 views

PostgreSQL 9.3 and peer authentication

This seems stupid simple but it's not working. My pg_hba.conf: # type database user address type local all postgres peer # postgres user ...
3
votes
1answer
2k views

Postgresql Provided user name and authenticated user name do not match

I am trying to get tinyRSS running on my own server using PostgreSql. However I keep getting this error: LOG: provided user name (tinyrss) and authenticated user name (apache) do not match FATAL: ...
1
vote
1answer
873 views

CentOS 6.5 on Vmware can't ping Host machine

I have installed a CentOS 6.5 on VMware WorkStation 10 all running on Windows 7 64bit, internet is working fine but I can't ping host machine from CentOS vice vers, it tells me Destination Host ...
0
votes
1answer
824 views

How to install Postgres 9.3 parallel in Debian Squeeze

Debian 6 contains Postgres 9.1 installation installed from Debian backports in 5432 port How to install Postgres 9.3 also on this server. I found instructions in ...
1
vote
1answer
1k views

“bin/unpack200: not found” when installing TeamPostgreSQL

Running Ubuntu 14.04 64bit. I downloaded the 68MB .sh file from the project website. When I run the file with sudo I get the following output: ben@tardis:~$ sudo ./teampostgresql_ubuntu.sh Unpacking ...
0
votes
1answer
623 views

pgpool2 parallel mode: Non-superusers must provide a password in the connection string

I have two AWS RDS postgres nodes backing a parallel mode pgpool setup on EC2. After using pgbench to populate test tables, I get odd behavior from test queries. Any query that uses a function ...
0
votes
1answer
176 views

autocomplete is not working in postgreesql 8.4

I have installed postgresql 8.4.21 in my CentOS 5. But when I fire Select Query is it not showing me any completion if I press TAB key.. database=# select count is it any configuration in ...
3
votes
1answer
1k views

Postgresql 9.3 Log Shipping on a Hot Standby

My setup I've just set up streaming replication in postgres for the first time (9.3.5), and while the streaming is working as I expect, I'm struggling to get my standby to run the archive_command so ...
5
votes
1answer
1k views

Django: CONN_MAX_AGE persists connections, but doesn't reuse them with PostgreSQL

I've got a django setup are using Django 1.6.7 and Postgres 9.3 on Ubuntu 14.04 LTS. At any given time, the site gets about ~250 simultaneous connections to the PostgreSQL database, which is a Quad ...
0
votes
1answer
544 views

Connect with Java to Amazon EC2 instances

I have written a client-server application in Java and I want to run it on Amazon EC2 Ubuntu instacnes. The client runs on an EC2 instance and the server on one and the third EC2 instance is for ...
0
votes
2answers
748 views

postgreSQL archive process failed on

I upgraded a cluster from 8.3 to 8.4. Things seemed to be fine so I dropped the 8.3 cluster. Then noticed an error and found that the archive_command was still pointing to the 8.3 data directory ...
0
votes
1answer
715 views

pgpool run and only log one line

I am using pgpool and when I run: sudo pgpool -f pgpool.conf -F pcp.conf -n It just log one line and keep waitting.... : 2014-10-09 13:27:42 LOG: pid 28626: wd_chk_setuid: ifup[/sbin/ifconfig] ...
2
votes
1answer
560 views

Most reliable MariaDB to Postgres dump method

I am in the process of migrating an app to another server, and will need to migrate the database contents from MariaDB to Postgresql. Most documentation indicates that the following format should ...
0
votes
1answer
130 views

Password Manager Pro backend database MS SQL vs PostgreSQL [closed]

I'm looking to manage users passwords through the programme Password Manager Pro. Reading the documentation it explains that you can use ether your own MS SQL database or use their default PostgreSQL ...
0
votes
2answers
163 views

How do I update YUM repositories to get Postgres9.x version?

I need to install some Postgres9.1 libs, but "yum list" only shows 8.4 version. How to "update" yum repo list to get 9.1 version? My Linux version: # cat /etc/redhat-release Red Hat Enterprise ...
1
vote
1answer
326 views

how to query postgresql database via salt

I need to run a query on a postgresql database in a module I'm writing for Salt. It won't do much, just query a table for a value to determine what version of the software is installed. The docs have ...
0
votes
1answer
378 views

OpenShift allow permanent external access to PostgreSQL [closed]

I have an OpenShift gear with Nginx and PostgreSQL, and need to allow a Java applet (served from Nginx) direct access to the PG database. I've already tried to edit ...
1
vote
0answers
607 views

Changing kernel.shmmax and kernel.shmmal on ubuntu?

We have an Ubuntu server with 6GB of RAM. We are trying to install Postgres but it is advising us to increase the values for kernel.shmmax and kernel.shmmal. The server is solely a Postgres DB ...
0
votes
1answer
132 views

Daily postgresql cron error log file

I am getting these emails daily: /etc/cron.daily/logrotate: error: error accessing /var/log/postgresql: No such file or directory error: postgresql-common:1 glob failed for /var/log/postgresql/.log ...
0
votes
1answer
91 views

pg_createcluster ssl cert behaviour different for 9.1 and 9.3 on Debian Squeeze

I think i found a bug in pg_createcluster when creating a 9.3 cluster. At first, my configuration: Debian Squeeze with PostgreSQL 9.1 from squeeze-backports and PostgreSQL 9.3 from apt.postgresql.org ...
1
vote
0answers
32 views

psql: How to include comments in \d output

In PostgreSQL it is possible to add comments to table columns. These will appear in the psql output from the "extended describe" \d+ command, however they will not appear in the standard \d output. ...
2
votes
2answers
288 views

How to minimize bandwidth in frequent postgres backup scenario?

I'm looking to make very frequent backup (every hour) of postgres data on several VMs (say 20-50) towards the same archive server. Here are more data if needed: Ideally, the system should support ...
0
votes
1answer
257 views

How to correctly run PostgreSQL on Fedora

I decided to to run PostgreSQL on my Fedora 20, so I did sudo yum install postgresql-server.x86_64 postgresql-libs.x86_64 postgresql.x86_64 Now if I do postgres -D /var/lib/pgsql/data under ...
1
vote
1answer
103 views

Databbase file structure on disk [closed]

I'm an interested in the fundamentals of databases for a project that I am currently working on. Specifically the physical storage on disk and how rows and indexes are stored in a file. For the most ...
1
vote
1answer
103 views

CentOS / PostgreSQL. How to keep connections open?

I would like to keep connections open on PostgreSQL for N time. I am not having problems keeping PostgreSQL itself open. The issue is that when the connection is idle for a few minutes, the ...