Re: [ADMIN] [SQL] Thoughts on a Isolation/Security problem.

2006-04-18 Thread Achilleus Mantzios
y , Organization, where you can > have company1, org1, org2 etc., this can also be applied in the same pattern > as stated above. Thanx for your thoughts, but this would require touching 173 tables + 2,594 SQL statements in a sum of 324 programs (which sum into 125,085 lines of code) >

Re: [ADMIN] [JDBC] Thoughts on a Isolation/Security problem.

2006-04-18 Thread Achilleus Mantzios
O Markus Schaber έγραψε στις Apr 18, 2006 : > Hi, Achilleus, > > Achilleus Mantzios wrote: > > > Now i am thinking of restructuring the whole architecture as: > > - Create one EAR app for every mgmt company > > - Create one DB USER for every mgmg company > &

[ADMIN] Thoughts on a Isolation/Security problem.

2006-04-18 Thread Achilleus Mantzios
Hi, i have run into the following problem. Let me describe the context first. When i joined the company(ies) i work for (a group of Shipping Mgmt/ Owenship/Agent companies), the only thing i was told when i started designing the DB/Apps was just one company. So i built everything into one single

Re: [ADMIN] Kernel 2.4->2.6 upgrade results in PANIC: could not locate a

2006-04-14 Thread Achilleus Mantzios
Problem solved. The sysadmins yesterday forgot to mention to me that they didnt mount correctly all the file systems (including the one of pg_xlog). Sorry for the noise :-) O Achilleus Mantzios έγραψε στις Apr 14, 2006 : > > Hi, we have happily been running postgresql 7.4.x (currently

[ADMIN] Kernel 2.4->2.6 upgrade results in PANIC: could not locate a valid checkpoint record

2006-04-14 Thread Achilleus Mantzios
Hi, we have happily been running postgresql 7.4.x (currently 7.4.12) on a debian linux with kernel 2.4.x for some years without any issues. Yesterday after switching to 2.6.16 we experienced the following problem upon pgsql startup: LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0069

Re: [ADMIN] Conditional row grained replication with DBMirror

2003-09-09 Thread Achilleus Mantzios
review them. > > ------- > > Achilleus Mantzios wrote: > > > > > > I made a modification on DBMirror.pl, > > an addition in the slavedatabase.conf file, > > and added another replication table &

[ADMIN] Conditional row grained replication with DBMirror

2003-08-14 Thread Achilleus Mantzios
r.pl, MirrorSetup.sql, and slavedatabase.conf. -- ====== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-210-8981112 fax:+30-210-8981877 email: achill at matrix dot gatewaynet dot com