I M new to postgresql database. I have 2 server 1st server is having postgresql database and 2nd server having my dot net application in visual studio 2017. how should i connect my postgesql to my visual studio as both aare in different server.
i install dotconnect for postgresql in my dot net application through nuget packages. but how to acces the postgres database in visual studio??? I also install pgadmin in my 2nd server to access postgresql. is anybody know???
I guess that you are using Windows in a local network.
You should listen to all addresses OR the IP of your second Server in .../data/postgresql.conf with listen_addresses = '*' (restart of the postgresql-server is required)
Allow connections from your Server in the file .../data/pg_hba.conf
e.g. for IPv4 host all all 172.16.8.109/32 md5
OR all host all all 0.0.0.0/0 md5
(be careful with that)
string connstring = "Server='server1';Port='5432';User Id='myUser';Password='myPW;Database='myDatabase';";
// connect to Database
NpgsqlConnection conn = new NpgsqlConnection(strConnection);
conn.Open();
try
{
// SQL-Command
string strSQL = "SELECT * FROM yourTable";
NpgsqlCommand cmd = new NpgsqlCommand(strSQL, conn);
NpgsqlDataReader dbReader = null;
dbReader = cmd.ExecuteReader();
while (dbReader.Read())
{
Console.WriteLine(dbReader.GetValue(0).ToString());
}
}
finally
{
conn.Close();
}
