![]() ![]() For example, this port may already be taken by another PostgreSQL instance on your computer.Īfter the installation is complete, you can launch the SQL Shell that comes with Postgres. The default port is 5432, and you shouldn’t change it unless you have a good reason to do so. To run the development server (we will explain this in a minute) on your machine or localhost, you need to assign it a port to listen to it. We will get to this later on, but for now, you need a superuser account to start using the RDBMS. Later on, you can create other users and assign them permissions. During installation, you will need to provide a password for the superuser. If you don’t have any good reason, you should leave it as it is and install them all, even if you think you won’t need them for now.īy default, PostgreSQL creates a superuser named postgres (think of it as the admin account of the database server). The “Select Components” dialog allows you to install components selectively. The process is just like any other standard installation, but some stuff is still noteworthy. Package manager to download and install additional tools and driversĪfter downloading the installer, launch it as any other executable.pgAdmin, a graphical tool to manage your databases.The installers include different components, most importantly: ![]() ![]() Instead, they recommend that you use your distro’s package manager, which is much better after all. The installation process is straightforward, so I will try to cover it quickly.įor Windows and Mac, you can download the installer from theĮDB no longer provides packages for GNU/Linux systems. You can go to the official download page, select your operating systems, and you will find all installation options. PostgreSQL supports all major operating systems. ![]() You will be using PostgreSQL as your RDBMS, so here’s what you need to get started. Now it’s time for you to set up the working environment you need to follow along with this series. The fundamentals of relational databases and SQL ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |