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
votes
0answers
46 views

Postgres 9.0 recovery from inadvertent drop-all-tables event [migrated]

Due to a accidental config file check-in, a unit test wiped out our entire production database (did a drop, then re-created the tables). Trying to restore from backup revealed the recent backups were ...
1
vote
1answer
30 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
15 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
19 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 ...
0
votes
1answer
20 views

ERROR: could not open extension control file “file_path”: No such file or directory

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 ...
0
votes
0answers
18 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 ...
0
votes
0answers
17 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
0answers
12 views

Daily 100k+ rows insert or update in postgres, most efficient way? [migrated]

I daily get a file with the current state of a customer base. This has to be imported: Look up if the customer ID is already in the database If it is, update the active-field of the matching ...
0
votes
1answer
46 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 ...
0
votes
0answers
17 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
40 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 ...
1
vote
1answer
45 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
36 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 ...
0
votes
1answer
46 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
votes
0answers
10 views

PHP can't connect to PostgreSQL on CentOS 7 [migrated]

I have CentOS 7 running in VirtualBox on OSX. Apache, PHP 5.4 and PostgreSQL 9.2 are all running. But, when my (simple) php-script tries to connect to PostgreSQL it doesn't work: Warning: ...
1
vote
1answer
47 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 ...
0
votes
0answers
46 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 ...
0
votes
1answer
49 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 ...
0
votes
1answer
42 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 ...
0
votes
1answer
46 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
39 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. ...
0
votes
0answers
28 views

Postgres on OpenSuse doesn't start after update

I tried to upgrade OpenSuse from 12.1 to 13.1 and after 'zypper update' and reboot Postgresql doesn't start. Here is the output of service postgresgl status: postgresql.service - LSB: Start the ...
1
vote
0answers
82 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
41 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
39 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
0answers
14 views

PostgreSQL hardware Requirements [duplicate]

We are thinking of shifting our data warehouse solution from Netezza to PostgreSQL. Can you please let us know the minimum[overall performance should be good] hardware requirements for the below ...
0
votes
1answer
30 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 ...
0
votes
0answers
130 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
40 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 ...
0
votes
0answers
41 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
80 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 ...
0
votes
0answers
27 views

SSL error: ccs received early

I'm getting this error on my slave postgresql server. 2014-11-21 10:30:05 CET FATAL: could not receive data from WAL stream: SSL error: ccs received early 2014-11-21 10:30:05 CET LOG: invalid ...
1
vote
1answer
105 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 ...
1
vote
0answers
51 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
50 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
60 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
248 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
93 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
0answers
31 views

Why is Glassfish v3 thrashing JDBC Postgres connections?

I have an application running on Glassfish3 and Postgres. Looking at netstat and lsof there are an excesssive (thousands) of connections to postgres from localhost in TIME_WAIT. My team and I know ...
0
votes
1answer
39 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. ...
2
votes
1answer
822 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 ...
0
votes
0answers
141 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. ...
0
votes
0answers
39 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 ...
-2
votes
2answers
76 views

Do we need enterprise support for RHEL/CentOS and PostgreSQL [closed]

We are an SI currently working on a proposal for an web app solution with tight budget. The 3rd party web app is written in JDK7 is to be deployed to 2 physical server running 3 VM each, one for ...
2
votes
0answers
158 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: ...
0
votes
1answer
69 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 ...
0
votes
0answers
106 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
0answers
68 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
19 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 ...
2
votes
1answer
294 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 ...