Reputation
2,378
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
1 11 18
Newest
 postgresql
Impact
~191k people reached

Apr
18
answered PSQL error with restarting postgres in SSL
Apr
14
comment Why does pg_restore take so much longer on Ubuntu than Windows?
That still doesn't explain 7 hours to restore a 21 MB dump.
Apr
2
answered Database checksum features - redundant? useful?
Mar
26
answered Postgresql with ldaps:/// url on port 636
Feb
27
answered What's difference between “varchar” and “text” type in PostgreSQL?
Feb
19
answered postgres - sharing same pg_hba.conf between IPV4 system and IPV6 system
Feb
17
comment How to run Postgresql 8.2 on Debian lenny?
Well, try it out. It should work, but you can probably construct a scenario where it won't.
Feb
17
comment How to run Postgresql 8.2 on Debian lenny?
aptitude hold postgresql-8.2
Feb
16
answered How to run Postgresql 8.2 on Debian lenny?
Feb
16
answered any tips for upgrade postgres 8.2 to 8.4?
Feb
9
comment Reset postgresql
It's under /usr/lib/postgresql/x.y/bin/.
Feb
9
answered EXPLAIN with index suggestions
Feb
6
answered Should I do a fresh install of PostGreSql?
Jan
26
comment Too much memory being swapped out, while cache uses it all on Centos 5.4
Well, if PostgreSQL needs more memory for the sorting than work_mem allows, it spills to disk, which is RAM in your case. You lose either way. So you see that using tmpfs with PostgreSQL might not make much sense.
Jan
25
answered Postgres 8.4 server not starting on Redhat after crash
Jan
24
comment Debian: automatic notification of updates?
apt-get does not re-download the entire package database. See pdiff files. If nothing changes, you end up downloading a few bytes. And yes, I do use local mirrors/proxies when appropriate. And yes, I do pull updates several times a day. The background of that is more complex, however, and might be the subject of another question.
Jan
24
comment Debian: automatic notification of updates?
Zoredache: Excessive how? Security updates can happen any time, and even the regular mirror pushes are 4 times a day. So 8 hours are indeed excessively seldom. ;-) In fact, on newer installations I run similar probes hourly.
Jan
24
answered Debian: automatic notification of updates?
Jan
24
answered Debian or CentOS for VPS?
Jan
20
awarded  Citizen Patrol