Forum Overview :: BIT.TRIP RUNNER
 
Re: To: the Happiness Engine, re: pg_hba.conf by Ice Cream Jonsey 11/15/2014, 8:00am PST
Entropy Stew wrote:

Ice Cream Jonsey wrote:

After an installation of postgresql, you can't connect to the database from anything but localhost by default. You need to modify pg_hba.conf to allow other IP addresses to connect to the database server you just installed.

This is all fine, but what if you delete pg_hba.conf? (This is not what happened to me today, but just saying.)


THEN IT DOESN'T WORK. THIS IS WHAT HAPPENS WHEN YOU DELETE CONFIG FILES. Oh wow this windows install plays games great BUT WHAT IF I DELETE THE REGISTRY????? TAKE THAT, ATHEISTS!


If I delete wasteland2.ini, the game doesn't work but I can get a new copy of that .ini and place it in the correct directory and I'm on my way. The program works again. It's very easy to figure out where to put the file.

You can't do that with pg_hba.conf because you can't be guaranteed you know where the file is located. You have to login and make a request. You can't necessarily login unless you've already created that trust relationship.

From that link:

Yes, this is somewhat of a chicken-and-egg problem, in that if the user can't connect (say, after screwing up editing pg_hba.conf) you can't find pg_hba.conf in order to fix it.


(The chicken and egg problem goes away if you get a chance to add a trusted network to the conf file immediately after installation.)


No they don't! They set up fucking pg_hba.conf once on install to do proper auth against active directory or some SHIT and REMOVE local access to any user by any asshole and then it is done and they are done and it is DONE.


Database engineers where I've worked never seem to be done! In fact, they seem to be stressed all the time.


God FUCKING forbid you actually read, think anything in order to install a complicated piece of software. UH BLUH MY IPHONE WOULD HAVE HURFED THE BLURF *LATTE-SIP* THIS SUCKS


Wait a sec. I'm arguing that postgresql ask you what computer you might want to access the database you just setup after installation. If anything, that's more complicated than having it silently run with no options after apt-get or yum.

Also, it's postgresql for Christ's sake. I'm not trying to configure a multi-rack Hadoop cluster, I'm trying to save my handwritten stats for Bases Loaded II.

Also I don't drink lattes, sir. This time of year I get those orange coffees, from Starbucks, the pumpkin-spiced la- oh fuck.


Some Linux distributions, Debian is one of them, will not enable binding to external interfaces by default. The server will only bind to the loopback address (127.0.0.1), or in the case of services like X which support UNIX domain sockets, a unix domain socket will be used. This, as well as the reduction in privelage and requirement to create a password on installation, gives increased security by default


"Guys, I figured out a way to make our computers secure! Turn off all ports that would ever allow anyone to access it!"


NOBODY ALLOWS FUCKING REMOTE ACCESS BY DEFAULT YOU FUCK UNLESS YOU WANT WOOOOOOOOOOOOOOOOOOOOOOOOOOORMS


I'm not arguing for that, just a heads-up on where I'd have to go -- literally the location of the .conf file -- to allow myself to actually use the software I just installed. I will still modify the (unique, but that's this whole other thing) conf file appropriately.


ICJ
PREVIOUS NEXT REPLY QUOTE
 
To: the Happiness Engine, re: pg_hba.conf by Ice Cream Jonsey 11/14/2014, 9:56pm PST NEW
    Re: To: the Happiness Engine, re: pg_hba.conf by Entropy Stew 11/14/2014, 11:09pm PST NEW
        Addendum: you want to have fun? Install Oracle on a Sun box in 2000 by Entropy Stew 11/14/2014, 11:15pm PST NEW
        I would maybe have been nicer, but Stew is always correct in these matters by The Happiness Engine 11/15/2014, 6:33am PST NEW
            Re: I would maybe have been nicer, but Stew is always correct in these matters by Ice Cream Jonsey 11/15/2014, 8:10am PST NEW
            Re: I would maybe have been nicer, but Stew is always correct in these matters by Entropy Stew 11/15/2014, 5:17pm PST NEW
        Re: To: the Happiness Engine, re: pg_hba.conf by Ice Cream Jonsey 11/15/2014, 8:00am PST NEW
            Re: To: the Happiness Engine, re: pg_hba.conf by Entropy Stew 11/15/2014, 3:07pm PST NEW
 
powered by pointy