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)

4
votes
0answers
512 views

Docker: Permission denied on folders added with ADD

I'm trying to configure a postgresql installation using docker. FROM ubuntu:13.10 ADD . /db # install postgres # ... RUN chown postgres:postgres /db -R && \ chmod 700 /db -R USER ...
3
votes
0answers
266 views

Using ZFS head node as database server?

I'm using a dual-head ZFS-backed NAS for high availability cluster shared storage, based on Nexenta's recommended architecture as seen here: The disks in 1 JBOD will store the database files for a ...
3
votes
0answers
471 views

UDP Overflow / UDP Drops on Standby Postgres Service

I am stumped trying to prevent an overflowing UDP buffer on a standby Postgres service. Any help would be most appreciated. Essentially a UDP buffer associated with the pg_standby process on my ...
3
votes
0answers
532 views

Postgres roles best practice implementation

Folks, I could use your help making my Postgres user access control design better and more aligned with best practices. I'm helping roll out a small production Postgres server but I am not a DB ...
2
votes
0answers
448 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: ...
2
votes
0answers
117 views

Bugzilla extremely slow on EC2, RDS PostgreSQL

The Problem I have installed Bugzilla on an EC2 instance, using PostgreSQL RDS as my database. After entering a few dozen bugs, Bugzilla became unbelievable slow, and I get a lot of timeouts. ...
2
votes
0answers
182 views

Database hangs when using owncloud on nginx php5-fpm postgresql - i think postgres if responsible

I have strange problem with this setup. Strangely it occurs only when using owncloud from one specific computer. Problem is when user click on "Activities" an "document" icons one after another ...
2
votes
0answers
152 views

nodejs postgresql database connection string

Is there a way where I can specify(include) both the master and slave server in nodejs db (postgresql) connecetion string in a replicated envirnment? My aim is 'if master is down then the read/write ...
2
votes
0answers
76 views

Restricted LDAP mimic server backed on SQL

I may not be an expert on the subject, but it seems to me that 99% of any LDAP server installation is used only to provide user authentication credentials and nothing more. Given this restricted ...
2
votes
0answers
74 views

Flipping between databases

I have inherited a tomcat application running on RHEL that connects to a local postgres database. We have a total of 8 servers in multiple states running this. Each server actually has two different ...
2
votes
0answers
281 views

Postgres 9.0 locking up, 100% CPU

We are having a problem where our Postgres 9.0 server occasionally locks up and kills our webapp. Restarting Postgres fixes the problem. Here's what I've been able to observe: First, usage of one ...
2
votes
0answers
220 views

PostgreSQL On Ubuntu stopped responding and failed to Start

I'm on Ubuntu machine. Postgresql stopped responding today morning. And the process was in idle state. When I executed restart script the output I get - sudo /etc/init.d/postgresql-8.4 restart * ...
1
vote
0answers
35 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 + ...
1
vote
0answers
194 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 ...
1
vote
0answers
144 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. ...
1
vote
0answers
354 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 ...
1
vote
0answers
194 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: ...
1
vote
0answers
153 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 ...
1
vote
0answers
22 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. ...
1
vote
0answers
73 views

Tell proftp to allow connections only to the users that have permissions in PostgreSQL

I'm trying to set up an ftp server for the first time (under Debian Squeeze) and after searching through Google, I decided to use proftp. NOTE: I have a PostgreSQL server running in the same machine ...
1
vote
0answers
264 views

Issue connecting to Amazon RDS with stunnel on Windows

I'm trying to set up a local pgbouncer server that then connects using SSL to Amazon's PostgreSQL RDS service. According to pgbouncer's documentation, you need to use something like stunnel to ...
1
vote
0answers
74 views

PostgreSQL replication lag Ubuntu 11.10/12.04

I've a PostgreSQL cluster running on Amazon AWS EC2 instances with streaming replication and "hot standby" option enabled. I'm now gradually upgrading it from Ubuntu 11.10 to Ubuntu 12.04 LTS and I've ...
1
vote
0answers
698 views

postgres not starting after reboot on ubuntu

I'm not familiar with ubuntu (raring), so could someone help me please: I'm using postgresql 9.1 from apt. It installed the appropriate init script in /etc/init.d/postgresql. I can start the server ...
1
vote
0answers
225 views

osm2pgsql - Failed to allocate space for node cache file

it's my first time trying to set up a OSM server. I have been following this tutorial: https://github.com/AnderPijoan/vectorosm (with node why i need to change how the maps are rendered for some ...
1
vote
0answers
254 views

segmentation fault trying to start ldap

My PDC using Samba 3.6 with LDAP (the latest version) works very fine as long as I use hdb as the backend. Nevertheless, I change the backend to sql I receive the following error while trying to ...
1
vote
0answers
89 views

