4/14/2023 0 Comments Postgresql installTherefore, you can only connect to the PostgreSQL server from within the Ubuntu server where PostgreSQL is installed. Example: C:postgresql-10.3-2-windows-圆4.exe Create directory named PostgreSQL in C: drive Create directory named 10 in previously created PostgreSQL directory. ALTER USER postgres PASSWORD 'myPassword' PostgreSQL Remote Connection Configurationīy default, the PostgreSQL server is accessible only on the loopback interface (127.0.0.1) on port 5432 and through the Unix socket. Download PostgreSQL installation file Move downloaded file to C: drive. Replace myPassword with a password of your choice. Now, we have to change the postgres user’s password so that we can allow remote PostgreSQL connection using password authentication.Įxecute the following query to set a password. Let’s check the version of PostgreSQL using the following command. PostgreSQL is available for download as ready-to-use packages or installers for various platforms, as well as a source code archive if you want to build it yourself. When you install PostgreSQL, the psql client also gets installed.Įxecute the following command to connect to the server. You can connect to the PostgreSQL server using the psql client sudo systemctl status postgresql Connect to PostgreSQL
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |