rightvp.blogg.se - Ubuntu install postgresql

#Ubuntu install postgresql update

Selecting previously unselected package pgdg-keyring. Selecting previously unselected package libpq5:amd64. Unpacking libjson-xs-perl (4.020-1build1). Selecting previously unselected package libjson-xs-perl. Unpacking libtypes-serialiser-perl (1.0-1). Selecting previously unselected package libtypes-serialiser-perl. Selecting previously unselected package libjson-perl. Unpacking libcommon-sense-perl (3.75-1build2). 192977 files and directories currently installed.) Selecting previously unselected package libcommon-sense-perl. Get:10 groovy-pgdg/main amd64 postgresql-common all 226.pgdg20.10+1 Get:9 groovy/main amd64 sysstat amd64 12.4.0-1 Get:7 groovy/main amd64 libjson-xs-perl amd64 4.020-1build1 Get:6 groovy/main amd64 libtypes-serialiser-perl all 1.0-1 Get:5 groovy-pgdg/main amd64 postgresql-client-common all 226.pgdg20.10+1 Get:4 groovy-pgdg/main amd64 pgdg-keyring all 2018.2 Get:3 groovy/main amd64 libjson-perl all 4.02000-2 Get:2 groovy/main amd64 libcommon-sense-perl amd64 3.75-1build2 Postgresql-client-common postgresql-common sysstatĠ upgraded, 11 newly installed, 0 to remove and 212 not upgraded.Īfter this operation, 59.4 MB of additional disk space will be used. Libtypes-serialiser-perl pgdg-keyring postgresql-12 postgresql-client-12 The following NEW packages will be installed: Libtypes-serialiser-perl pgdg-keyring postgresql-client-common Libcommon-sense-perl libjson-perl libjson-xs-perl libpq5 The following additional packages will be installed: Sample Output: sudo apt -y install postgresql-12 postgresql-client-12

#Ubuntu install postgresql update

The following package was automatically installed and is no longer required:Ġ upgraded, 0 newly installed, 0 to remove and 212 not 3: Add PostgreSQL 12 repository wget -quiet -O - | sudo apt-key add - echo "deb `lsb_release -cs`-pgdg main" |sudo tee /etc/apt//pgdg.list Step 4: Install PostgreSQL 12 on Ubuntu sudo apt update sudo apt -y install postgresql-12 postgresql-client-12 Wget is already the newest version (1.20.3-1ubuntu1). Vim is already the newest version (2:-3ubuntu2). Sample Output: sudo apt -y install vim bash-completion wgetīash-completion is already the newest version (1:2.11-2ubuntu1). If the package is already installed then you will get the below output, you can ignore it. sudo apt update Step 2: Install the required package sudo apt -y install vim bash-completion wget It is always recommended to update the system before installing PostgreSQL. Pg_dump -U user_name db_name < dbexport.See also: Step 1: Update the Ubuntu system Pg_dump -U user_name db_name > dbexport.pgsql Password: this_should_be_the_postgres_user_passwordĭelete database sudo -u postgres dropdb db_nameĭelete user sudo -u postgres dropuser user_name Login to psql prompt via this user sudo -u user_name psql db_name_goes_here Sudo -u postgres psql -d db_name_goes_here

You would rarely login with postgres user.

Lets you perform adminstrative commands on this database.

You can omit -owner=user_name parameter if db_name is same as user_name. This is called Ident authentication in postgres. If you dont have the user_name as a linux user in your machine then you need to add, otherwise you will get unable to initialize policy plugin error on terminal.

Create a new database sudo -u postgres createdb -owner=user_name db_name_goes_here Sudo -u postgres createuser -interactive -pwpromptĪnswer the questions asked. So lets create a new user with the help of this super user. This user is to perform administration only.By default postgres comes with a special user named postgres but we will not be using this for our web apps.Notice: we are accessing psql using a special user.Start/stop postgresql service sudo service postgresql start Add PPA Source sudo sh -c 'echo "deb $(lsb_release -cs)-pgdg main" > /etc/apt//pgdg.list' ⚠️ I would rather recommand to install PostgreSQL inside docker.