186 reputation
8
bio website nuovolabs.com
location Jupiter, FL
age
visits member for 1 year, 4 months
seen Mar 11 at 17:50

I am a Python / Django developer. I specialize in developing SAAS applications using Django. My language of choice is Python, but I am sometimes forced to use English. Django rules.


Dec
20
awarded  Self-Learner
Oct
29
comment Do I need to perform any tasks after Postgres goes into recovery mode?
Thanks so much. I actually ended using Heroku (with their Postgres offering). I just didn't feel comfortable enough trying to run everything on my own, and felt irresponsible for trying (since it's a real company of mine, not a personal project). Also, I ran into a 6 hour downtime at Rackspace, and the Rackspace people A) weren't even aware that my server was down due to a hardware failure, and B) took 4.5 hours to fix the single disk failure after I reported my server was down. My reason for using them in the first place was to avoid the (rumored) downtime hours that Heroku has each month...
Jul
26
comment I need help understanding Postgres's archive cleanup functionality
Oh my gosh, I had no idea. Thanks for all your great work (to the company and you yourself of course).
Jul
25
comment I need help understanding Postgres's archive cleanup functionality
Thanks, Craig. I'll give PG Barman a shot, soon. Also, I only just realized that 2nd Quadrant was the creator of the project.
Jul
25
accepted I need help understanding Postgres's archive cleanup functionality
Jul
24
asked Do I need to perform any tasks after Postgres goes into recovery mode?
Jul
23
asked I need help understanding Postgres's archive cleanup functionality
Jul
15
comment Why does Postgres generate an already used PK value?
Ha, yes indeed - thanks for the answer and replies.
Jul
12
comment Why does Postgres generate an already used PK value?
This issue occurred 3 more times in a row just now. What I've found is that when it does occur it happens one or more times in a row for a given table, then not again. It seems to happen for every table before it completely stops for days, happening for at least a minute or so per table when it does occur, and only happening intermittently (not all tables right away).
Jul
12
accepted Why does Postgres generate an already used PK value?
Jul
11
comment Why does Postgres generate an already used PK value?
If Django was to "reset sequences", could this cause the problem? Also, if I insert a row over top an existing row, with the primary key set to 1 (using a Django fixture), could that cause this problem to later occur?
Jul
11
comment Why does Postgres generate an already used PK value?
@swasheck - I'm not certain about anything, to be honest. The fact that this error is so intermittent (happened only 3 or so times in 2 weeks - no other load on the DB, just me testing out my application) is what makes me so wary of a low-level problem.
Jul
11
asked Why does Postgres generate an already used PK value?
Jul
3
accepted Why aren't my Postgres WAL segments (up to the point of turning on archiving) being archived?
Jul
3
answered Why aren't my Postgres WAL segments (up to the point of turning on archiving) being archived?
Jun
25
comment Why aren't my Postgres WAL segments (up to the point of turning on archiving) being archived?
@MatheusOl It was a pg_ctlcluster 9.2 mycluster stop --force, which resulted in an "immediate" shutdown because it ended up taking too long to stop.
Jun
25
comment Why aren't my Postgres WAL segments (up to the point of turning on archiving) being archived?
@MatheusOl - Sorry, I forgot to @ your name on my previous reply.
Jun
24
comment Why aren't my Postgres WAL segments (up to the point of turning on archiving) being archived?
I did a hard restart on the master, but the slave hasn't ever been started.
Jun
24
awarded  Promoter
Jun
23
revised Why aren't my Postgres WAL segments (up to the point of turning on archiving) being archived?
deleted 5 characters in body