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
|
1 |
rm ~/.pgadmin_histoqueries |
Show list of active processes to see pid there
|
1 |
SELECT query, * FROM pg_stat_activity where state = 'active' |
Cancel the process by pid
|
1 |
select pg_cancel_backend(<pid>) |
Configuration: Ubuntu 14.04, postgresql 9.3, postgis 2
Today I installed one more PostgreSql on one more Ubuntu. That’s why I decided to memorize my steps here for quick reference.
Type in terminal:
sudo apt-get install postgresql postgresql-contrib
sudo apt-get install pgadmin3
To set password for postgres user, open psql command prompt:
sudo -u postgres psql postgres
Type command
\password 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:
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
Restart Glassfish
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.
Download postgresql jdbc driver here http://jdbc.postgresql.org/download.html
