5,523 reputation
1029
bio website
location Düsseldorf, Germany
age 40
visits member for 5 years, 5 months
seen Oct 17 at 11:42
Software developer, mathematician

Jun
20
answered Monitoring bespoke software with Zenoss
Jun
20
revised logrotation size limit is not effecting
formatting
May
27
comment pg_restore taking much longer than pg_dump
@Stefano: Actually, production issues are not a problem, as I need the dump/restore for automated Q/A tests. However, the Q/A environment should be easy to set up (because ideally each dev should have his/her own, in addition to several company-wide environments), and requiring a dedicated DBMS installation with all kinds of backup scripts is something I would like to avoid.
May
27
comment pg_restore taking much longer than pg_dump
@Stefano: Interesting option; I didn't know this was possible. I don't think this is feasible for us, though, as has quite a few constraints (need to shutdown DBMS, need to dump/restore all databases). I fear this is only feasible if you have a PostgreSQL installation all to yourself, which I cannot assume.
May
21
answered Is a Network Switch IP-Aware?
May
20
comment Why does my memory used (accounting for cache) does not correspond to my processes memory usage?
Could you post the output of free, and of ps aux? Maybe we spot something.
May
12
awarded  Yearling
May
11
awarded  linux
Apr
24
awarded  Nice Answer
Apr
21
comment Looking for open-source or inexpensive Windows-based server monitoring solution that
Interesting, I had never heard of this tool. Looks neat.
Mar
30
comment Looking for open-source or inexpensive Windows-based server monitoring solution that
Well, I've written a plugin for NetSNMP myself ( net-snmp.org ) , which was basically just a shell script that NetSNMP runs on demand. I've never used NetSNMP on Windows, but they do have a Windows version. Just try it.
Mar
30
answered Looking for open-source or inexpensive Windows-based server monitoring solution that
Mar
29
awarded  Scholar
Mar
29
accepted pg_restore taking much longer than pg_dump
Mar
23
revised On demand upload server
formatting
Mar
2
comment pg_restore taking much longer than pg_dump
@Frank: Thanks. Didn't know about pg_dump's implementation. In our case, speeding up the restore would be helpful, because it needs to run repeatedly as part of automated tests, so bringing it down from 1 minute to say 10s would help. But apparently that's not feasible. I'll have to find a different solution...
Mar
2
comment pg_restore taking much longer than pg_dump
Interesting, thanks. Is there a way to dump the index as well, to speed up the restore (at the cost of a larger dump file)?
Mar
2
asked pg_restore taking much longer than pg_dump
Feb
10
awarded  Citizen Patrol
Feb
8
answered df in linux not showing correct free space after file removal