Reputation
626
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 8 28
Impact
~62k people reached

Jun
1
comment Why won't Postgres start after stopping it?
@JoelESalas - I had configured shared_buffers to 256MB - shmmax was something smaller by default. I updated it to 384MB in /etc/sysctl.conf to get Postgres working again (the actual segment size requested was something like 277MB).
Jun
1
asked Building the necessary dependencies when apt-get installing on Ubuntu
Jun
1
revised Should a connection pooler be run on my database server or my app server?
added 165 characters in body
May
31
comment How can I “fix” a user that has no home dir but is logged in
It wasn't enough - I had to log the user out (or as you say, kill the remaining processes). However, even after making /home/postgres/ (with the contents of /etc/skel/) the home directory and giving postgres recursive ownership, su-ing as postgres still resulted in a $ command prompt (using /bin/sh vs /bin/bash)... so I nuked the entire server from orbit, and in the past hour I've set up an entirely new server, this time remembering to use adduser postgres.
May
31
accepted How can I “fix” a user that has no home dir but is logged in
May
31
comment How can I “fix” a user that has no home dir but is logged in
Thanks. The only problem is that I can't usermod -d /home/postgres postgres because postgres is currently logged in. How do I remedy that?
May
31
asked How can I “fix” a user that has no home dir but is logged in
May
31
accepted Why won't Postgres start after stopping it?
May
31
comment Why won't Postgres start after stopping it?
I have 2GB of RAM. Any idea what my shmmax should be set to? postgresql.org/docs/9.2/static/kernel-resources.html gives some examples, but I'm not sure if I'm supposed to make the 4096 * max pages == my total RAM...
May
31
comment Why won't Postgres start after stopping it?
Ah :( This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter...
May
31
asked Why won't Postgres start after stopping it?
May
23
comment Is using iptables to rate limit on port 80 considered wasteful?
Thanks for the explanation.
May
23
accepted Is using iptables to rate limit on port 80 considered wasteful?
May
22
accepted Should I be concerned with seeing this in my logs?
May
22
asked Is using iptables to rate limit on port 80 considered wasteful?
May
22
comment Should I be concerned with seeing this in my logs?
Thanks. I guess I should look for pam_unix(sshd:session): session opened for user root
May
22
comment Should I be concerned with seeing this in my logs?
Awesome, thanks! I didn't realize that basic iptables was "stateful". How can I use iptables to rate limit (including bursting, etc.)?
May
22
asked Should I be concerned with seeing this in my logs?
May
20
accepted Understanding networking in a web hosting environment
May
14
comment Understanding networking in a web hosting environment
Aha, thanks Taylor.