[GENERAL] Swing JTable and ResultSet TableModel (with big resultsets)

Hi, I don't know if this is the right list for this question but I don't know where to ask...   I have a question about JTable and a ResultSet TableModel (using JDBC postgresql driver).   I have to develop a swing JTable application that gets the data from a ResultSetTableModel where the use

[GENERAL] database file encryption

Hi all,   I have just discovered that in postgres database file the data are not encrypted. If I open with a text editor these files I can read the records values.   I'd like to know if there is a way in order to encrypt these data.   PS. for example in mysql the database file are not reada

[GENERAL] Data warehouse & OLAP

hi, I'm working in the implementation of a datawarehouse on Postgres.   For analisys of aggregated data I'd like to use some OLAP tools like for example, Mondrian, OR use the meterialized view (if better).   My questions: is there any documentation about warehouse (with OLAP or materialized

[GENERAL] Finding missing records

Hi,   I have two identical tables   table1 (f1,f2,f3,f4 primary key (f1,f2,f3,f4)) table2 (g1,g2,g3,g4 primary key (g1,g2,g3,g4))   How can I find the difference between the two tables? table1 has 1 records table2 has  9900 records (these records are in table1 as well)   I'd like to fin

[GENERAL] could not connect to the server error

Hi,   I have several java jdbc client applications that connect to my Postgres 8.0.4 server. "After some days" the server rejects the connections. There are no message in the log file. Only the local connections are permitted.   I have tryed to make a connection with EMS postgresql and I

[GENERAL] Postgresql server "crash" after some day

Hi all,   I have some strange problems with postgres. After some days it works in local but it doesn't listen on port 5432 for remote request.   I can make a connection from local host but I can't from remote host. If I try to make a connection from remote host the server returns me the clas