Step 3: Configuring a Read Only user/role for PostgreSQLĬreating a read only user/role on PostgreSQL for a particular databaseĬREATE ROLE WITH LOGIN PASSWORD ‘’ NOSUPERUSER INHERIT NOCREATEDB NOREPLICATION NOCREATEROLE VALID UNTIL ‘infinity’ Sudo sh -c ‘echo "deb $(lsb_release -cs)-pgdg main" > /etc/apt//pgdg.list’
Installing PostgreSQL on our Ubuntu 14.04 machine Sudo apt-get install postgresql postgresql-contrib phppgadmin php5-fpmīy default, the installation process configures the Apache2 server. Install PhpPgAdmin using the below commands: Now let’s go step by step with PostgreSQL + phpPgAdmin running with Nginx on an Ubuntu 14.04 server. With PhpPgAdmin, we can administer a remote PostgreSQL Server. PhpPgAdmin is an administration interface for PostgreSQL written in PHP. We can use phpPgAdmin which is a is a web-based administration tool for PostgreSQL. What happens if we want to manage the PostgreSQL databases from a graphical interface and not the command line? Atomicity, Consistency, Isolation, Durability (ACID). The version 8.0 and above also comes with the native Windows compatibility.Ĭompared to other RDBMSs, PostgreSQL differs itself with its object-oriented and/or relational database functionality, such as the complete support for reliable transactions, i.e. PostgreSQL is a powerful, open source object-relational database system (ORDBMS).
0 kommentar(er)
