This is controlled by applying an access control rule that. Edit the PostgreSQL configuration file, using a text. Install pgAdmin on windows XP machine and try to connect to PostgreSQL. By default, PostgreSQL accepts connections only from the localhost. Configure Postgresql for Remote Access Backup your Conf Files. Restart the PostgreSQL service in Windows 7 (Services-> PosgreSQL 9.2: right click and restart sevice). This way, PostgreSQL will accept connections from all hosts on the network 192.168.1.XXX. Open the file nf (usually located in C:\Program Files\PostgreSQL\9.2\data) and sets the parameterĬheck the network address of WindowsXP virtual machine, and sets parameters in pg_hba.conf file (located in the same directory of nf) so that postgresql can accept connections from virtual machine hosts.įor example, if the machine with Windows XP have 192.168.56.2 IP address, add in the pg_hba.conf file: host all all 192.168.56.1/24 md5 Here is a brief description about how you can set them (note that the following description is purely indicative: To configure a machine safely, you must be familiar with all the parameters and their meanings)įirst of all configure PostgreSQL service to listen on port 5432 on all network interfaces in Windows 7 machine: In order to remotely access a PostgreSQL database, you must set the two main PostgreSQL configuration files:
0 Comments
Leave a Reply. |