How to access postgresql database from another machine?



How to access postgresql database from another machine?..

Answer / Vibhesh Kumar Singh

Answer: To access a PostgreSQL database from another machine, you need to allow connections from remote hosts. You can do this by editing the `pg_hba.conf` file and adding an entry for your IP address or hostname. After making changes, restart the PostgreSQL server for the changes to take effect.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Postgre Interview Questions

What is the option used in PostgreSQL to increase the number of shared memory buffers shared among the backend processes

1 Answers  


How do I change primary key in pgadmin?

1 Answers  


Is foreign key should be unique?

1 Answers  


Is postgresql like oracle?

1 Answers  


What is stored procedure in postgresql?

1 Answers  


Is edb postgres free?

1 Answers  


How do you add a column?

1 Answers  


What is the option that can be used in PostgreSQL to find out how the query optimizer is evaluating the query given?

1 Answers  


What is the difference between sql and psql?

1 Answers  


What kind of database is postgres?

1 Answers  


Explain about database administration tools?

1 Answers  


How many indexes per table are allowed in postgresql?

1 Answers  


Categories