713 reputation
17
bio website jackdb.com
location
age
visits member for 1 year, 1 month
seen Jul 14 at 13:58

Founder of JackDB, the web-based database development client:


Jul
18
awarded  Yearling
Nov
18
revised Are there any good and free tools for managing a PostgreSQL database?
Update link to JackDB
Nov
18
revised What GUI tools can be used for PostgreSQL in Mac OS X?
Update link to JackDB
Nov
7
answered How do I install postgresql in Ubuntu?
Oct
17
comment What ports does SQL Server need to communicate with a web server?
That's the source port for the client TCP statck to connect to the server. It's randomly chosen by the client's operating systems TCP stack (which on windows defaults to choosing something between 1024 and 5000). You do not need to open firewall traffic from for that port from the server to your client because it'll happen automatically as your client is the one initiating the connection. Your firewall will see that it's the continuation of network traffic your client itself initiated and it will be allowed.
Oct
17
answered What ports does SQL Server need to communicate with a web server?
Aug
16
answered ERROR: text search configuration name “english” must be schema-qualified
Aug
14
awarded  Commentator
Aug
14
comment Connecting to an external database with pgAdmin III
Well one more point for psql then. How did pgAdmin connect locally then? I'm guessing you must have been connecting to a different database. Otherwise I can't see how a local connection would work either if the server won't startup.
Aug
14
comment Connecting to an external database with pgAdmin III
Try connecting from the command line via psql and see what error it reports. It should be verbose enough to figure out the cause. If it says FATAL: password authentication failed for user then it's probably a mismatched password. If it says could not connect to server: Connection refused then it's probably a network/port issue. Is the CIDR you've specified of 192.168.0.0/24 correct? Should that be 192.168.1.0/24 (1 instead of 0 for the third byte)?
Aug
14
answered Connecting to an external database with pgAdmin III
Aug
14
awarded  Citizen Patrol
Aug
8
comment MySQL data retained after OS reinstall
An OS installation would only wipe out other data if you reformat the partition the data is on. If you have a single partition for your server (eg. just one mounted at /) and it's not recreated then all your data will persist after reinstallation. To wipe it out you need to use explicitly recreate the primary partition at the start of OS installation. Also, for added security you might want to look into using something like shred to make sure that old data is overwritten.
Aug
8
answered store country name or country id
Aug
8
answered Secure a hosted MySQL DB
Aug
8
answered Distributed - across multiple databases or servers - Transactions
Aug
7
revised How to determine Oracle LOB storage footprint?
Improved answer and added link to Oracle docs
Aug
7
comment fighting filter (nested loops) execution plan from Oracle
If val uniquely identifies a row in SMALL_TABLE then it would produce the same result. It's only different if the join could produce multiple rows in SMALL_TABLE (which would cause multiple rows of BIG_TABLE to be returned back).
Aug
5
answered Should I be concered by large SERIAL values?
Aug
2
awarded  Critic