129 reputation
110
bio website fangiotophia.com
location Abilene, TX
age 28
visits member for 4 years, 6 months
seen Feb 8 at 17:21

Software architect working with PHP, Rails, PostgreSQL, jQuery, SproutCore and vim (the best damn editor on the planet).

Check out my mad skillz!


Dec
4
accepted Debian Apache2 and SSL
Dec
4
comment Debian Apache2 and SSL
As it turns out, we are using an old key file from our old domain...or it's the new file but was renamed wrong. Is it possible to use the same key file for multiple domains?
Dec
4
comment Debian Apache2 and SSL
I'm at lunch at the moment. I'll look for it in just a bit though. Thanks for your confirmation. If two people think it, perhaps it's right :-) Or, we'll all fall off a cliff and die =P
Dec
4
asked Debian Apache2 and SSL
Nov
12
comment Proper Way to Grant Permissions in PostgreSQL
@JosephL - Thanks! That should work perfectly :-)
Nov
11
awarded  Commentator
Nov
11
accepted Proper Way to Grant Permissions in PostgreSQL
Nov
11
comment Proper Way to Grant Permissions in PostgreSQL
@JoesephL - Thanks, it worked! Now the only problem is that it requires me to type the password for every myfile.sql that I import (which is only 3 at the moment, but it's still a lot of user interaction). Any idea how to change that?
Nov
11
comment Proper Way to Grant Permissions in PostgreSQL
@JoesephL - Thanks, I'll give it a try and comment.
Nov
11
comment Proper Way to Grant Permissions in PostgreSQL
@ironchef - Yeah, that thought crossed my mind; attempted it, still the same problem.
Nov
11
comment Proper Way to Grant Permissions in PostgreSQL
I tried grant all privileges on database demo to demo; but I am still getting ERROR: permission denied for relation whatever. I am running 8.3.
Nov
11
comment Proper Way to Grant Permissions in PostgreSQL
Updated code to show that it is going into the demo database. Does it matter what user I use to import it?
Nov
11
revised Proper Way to Grant Permissions in PostgreSQL
Added a note about the user running the commands.
Nov
11
comment Proper Way to Grant Permissions in PostgreSQL
Thanks, I think I tried this, but I'll try again and come back to comment/select an answer.
Nov
11
comment Proper Way to Grant Permissions in PostgreSQL
Unfortunately, as my question attempted to state, what I have done is NOT granting permissions on the demo table for the demo user. I can't do a simple select statement on the table until I have executed grant all on table_name to demo.
Nov
10
answered Have too many tables in a Mysql database can affect performance?
Nov
10
asked Proper Way to Grant Permissions in PostgreSQL
Oct
13
answered What are reasons to have a site 'down for maintenance'?
Oct
12
awarded  Teacher
Oct
12
answered Postgresql db restoring from dump fails