Postgres=# Code language: Shell Session ( shell ) Page "Notes for Windows users" for details. WARNING: Console code page (437) differs from Windows code page (1252)Ĩ-bit characters might not work correctly. Note that you should provide the password that you entered during installing the PostgreSQL. To accept the default, you can press Enter. Second, enter all the necessary information such as the server, database, port, username, and password. The psql command-line program will display. The quick way to verify the installation is through the psql program.įirst, click the psql application to launch it. You can try to connect to the PostgreSQL database server from any client application e.g., psql and pgAdmin. There are several ways to verify the PostgreSQL installation. Click the Finish button to complete the PostgreSQL installation. The installation may take a few minutes to complete. Click the Next button to begin installing PostgreSQL. Now, you’re ready to install PostgreSQL on your computer. Otherwise, you need to click the Back button to change the configuration accordingly. You need to review it and click the Next button if everything is correct. The setup wizard will show the summary information of PostgreSQL. If you leave it as default locale, PostgreSQL will use the operating system locale. Choose the default locale used by the PostgreSQL database. You need to make sure that no other applications are using this port. Step 7. Enter a port number on which the PostgreSQL database server will listen. If you already created a service account with the name postgres, you need to provide the password of that account in the following window.Īfter entering the password, you need to retype it to confirm and click the Next button: PostgreSQL runs as a service in the background under a service account named postgres. Enter the password for the database superuser (postgres) And click the Next button to go to the next step: Select the database directory to store the data or accept the default folder.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |