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 ...
3
votes
0answers
48 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
65 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
211 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
172 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
16 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
69 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
49 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
102 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
72 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
126 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
54 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
90 views
How to grant in Puppet a global permissions to PostgreSQL?
Official postgresql module from puppetlabs allow granting privileges on specific database.
postgresql::database_grant{'grant to myuser':
privilege => 'CREATE',
db => ...
1
vote
0answers
120 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
62 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
270 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 ...
