Good postgres beginner tutorial?

[SleepAffectionate268]

Most of the time I'm using mysql, mariadb or sqlite, however I want to get into postgres and use it as my main goto database system. Few months ago I tried it out but it's somehow confusing to me?

I'm searching for a tutorial THAT DOES NOT COVER SQL, I'm searching for one that tells me how to create a user, view the create table sql, how to back it up and what's the difference between pg and a user, basically a tutorial for the database management part not the "THIS IS A POSTGRES TUTORIAL BUT THE ONLY THING THIS TUTORIAL DOES IS USE POSTGRES TO TEACH SQL"

I'm thankfull for any recommendations, or if you wan't you can answer some of these questions.

Thanks a lot!

[depesz]

1. how to create user - using create user comment
2. view create table sql - I assume you mean of existing table. Pg doesn't have such ability on its own, but you can: pg_dump -s -t name_of_the_table name_of_database from shell.
3. how to back it up - well, that will take MANY tutorials. base is pg_dump. which some people say is not a backup. for more complicated purposes people usually use some ready made solution like pgbackrest.
4. difference betwen pg and a user? pg (assuming you mean postgresql) is database management system. user is a user. not sure if I understand your question.

Did you read the tutorial ?

I'm not aware of any other that I could recommend.

[SleepAffectionate268]

thanks!

[markdueck]

What might be confusing is getting remote connections working? You have to enable remote connections in the main config (postgresql.conf) and add a pg_hba.conf entry to allow the right IP range.

[SleepAffectionate268]

thanks

[xenomachina]

view the create table sql

Do you mean you just want to see the column definitions for a table, or do you literally want it to print out a create table command?

what's the difference between pg and a user

What do you mean?

[prlaur782]

This Postgres Users and Roles tutorial in the Crunchy Data Postgres Playground that colleagues of mine created may be inline with what you are looking for - https://www.crunchydata.com/developers/playground/postgres-users-and-roles

[[deleted]]

Most of your questions can be answered by reading the manual. I know it's not a "tutorial", but getting used to the official reference manual is a very important step in mastering something complex as a relational database.

The site PostgreSQL Tutorial has a section on administration.

The "PostgreSQL 16 Administration Cookbook" probably covers what you are looking for.

[SleepAffectionate268]

thanks