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)

5
votes
0answers
617 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 ...
5
votes
0answers
680 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 ...
4
votes
0answers
148 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. ...
4
votes
0answers
297 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 ...
4
votes
0answers
528 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 ...
2
votes
0answers
767 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
209 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
81 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
75 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
228 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
25 views

How can I efficiently create daily write replicas of an RDS instance?

We're looking to create a replica of a postgres RDS instance that our developers can write to (not just a simple read replica that AWS can easily provide). Currently we run a script nightly that ...
1
vote
0answers
155 views

PostgreSQL - Invalid byte sequence for encoding “UTF8”: 0xe7 0x75 0x20

Here is the problem : Everything worked fine with my postgresql system until I decided to click on the "rotate logs" button in the server status tab (from pgAdmin). After that, I faced this issue, ...
1
vote
0answers
12 views

Does a PostgreSQL hot standby cache streamed WAL segments?

If pg_xlog_replay_pause() is used or max_standby_streaming_delay is set, are unapplied WAL segments stored on the hot standby? I'd like to be clear if a long-running query is keeping WAL segments ...
1
vote
0answers
62 views

Postgres streaming replication over Internet

all: I want to set up two PostgreSQL servers, one as master server and the other one as a hot standy, using streaming replication. I have done this before in LAN environments, but I would like to ...
1
vote
0answers
55 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
171 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
509 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
145 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 ...
1
vote
0answers
277 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
1k 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
0answers
214 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
108 views

Postgresql upgrade between major versions without downtime

Is there any recommended way to upgrade between different postgresql versions (say, 9.2 to 9.3) without downtime?
1
vote
0answers
78 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
283 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
75 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
997 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
249 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
241 views

postgres server won't start

I get this error when I try to start postgresql: Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 235. Line 235 in /usr/bin/pg_ctlcluster last if ...
1
vote
0answers
280 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
92 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
539 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
71 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
238 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
320 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
449 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
110 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
166 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
605 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
45 views

PostgreSQL failover with Kubernetes

I've got master slave replication working with Kubernetes, but would now like to implement failover. I have pods running with the service=postgresql and role=master or role=slave roles. When the ...
0
votes
0answers
22 views

PgBouncer not listening with no errors in logs

I currently have Postgres working on my server want to move to connection pooling. Looking around and PgBouncer seems to be the tool of choice. I have set it up and it claims to start fine with the ...
0
votes
0answers
20 views

Using PostgreSQL at web host, editing pg_hba.conf

I have a domain at HelioHost.org, where I want to connect to a PostgreSQL server, which they supposedly support. But I get the following error message when looking at my PHP files in Firefox: ...
0
votes
0answers
28 views

How to install Nomtimatim in postgresql (windows)

I am trying to do geocoding in the postgresql, and I have already installed TIGER geocoder successfully. Then, I want to use Nomtimatim in postgresql. However,since the installed guide ...
0
votes
0answers
66 views

OS X Yosemite Server - Wiki stops working

the last couple of days I have noticed that the Wiki-Server on OS X Server seems to crash. When I call up the wiki's website I get the following message: Caught exception "Connection to DB failed" ...
0
votes
0answers
61 views

Postgresql Connection Timed out

when I am connecting to psql on remote server >psql -h {hostname} psql: could not connect to server: Connection timed out (0x0000274C/10060). Is the server running on host "{hostname}" ...
0
votes
0answers
23 views

Fallback to backup server upon failure of main server without third machine

I will soon need to setup a database server on a budget. We are planning to use Postgres on Ubuntu (most likely) and we'd like to have a backup server. For replication, I think I'll just use ...
0
votes
0answers
37 views

pgpool2 stucks in “idle in transaction”

We have a setup with two postgresql servers configured as master-slave (streaming replication). The application servers (Odoo) should connect through pgpool2. All is fine if I connect the application ...
0
votes
0answers
18 views

apache2 mod_dbd and postgresql

I'm trying to rewrite url using dbd. Everything looks ok, except few things: It doesn't work It doesn't show any error (LogLevel Trace8) It doesn't show any connection to database (postgresql.log ...
0
votes
0answers
73 views

After upgrading to PostgreSQL 9.4, unable to connect from localhost

I have recently upgraded from Debian 7 to Debian 8 and from PostgreSQL 9.1 to 9.4. I am not able to connect to my database server even from pgAdmin III on localhost. I have in my postgresql.conf the ...