Re: Accessing Postgres Server and database from other Machine

Hi Adrian, > On 05. Dec, 2020, at 15:58, Adrian Klaver wrote: > > Given that the OP changed pg_hba.conf.sample, probably not:). sorry, I overlook the *.sample part. :D Cheers, Paul

Re: Accessing Postgres Server and database from other Machine

On 12/5/20 1:05 AM, Paul Förster wrote: Hi Hemil, On 05. Dec, 2020, at 07:50, Hemil Ruparel wrote: Did you restart postgres after changing pg_hba.conf? that shouldn't be necessary for changes in pg_hba.conf. Just do either on the command line: $ pg_ctl reload or from psql: postgres=# se

Re: Accessing Postgres Server and database from other Machine

On 12/4/20 10:26 PM, Muthukumar.GK wrote: Hi Nicklas,   I have added a line "host  all  all 0.0.0.0/0 md5" in Pg_hba_conf.sample file and restarted postgres server. Again, changing lines in the *.sample file will not be of any use. The actual pg_hba.conf file is in the s

Re: Accessing Postgres Server and database from other Machine

> On 5 Dec 2020, at 10:05, Paul Förster wrote: > > Hi Hemil, > >> On 05. Dec, 2020, at 07:50, Hemil Ruparel wrote: >> >> Did you restart postgres after changing pg_hba.conf? > > that shouldn't be necessary for changes in pg_hba.conf. Just do either on the > command line: > > $ pg_ctl relo

Re: Accessing Postgres Server and database from other Machine

Hi Hemil, > On 05. Dec, 2020, at 07:50, Hemil Ruparel wrote: > > Did you restart postgres after changing pg_hba.conf? that shouldn't be necessary for changes in pg_hba.conf. Just do either on the command line: $ pg_ctl reload or from psql: postgres=# select pg_reload_conf(); You can then s

Re: Accessing Postgres Server and database from other Machine

Yes. I restarted (Run->Services.msc->Postgresql13->Restart) after config file. I can able to connect my postgres server using .net application with help of below connection string. NpgsqlConnectionconn =newNpgsqlConnection("Server=127.0.0.1;User Id=postgres; "+ "Password=Postgresql@1;

Re: Accessing Postgres Server and database from other Machine

Did you restart postgres after changing pg_hba.conf? On Sat, Dec 5, 2020 at 11:56 AM Muthukumar.GK wrote: > Hi Nicklas, > > I have added a line "host all all 0.0.0.0/0 md5" in > Pg_hba_conf.sample file and restarted postgres server. porstgres port has > been added in windows firewall (Windo

Re: Accessing Postgres Server and database from other Machine

Hi Nicklas, I have added a line "host all all 0.0.0.0/0 md5" in Pg_hba_conf.sample file and restarted postgres server. porstgres port has been added in windows firewall (Windows10)as well. But my colleague is still facing the below error when connecting my postgres server from .net appplicat

Re: Accessing Postgres Server and database from other Machine

lol. Been there. Done that On Sat, Dec 5, 2020 at 1:36 AM Nicklas Avén wrote: > > > On 4 December 2020 17:17:48 CET, Adrian Klaver > wrote: > >On 12/4/20 8:03 AM, Paul Förster wrote: > >> Hi Adrian, > >> > >>> On 04. Dec, 2020, at 16:13, Adrian Klaver > > wrote: > >>> That is the wrong file, th

Re: Accessing Postgres Server and database from other Machine

On 4 December 2020 17:17:48 CET, Adrian Klaver wrote: >On 12/4/20 8:03 AM, Paul Förster wrote: >> Hi Adrian, >> >>> On 04. Dec, 2020, at 16:13, Adrian Klaver > wrote: >>> That is the wrong file, the *.sample is the giveaway. >> >> hmmm, I'd rather call it essential reference documentation or

Re: Accessing Postgres Server and database from other Machine

On 12/4/20 8:03 AM, Paul Förster wrote: Hi Adrian, On 04. Dec, 2020, at 16:13, Adrian Klaver wrote: That is the wrong file, the *.sample is the giveaway. hmmm, I'd rather call it essential reference documentation or template for automation. It's perfectly well suited to automatically strip

Re: Accessing Postgres Server and database from other Machine

Hi Adrian, > On 04. Dec, 2020, at 16:13, Adrian Klaver wrote: > That is the wrong file, the *.sample is the giveaway. hmmm, I'd rather call it essential reference documentation or template for automation. It's perfectly well suited to automatically strip all comments and then diff the result t

Re: Accessing Postgres Server and database from other Machine

On 12/4/20 2:27 AM, Muthukumar.GK wrote: Hi Team, I have created Database in postgresqlv13 . My Office colleague needs to access my postgres server and database from his machine. There is a config file called 'Postgresql.conf.sample' in program files folder. That is the wrong file, the *.sam

Re: Accessing Postgres Server and database from other Machine

On 04/12/2020 12:56, Hemil Ruparel wrote: I dont think you can use pgAdmin to do that kind of thing but I may be wrong. Google how to restart a service in Windows and then restart postgres On Fri, Dec 4, 2020 at 5:36 PM Muthukumar.GK mailto:muthanku...@gmail.com>> wrote: No.I did not restart pos

Re: Accessing Postgres Server and database from other Machine

I dont think you can use pgAdmin to do that kind of thing but I may be wrong. Google how to restart a service in Windows and then restart postgres On Fri, Dec 4, 2020 at 5:36 PM Muthukumar.GK wrote: > No.I did not restart postgres.Please let me know the steps to restart > postgres using pgadmin4

Re: Accessing Postgres Server and database from other Machine

No.I did not restart postgres.Please let me know the steps to restart postgres using pgadmin4 tool. On Fri, Dec 4, 2020 at 5:26 PM Hemil Ruparel wrote: > Are you sure you restarted postgres after the change in configuration? > > On Fri, Dec 4, 2020 at 3:58 PM Muthukumar.GK > wrote: > >> Hi Team

Re: Accessing Postgres Server and database from other Machine

Are you sure you restarted postgres after the change in configuration? On Fri, Dec 4, 2020 at 3:58 PM Muthukumar.GK wrote: > Hi Team, > > I have created Database in postgresqlv13 . My Office colleague needs to > access my postgres server and database from his machine. There is a config > file ca

Accessing Postgres Server and database from other Machine

Hi Team, I have created Database in postgresqlv13 . My Office colleague needs to access my postgres server and database from his machine. There is a config file called 'Postgresql.conf.sample' in program files folder. Even if I changed the connection settings of listen address from localhost to *(