AppendixĪpparently in the past it was required to edit this file:Ĭ:\Program Files\PostgreSQL\9.1\data\nf listen_addresses = '*'īut I found that it already included this line to listen for anyone. 0 means you want to ignore the whole thing, i.e. The /0 is a mask for which bits (literally the bits) of the IP address to validate against. That leaves more time for thinking about how to use PostgreSQL. will work to allow connections from all IP address (based on subsequent password authentication). Hopefully this will save someone else the time of figuring out the steps in Windows. The same things can be done from the pgAdmin III utility if you’re inclined towards GUIs instead of the command line. Yes, you could run PostgreSQL on some other port… but why would you do that? Add a rule in the Windows Firewall to allow incoming connections on port 5432. In my case it was called “postgresql-圆4-9.1″.ģ. Open PostgreSQL up to the worldĬ:\Program Files\PostgreSQL\9.1\data\pg_hba.confĪdd this line to the end to that PostgreSQL will allow connections from absolutely any address with password authentication: host all all 0.0.0.0/0 md5Ģ. I wanted the exact instructions for Windows.Ĭonverting the instructions for PostgreSQL 8 on Linux to PostgreSQL 9 on Windows isn’t so hard… but I wanted to document it clearly once for myself and for anyone else facing a similar requirement. Edit the PostgreSQL configuration file, using a text editor such as vi. They assume Linux or Mac OS as the platform. I want anyone to be able to connect to postgres using a valid username, password, and IP address.īut these are not exactly what I wanted. I have no concerns whatsoever about security. In Ubuntu, the nf file is in the same directory as the. But this is a development server inside a corporate firewall. conf file is used to specify hosts that are allowed to connect to the PostgreSQL server. I want my PostgreSQL instance to accept remote connections.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |