How to use tcp_keepalives settings in Postgresql?

Postgresql has 3 keepalive settings for managing dropped connections (in postgresql.conf): tcp_keepalives_count tcp_keepalives_idle tcp_keepalives_interval By default these are 0. The behavior I...

INFO: Additional JARs have been added : 'xalan-2.7.0.jar'

After a successful start of Tomcat and a few REST calls I get this message in Tomcat console and then the application reload it self. And because reload takes a few seconds, response time is too...

"bad record MAC" SSL error between Java and PortgreSQL

We've got here a problem of random disconnections between our Java apps and our PostgreSQL 8.3 server with a "bad record MAC" SSL error. We run Debian / Lenny on both side. On the client side, we...

Hibernate + PostgreSQL : relation does not exist - SQL Error: 0, SQLState: 42P01

I am having some problems trying to work with PostgreSQL and Hibernate, more specifically, the issue mentioned in the title. I've been searching the net for a few hours now but none of the found...

How to break connections TCP/IP by keepalive postgreSQL without changing anything in the register?

I have a system working with the client-server structure and PostgreSQL 8.4. My problem is that if a client is editing a record and lose his connection to the server, the TCPIP connection is...

org.hibernate.StaleObjectStateException when using Grails with PostgreSQL

I've written a grails service with the following code: EPCGenerationMetadata requestEPCs(String indicatorDigit, FilterValue filterValue, PartitionValue partitionValue, String...

Unable to connect Django app to an external PostgreSQL database

Short Description I am having a number of issues trying to connect a Django app (currently setup as SQLite3) to a newly created PostgreSQL on my Ubuntu Server. The Question(s) Can anyone share...

Django "can't adapt type" error using mutliple databases (Postgresql 8.4 and sqlite3)

Short Description Using a local (sqlite3) database I can save and extract information, however when using my production sever (postgresql 8.4 on a different machine) Django throws a "can't adapt...

How to loop through array_agg as iterated columns?

Using PostgreSQL 8.4, I have successfully been able to use array_agg() to take a case of multiple orders and make a single row per customers: From this: order_id|customer_id|order_date ...

'password authentication failed for user "postgres"'

I have installed PostgreSQL 8.4, Postgres client and Pgadmin 3. Authentication failed for user "postgres" for both console client and Pgadmin. I have typed user as "postgres" and password...

Rails produces "PGError: server closed the connection unexpectedly" after some timeout

I have the setup of my Rails app as following: Rails: 3.0.5 (under Apache proxy) running on RHEL 5.6 Postgres: 8.4, running on Windows Server 2008 The 2 servers are on the same LAN. The problem...

How to install Postgresql in Vagrant box

I'm trying to install postgresql in a vagrant box but am having no luck. I tried provisioning with Chef AND Puppet then finally just ssh'd into the box and tried apt-get install... the result is...

How does the locale setting LC_NUMERIC work in PostgreSQL?

Could anybody give an insight on the locale and numeric types behaviour in PostgreSQL? We work with Italian locale. That is comma separation for decimal part. Setting in postgresql.conf # These...

Fail to build pg gem

I have: Ubuntu 11.10 Postgres 8.4 libpq-dev, build-essential installed ruby 1.9.2 and rails 3.2.1 install via rvm However, pg gem fails to build, saying that: checking for pg_config... yes Using...

Spring JPA/HIbernate create/update views when the application starts

Our application is based on spring, JPA, Hibernate (3.5.1), postgresql 8.4 We will deliver a new .war file to our clients, but we have quite a few new views in the DB needed to be created before...

Remote trigger a postgres database backup

I would like to backup my production database before and after running a database migration from my deploy server (not the database server) I've got a Postgresql 8.4 server sitting on a CentOS 5...

How to install postgres-9.1 on Ubuntu 10.04 LTS?

Many months ago, I installed postgres 8.4 using the following command: $ sudo aptitude install postgresql-8.4 postgresql-client postgresql-contrib Now I am trying to upgrade to 9.1. $ sudo...

postgresql.conf optimization

My postgresql server is extremely slow. Especially when I execute several queries at the same time in different threads, which somtimes causes the postgresql server to be unresponsive for 5 to 15...

Using psql to connect to PostgreSQL in SSL mode

I am trying to configure ssl certificate for PostgreSQL server. I have created a certificate file (server.crt) and key (server.key) in data directory and update the parameter SSL to "on" to enable...

PostgreSQL VCL controls

One of the products I write software for is an accounting type application. It is written in C++, uses C++ Builder and VCL controls, connects to PostgreSQL database running on Linux. The...

What is the best way to run a longest matching prefix against a table column?

I need to run a longest matching prefix against a column in a table, not just a single value. For a single value I use something like SELECT value, prefix as lmp FROM aTable WHERE...

apt-get update not running before postgresql installs

I'm using vagrant to create an instance of postgresql running on Ubuntu 10.04, using the opscode cookbooks, but for some reason apt-get update isn't being called before postgresql runs, so the...

TransactionManager Spring 4 hibernate 4 NoSuchMethodError

I'm trying to use annotation based transaction management in spring, this is my spring configuration: <?xml version="1.0" encoding="UTF-8"?> <beans...

Geotools java.lang.NoClassDefFoundError: org.hsqldb.lib.FrameworkLogger

I am attempting to write some simple GeoTools based code for accessing a WFS server. The code looks like this so far: String getCapabilities =...

OpenShift - Update Python and Install PIP in a Rails app

I have created my Rails app on OpenShift. It uses Python and a package installed from PIP. How do I upgrade to a newer Python version (currently it is 2.6) ? Visible cartridges: [email protected]:~$ rhc...

PostgreSQL: Capture RAISE NOTICE from a client connection via ZeosLib/Lazarus

I have developed a client application that use PostgreSQL 8.4 RDBMS. My Application is written in Lazarus and ZeosLib 7.2 for database access. I use a lot of stored procedures and in specific...

PostgreSQL how to DROP TABLE with extreme prejudice

We use postgres as a real-time data cache for observations. We need to drop our tables on a daily basis. There are frequently clients that still have the db open for reading, actually they have...

django docker exited with code 0 in request GET or POST

Good friends, I am developing an application in django 1.11 with docker on windows, recently update the git repository of the project and also made some changes with docker containers. The problem...

The following packages have unmet dependencies: postgresql-9.6

Please help, I'm trying to install a fresh install of postgres-9.6 and only that version, but I keep receiving this error when I try to run: sudo apt-get install...

Docker Image > 1GB in size from python:3.8.3-alpine

I'm pretty new to docker and, although I've read lots of articles, tutorials and watched YouTube videos, I'm still finding that my image size is in excess of 1 GB when the alpine image for Python...