Remote access to PostgreSQL Server - Hallo sahabat Dev-Create, Pada Artikel yang anda baca kali ini dengan judul Remote access to PostgreSQL Server, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan
Artikel connection,
Artikel postgres,
Artikel remote access, yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.
Judul : Remote access to PostgreSQL Server
link : Remote access to PostgreSQL Server
The resolution is a five step process : -
1. Firstly, check if your firewall allows the port (default is 5432) to establish a connection.
2. By default, PostgreSQL does not allow remote incoming connections. This has been implemented in this way, because of security concerns. You need to enable incoming TCP/IP connection requests from the client. This can be done by adding
#
listen_addresses = '*'
#
in the configuration file postgresql.conf. This configuration is valid for postgresql 8.x.
3. You will have to inform Postgresql who can connect to the server. This has to be done by modifying the configuration file pg_hba.conf
host all all 127.0.0.1/32 trust
host all all 192.168.0.0/16 trust
This would allow any user on the local network to access all the databases on the server in "trust" mode.
4. After you have saved the configuration files you will have to restart the server. Remember, these configuration files are read on server startup.
5. Test your config. Go to the command prompt and run the following command.
>psql -h serverIP -U postgresUser -d postgresdb
And, you should be set for remote access to postgresql server.
Anda sekarang membaca artikel Remote access to PostgreSQL Server dengan alamat link https://dev-create.blogspot.com/2009/03/remote-access-to-postgresql-server.html
Judul : Remote access to PostgreSQL Server
link : Remote access to PostgreSQL Server
Remote access to PostgreSQL Server
Error: "could not connect to Server: Connection refused"The resolution is a five step process : -
1. Firstly, check if your firewall allows the port (default is 5432) to establish a connection.
2. By default, PostgreSQL does not allow remote incoming connections. This has been implemented in this way, because of security concerns. You need to enable incoming TCP/IP connection requests from the client. This can be done by adding
#
listen_addresses = '*'
#
in the configuration file postgresql.conf. This configuration is valid for postgresql 8.x.
3. You will have to inform Postgresql who can connect to the server. This has to be done by modifying the configuration file pg_hba.conf
host all all 127.0.0.1/32 trust
host all all 192.168.0.0/16 trust
This would allow any user on the local network to access all the databases on the server in "trust" mode.
4. After you have saved the configuration files you will have to restart the server. Remember, these configuration files are read on server startup.
5. Test your config. Go to the command prompt and run the following command.
>psql -h serverIP -U postgresUser -d postgresdb
And, you should be set for remote access to postgresql server.
Demikianlah Artikel Remote access to PostgreSQL Server
Sekianlah artikel Remote access to PostgreSQL Server kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.
Anda sekarang membaca artikel Remote access to PostgreSQL Server dengan alamat link https://dev-create.blogspot.com/2009/03/remote-access-to-postgresql-server.html
