Peter Eisentraut

less info
1,943 reputation
1716
bio website petereisentraut.blogspot.com
location Pennsylvania
age 35
visits member for 5 years, 1 month
seen Jul 9 at 19:24

PostgreSQL and Debian hacker, DBA at MeetMe


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 security 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 security 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 security updates?
Jan
24
answered Debian or CentOS for VPS?
Jan
21
answered Is there any way to list all required libraries when configuring at a time?
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?