1,988 reputation
1817
bio website petereisentraut.blogspot.com
location Pennsylvania
age 35
visits member for 5 years, 4 months
seen Oct 17 at 17:51

PostgreSQL and Debian hacker, DBA at MeetMe


Dec
29
comment Update 9.3.x minor verison of postgres on Ubuntu 12.04?
You can use any package upgrade method you want; this was just an example. If you just want to upgrade the PostgreSQL packages, try something like apt-get install postgresql-9.3.
Oct
15
comment Get cron to send html-formatted emails
The CONTENT_TYPE variable solution mentioned in another answer seems to work at least in some cron versions.
May
31
comment Using Puppet to install, initdb and start Postgres database
Some reading on this: pgcon.org/2013/schedule/events/540.en.html
Jun
21
comment Embedded Code in PDF Documents
A good antivirus program can handle that. It will check the code "while" it is being run. Not as nice as checking beforehand, of course. The point is, antivirus programs are pretty good at dealing with potentially problematic PDFs. Anything you put together manually will probably not be as good.
Feb
22
comment Does copying a database in PostgreSQL preserve statistics?
The pg_stat_* tables are not actually tables but views that access information in shared memory. So the information there is not affected by the copying of the template database.
Oct
13
comment Is it possible to add SSL support after a build is up and running?
Data and config files are not affected by the program installation.
Oct
12
comment Is it possible to add SSL support after a build is up and running?
One question per question, please.
Oct
7
comment Postgres 9 baseline maintenance script
Well, a reindex will block your database for the time it runs. But if that doesn't bother you, reindex and vacuum full and cluster away.
Oct
6
comment Postgres 9 baseline maintenance script
Well, autovacuum off by default used to end up being a real gotcha for a lot of people as well. ;-)
Sep
29
comment How to install libpq-dev on Centos 5.5
No, that's a different package.
Sep
23
comment Invalid version while creating PostgreSQL 9.1 cluster
Build yourself a backport if you want your installation integrated with the postgresql-common infrastructure.
Aug
25
comment How do I change where psycopg2 looks for a pid file?
What you are describing the is not a PID file, but a Unix domain socket file. Also, if something fails, show the error message. If you change a configuration file, say what you changed.
Jun
3
comment Postgres 8.4 on Ubuntu 10.04 (Lucid) issue
Hard to tell because you haven't given any information on how you installed it.
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.
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
9
comment Reset postgresql
It's under /usr/lib/postgresql/x.y/bin/.
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
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.