Need help with set up of Postgresql DBMS on server and client
by gitpicker from LinuxQuestions.org on (#5GWTG)
I need some advice. I have worked with DBMS' before using a Windows-based app from Alpha software and also worked with MariaDB.
I am currently learning Postgresql and have created both a Linux server using AlmaLinux83 (a new RHEL fork that can be used to replace CentOS) and a client using Fedora 33 Workstation.
I would like to use a GUI, PgAdmin for development.
Is it most appropriate to create the Postgresql database (not a production project, but for learning) on the server where the database files will be located, then install PgAdmin on the client (Fedora) and use that to create the database? Or, would it be more appropriate to install PgAdmin on the server to create the database and do the development right from there? then maybe later use the Fedora client as a web server to access the database files on the Postgresql server?
Obviously, I am a newbie, so I hope this makes sense. Just need a push in the right direction following established development procedures.
I am currently learning Postgresql and have created both a Linux server using AlmaLinux83 (a new RHEL fork that can be used to replace CentOS) and a client using Fedora 33 Workstation.
I would like to use a GUI, PgAdmin for development.
Is it most appropriate to create the Postgresql database (not a production project, but for learning) on the server where the database files will be located, then install PgAdmin on the client (Fedora) and use that to create the database? Or, would it be more appropriate to install PgAdmin on the server to create the database and do the development right from there? then maybe later use the Fedora client as a web server to access the database files on the Postgresql server?
Obviously, I am a newbie, so I hope this makes sense. Just need a push in the right direction following established development procedures.