In today’s article, we will connect to postgresql and use the Postgres user and the psql command while doing this.<\/p>\n
We need to switch to the Postgresql user, we need to be connected with root for this,<\/p>\n
we switch to the postgres user by saying su postgres.<\/p>\n
su postgres\r\n<\/pre>\nAfter switching to the Postgres user, it’s time to connect to postgresql and we can connect directly to postgresql by typing psql.<\/p>\n
psql\r\n<\/pre>\nWe are connected, now let’s create a database as an example<\/p>\n
Create database faruk;\r\n<\/pre>\nLet’s see, shall we?<\/p>\n
We can see the databases with the \\l command.<\/p>\n
Or we can see it with the help of the following command.<\/p>\n
select*from pg_database; \r\n<\/pre>\nYes, as you can see, our database has been created.<\/p>\n
And now let’s delete this database.<\/p>\n
Drop database;\r\n<\/pre>\nIf you want to exit psql after doing these operations, you can use ctrl+D or you can exit by typing \\q.<\/p>\n
Yes, we connected to psql easily.<\/p>\n
But if we had more than one cluster or if we wanted to connect to a remote postgresql, what would we do?<\/p>\n
Yes, then we would have to use the parameters of psql.<\/p>\n
For example, we wanted to connect to postgresql, which serves on a different port, just use the command below.<\/p>\n
Psql -p 5434 \r\n<\/pre>\nWhen we want to connect to a different server, we will need to enter more parameters this time.<\/p>\n
Psql -h ip ya da sunucu ad\u0131\u00a0 -p port numaras\u0131 -U postgresql kullan\u0131c\u0131 ad\u0131\u00a0\u00a0 ve -W \u015fifre<\/p>\n
psql -h 192.168.1.24 -p 5434 -U faruk -W P@sSWord!1\r\n<\/pre>\nIn the example above, we connected to the postgresql server serving on the 5434 port running on the 192.168.1.24 ip, with the user faruk and the password P@sSWord!1.<\/p>\n
<\/div>\n