How can I store the Postgresql data on the EBS Volumes and not on the Root Volume?

My PostgreSQL database is currently stored in the cloud. Normally, when creating a PostgreSQL database, all the data is stored on the root volume of the EC2 instance. How can I make sure all the ...
1
vote
0answers
509 views

security group not allowing connection to postgres ec2 aws

Hey im having some trouble allow remote connections to postgres from other ec2 instances using the named security group feature to rules. I have set the listens directive in postgres.conf to "*" and ...
1
vote
0answers
69 views

No remote access to PostgreSQL db

i'm stuck in connecting to a PostresSQL database from remote host. The server is accepting incoming connections on port 5432 and i've configured pg_hba.conf like this: local all all ...
1
vote
0answers
224 views

PostgreSQL 1 master, multiple slave replication over slow links

I have a current use case in which remote computers query a central PostgreSQL database over a internet connection (read-only). We would like to implement a "stand-alone" system for these terminals so ...
1
vote
0answers
299 views

Apaches seems to not be shutting down Established TCP connections

I have a needle in a haystack type problem I'm trying to track down. Have not been able to recreate it on test servers. The symptom is TCP connections left in an ESTABLISHED state so don't seen to ...
1
vote
0answers
429 views

Debian 6.0.3, Freeradius 2.1.10, PostgreSQL 8.4 High memory Usage

We are running a Freeradius server on a VMware server and we have a high memory usage that I am trying to troubleshoot. We are running the PostgreSQL 8.4 as the database backend on the same server for ...
1
vote
0answers
107 views

Add new ODBC driver libs to PHP on OS X 10.6?

I'm trying to access a PostgreSQL datasource via ODBC from the installed stock PHP (OS X 10.6). Queries just hang, and I'm suspecting it can't find the PostgreSQL driver library which was installed ...
1
vote
0answers
157 views

how to log trigger intiated CRUD queries on postgresql 8.4

in the postgresql config file there is an option log_statement = 'mod' which causes CRUD statements to be logged. However this does not include the CRUD statements that are called from trigger ...
1
vote
0answers
1k views

PostgreSQL: Could not connect to server even though it's running!

I wonder if you could possibly help me. I have installed PostgreSQL and I have tried running various checks to ensure it is running and I know it is. Here are the results of searching for the ...
1
vote
0answers
557 views

I can't register a user on ejabberd with postgresql

Whenever I try adding a new user like: ejabberdctl register admin localhost default It gives me the following error: Problem 'error undef' occurred executing the command. Stacktrace: ...
0
votes
0answers
19 views

postgres sql returning "more than one row returned by a subquery used as an expression

Postgres sql is returning: more than one row returned by a subquery used as an expression The data base format is: rpt_rec_num | wksht_cd | line_num | clmn_num | itm_val_num ...
0
votes
0answers
9 views

openshift gear borks and restarts

I have a Django application on Redhat OpenShift that uses a postgresql database. I use the free plan with 1 small gear using: Python 2.7 PostgreSQL 9.2 For a certain command I get thrown out from ...
0
votes
0answers
42 views

CentOS 7 Cluster with load balancer

I'm trying to understand how clustering works in CentOS 7. I'm not a cluster expert!!! What I'm trying to do is to have three clustered services: httpd, mariadb (mysql) and postgresql. I've managed ...
0
votes
0answers
37 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 ...
0
votes
0answers
139 views

HAProxy tcp load balancing with an https check fails

I'm trying to load balance a posgres tcp connection, with a node check done via a python script residing on an https connection. conf file looks like so: global log 127.0.0.1 local2 ...
0
votes
0answers
22 views

Connect to posgresql, WAN, settings

I´m working and reading on how to build up a postgresql-server. So far I´ve set it up and works smooth on my LAN. Now I want to access it from others computers on the internet. I´ve been reading here ...
0
votes
0answers
56 views

PostgreSQL 9.2/9.3 Streaming Replication Failback

I'm setting up a postgresql 9.2 streaming replication pair and writing up some documentation for failback after the secondary has been promoted. The official line seems to be that a full data dump of ...
0
votes
0answers
84 views

Gitlab update from 7.2.0 centos(mysql) to 7.7.2 ubuntu(postgres), can't create ssh key, or new project

I had a CentOS server running gitlab 7.2.0, which uses mysql server. I updated to the omnibus version of 7.7.2 successfully porting the database from mysql to postgres using instructions found here ...
0
votes
0answers
104 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
0answers
24 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
40 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
0answers
71 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 ...
0
votes
0answers
97 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
0answers
44 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 ...
0
votes
0answers
136 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 : ...