Страницы

25 мая 2016 г.

What is the difference between a .war and .ear file?

In J2EE application, modules are packaged as EAR, JAR and WAR based on their functionality
JAR: EJB modules which contain enterprise java beans (class files) and EJB deployment descriptor are packed as JAR files with .jar extenstion
WAR: Web modules which contain Servlet class files, JSP Files, supporting files, GIF and HTML files are packaged as JAR file with .war (web archive) extension
EAR: All above files (.jar and .war) are packaged as JAR file with .ear (enterprise archive) extension and deployed into Application Server.

Link: http://stackoverflow.com/questions/1594667/war-vs-ear-file

20 мая 2016 г.

pg_dump, ошибка!

Пытаемся стянуть дамп базы, итог:


pg_dump: [archiver (db)] connection to database "myDB" failed: FATAL:  no pg_hba.conf entry for host "ip-address", user "postgres", database "database_name", SSL on
FATAL:  no pg_hba.conf entry for host "ip-address", user "postgres", database "myDB", SSL off


Хорошая статья о том как решается проблема:
http://pgcookbook.ru/article/no_pg_hba_conf_entry_for_host.html


PostgreSql. Сколько весят базы?

select t1.datname AS db_name, 
       pg_size_pretty(pg_database_size(t1.datname)) as db_size
from pg_database t1
order by pg_database_size(t1.datname) desc;