Reputation
2,063
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
1 8 17
Newest
 Explainer
Impact
~145k people reached

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
Jan
13
comment USABLE multi-master replication for Postgres?
Wow, just reading that list causes shock and terror for me. :)
Jan
13
answered USABLE multi-master replication for Postgres?
Jan
13
answered USABLE multi-master replication for Postgres?
Jan
13
answered how to prevent log output from PostgreSQL stored procedure?
Jan
13
comment PostgreSQL continuous archiving not running archive_command
Are you creating any WAL traffic?