One issue with the packages is the hard coded PGDATA, which will be overwritten in the Servicefile with each update of PostgreSQL.
Run the below command from the postgres shell to check the details of the connection.In this blog I will show how to handle a PostgreSQL installation with a customized PGDATA using the packages provided by the PostgreSQL community. Run the below command to access PostgreSQL and launch the postgres shell program. Once the installation is completed, then run the below commands to start, enable and check the status of PostgreSQL. # apt-get install postgresql postgresql-contrib Once added the PostgreSQL repository and updated the server, then run the below command to install the PostgreSQL on your server. Now update the server to effect the changes. # sh -c 'echo "deb `lsb_release -cs`-pgdg main" > /etc/apt//pgdg.list' # wget -quiet -O - | sudo apt-key add -Īdd the PostgreSQL repository by using the below command.
Import the GPG repository key with the below commands: # apt-get install wget ca-certificates Run the below commands to add PostgreSQL Repository and it will combine with your Linux system and offers automatic updates for all supported versions of PostgreSQL on your Ubuntu server. You can use the below command to change the password for user postgres for security purposes. Run the below command to verify the installation. Once the database initialize completed, then run the below commands to start, enable and check the status of PostgreSQL. Initialize PostgreSQL Database to complete the database installation.
# yum install postgresql-server postgresql Once added to the PostgreSQL yum repository, then run the below command to install the PostgreSQL on your server. Run the below command to add PostgreSQL Yum Repository and it will combine with your Linux system and offers automatic updates for all supported versions of PostgreSQL on your CentOS server. This article will guide you on how to install the PostgreSQL on CentOS, Ubuntu & Debian servers. It is an enterprise-level database system that offers high levels of resistance, integrity and accuracy. PostgreSQL is a highly scalable, powerful free open-source relational database management system that runs on operating systems such as Unix, including Linux and Windows OS.
0 kommentar(er)
