You don’t have to pass your username to most programs. On most Linux-based operating systems, the username that is used by default by all processes is the one you are logged in as. We see the Postgres user I mentioned, but what is that other user, engineerapart? This is one of the things Postgres does to make your life easier when you first install it. Under the covers, this command executes an SQL query (we’ll learn about those later) that gets all the users in the database. We can now enter a command to see what users are installed: postgres=# \du (You may need to use sudo psql postgres for this command to work, depending on how your system is configured). Start by entering the following on the command line: psql postgres Let’s start by using the psql utility, which is a utility installed with Postgres that lets you carry out administrative functions without needing to know their actual SQL commands. Let’s see what other users it has created. By default, it automatically creates the user postgres. Postgres works pretty hard to make itself usable right out of the box without you having to do anything. Now we’re finally ready to learn how to use it! 3. Your output should look like the following: Let’s check what version is running: postgres -V Execute the following command: pg_ctl -D /usr/local/var/postgres start
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |