Enrironment: PGAdmin III, Ubuntu 14.x on different machines.
Symptoms: PGAdmin hangs, window grayed. Sometimes it happens occationally when connecting to DB, more often – when opening table properties or SQL queries window.
Solution: remove PGAdmin queries history file
Show list of active processes to see pid there
SELECT query, * FROM pg_stat_activity where state = 'active'
Cancel the process by pid
Configuration: Ubuntu 14.04, postgresql 9.3, postgis 2
Install all postgis* libraries
Today I installed one more PostgreSql on one more Ubuntu. That’s why I decided to memorize my steps here for quick reference.
Install postgresql and related packages
Type in terminal:
sudo apt-get install postgresql postgresql-contrib
sudo apt-get install pgadmin3
Setting password for postgres user
To set password for postgres user, open psql command prompt:
sudo -u postgres psql postgres
type password twice when prompted and please don’t forget it 🙂
press ctrl-D to exit
Today I configured another development stend for our team. This time I added Postgresql 9.3 ODBC driver support to our Glassfish 4 server. What should I do to repeat this actions:
Put Postgresql driver to Glassfish domain lib folder
This link contains the latest PostgreSql driver: http://jdbc.postgresql.org/download.html I got the postgresql-9.3-1100.jdbc41 one.
Copy downloaded driver to GLASSFISH_HOME/domains/YOUR_DOMAIN/lib, for example to /opt/glassfish4/domains/domain1/lib
This post is about adding PostgreSQL driver and data source to JBoss Application Server.
Used versions are: JBoss AS 7.1.1, PostgreSQL 9.1.10 and postgresql-9.3-1100.jdbc41 driver.
1. Download the driver
Download postgresql jdbc driver here http://jdbc.postgresql.org/download.html