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)

3
votes
0answers
84 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
16 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
66 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
222 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
180 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
87 views

postgresql: invalid authentication method “pam”: not supported by this build

When I try to start postgresql 9.3.1 I receive this in startup log: # cat /var/lib/pgsql/pgstartup.log LOG: could not create IPv6 socket: Address family not supported by protocol LOG: invalid ...
1
vote
0answers
31 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
142 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
58 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
151 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
104 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
143 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
57 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
147 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 ...
1
vote
0answers
63 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 ...
1
vote
0answers
292 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
62 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
267 views

pgsql troubles on centOS 5 with directadmin

I'm having trouble configuring pgsql for PHP 5.2 on the server I administer. It's a DirectAdmin enabled server, and the contents of ap2/configure.php5 are: #!/bin/sh ./configure \ --with-apxs2 \ ...
1
vote
0answers
150 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
233 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
592 views

postfix, courier-imap and virtual users quota

I am using Postfix MTA and courier-imap server. Clients and domains are virtual and stored in PostgreSQL database. Postfix reads quota data from SQL table OK and I can see such messages in maillog ...
1
vote
0answers
354 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
104 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
124 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
959 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
447 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: ...
1
vote
0answers
105 views

How Tune the best PostgreSQL for developers not for production?

Developing software on a laptop or a desk computer, what would the best configuration for make sure developers has a fast connections and response. For example a laptop with: 2 cores, 2GB of ram and ...
0
votes
0answers
17 views

PostgreSQL DB size increasing after restoring the same database backup

This is my batch script to take backup @ECHO OFF d: cd Apps\RemedyStar 9.0 KREMCOS\bin\Debug\PG pg_dump.exe -i -h localhost -p 5432 -U postgres -F c -b -v -f "C:\Documents and ...
0
votes
0answers
20 views

psql doesn't allow to input cyrillic symbols

I have a server with postgresql 8.4 installed on it. But when I try to insert some data in russian, for example: UPDATE category set question = '[there should be russian symbols]' WHERE id = 1; ...
0
votes
0answers
27 views

Tons of “invalid command \N” when restoring a dump

I'm following these instructions to upgrade postgres from 9.1 to 9.3: http://www.postgresql.org/docs/9.1/static/upgrading.html When I restore (Step 8), I get a ton of messages like this: ...
0
votes
0answers
23 views

PostgreSQL Error: out of memory

I'm trying to run a query that should return around 2000 rows, but my RDS-hosted PostgreSQL 9.3 database is giving me the error "out of memory DETAIL: Failed on request of size 2048.". What does ...
0
votes
0answers
16 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?
0
votes
0answers
43 views

Snort 2.9.2 doesn't see local network traffic any more

I installed Snort 2.9.2 + ACID BASE + Postgresql on Ubuntu Server LTS 12.04 about 5 month ago. Snort host have local IP address 10.0.40.3/24. There is a some hosts in 10.0.40.0 network. After ...
0
votes
0answers
13 views

libnss-pgsql logging transaction on screen

I've been configuring a pg database to authenticate user against pam. I installed libpam_pgsql and libnss_pgsql2. After I finish configuring the libnss_pgsql2, creating and editing the nss-pgsql.conf ...
0
votes
0answers
67 views

Postgres 9.3 won't work on Debian 7.1

Hi I am having problems installing postgres 9.3 on debian 7.1. I have added the following: deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main to the file ...
0
votes
0answers
24 views

Understanding parse, bind, execute entries in PostgreSQL logs

I am new to PostgreSQL logging and have a few questions. PostgreSQL is used as a database for a couple of comercial products (both on the same server). This is run on a Windows 2008 R2 server (as I ...
0
votes
0answers
146 views

PostgreSQL log warnings: open temporary statistics file, pgstat wait timeout

We frequently get the following warnings with our Postgresql Database LOG: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp": No space left on device WARNING: pgstat wait timeout ...
0
votes
0answers
302 views

Installing PosgreSQL Stack Builder on Windows with a proxy server

I have downloaded and installed PostgreSQL 9.3 (64 bit) on a developer machine running Windows 8.1 (64 bit). This developer machine requires use of a proxy server for accessing hosts external to the ...
0
votes
0answers
61 views

Make a fault tolerance platform with 2 servers (PGsql/Nginx) on Centos 6.4

I have two dedicated servers. Currently one is configured with PGsql (8.4) and nginx (php-fpm+SSL verisign) on a centOS 6.4. I just got the second one. To explain context, on one hand, I have a ...
0
votes
0answers
126 views

Django + Apache WSGI + pscopg2 + PostgreSQL 9.1 unexpected EOF on client connection

There are two servers I have. One is SQL server, other is Django project server. And sometimes I get too many unexpected EOF on client connection error by postgresql and OperationalError: could not ...
0
votes
0answers
56 views

PostgreSQL stuck in recovery mode, then not

It looks like a daemon on one of my servers got a little excited at 4am and slammed too much data into PostgreSQL, causing it to crash. There was a HUGE spike in disk I/O , then Postgres dropped into ...
0
votes
0answers
34 views

What is a good approach for setting up SVN, Maven, Glassfish on CentOS

I'm trying to set up a VPS that will serve us as remote PostgreSQL database, SVN repository, Maven build tool and will also host our Java EE applications. I've just installed and configured our ...
0
votes
0answers
48 views

postgresql streaming replication not replicating until it reaches archive_timeout

Working primarily from this blog post I have managed to get replication working between two test servers. The master/server are supposedly set up to do streaming replication, with WAL archiving as a ...
0
votes
0answers
39 views

Postgresql Replication slave-master writer

One thing that I don't know how to made with postgresql. I use pgsql 9.2 on Centos 6.4. I normally use system in HA and database is a critical point. Now I have 2 servers with some services and 2 ...
0
votes
0answers
52 views

not sure how to handle postgresql connections

I've done a fresh install of ubuntu and am setting up PostgreSQL I'm perplexed by something: In order for my commandline user to access PostgreSQL, I need to export an environment variable export ...
0
votes
0answers
108 views

Password data is not valid for scheme SHA512: Input length isn't valid (24 instead of 64)

I am setting up dovecot with pgsql. I have setup the MTA and can receive mail correctly with the mailboxes setup in the database, but when i login via a mail client to dovecot I get in my maillog: ...
0
votes
0answers
101 views

Upgraded pgbouncer 1.3.4 -> 1.5.4 and can not connect

On CentOS 6.4 Linux with the stock postgresql 8.4.13 package I have upgraded pgbouncer from version 1.3.4 to 1.5.4 and can not connect to my databases anymore. In /var/log/pgbouncer.log I see the ...
0
votes
0answers
176 views

Postgresql running slow

We recently migrated our postgresql server from a heroku 400mb ram add-on to a SSD VPS with 1GB of ram and we have seen a huge performance drop. I am using ubuntu 12.06 and have increased the ...
0
votes
0answers
54 views

Disable disk caches in AWS EBS for PostgreSQL?

It's my understanding that, without correctly disabling OS-level and drive-level caching, there is a chance that in case of system failure the Write-Ahead Log might not be saved correctly and in fact ...
0
votes
0answers
187 views

Samba username doesn't work once I join a Windows XP machine to my domain

I have set up a PDC using Samba, LDAP and Postgresql. I have successfully added all the necessari entries to my database and can also see all the necessary entreis in LDAP. I can also successfully ...