Skip to main content

Posts

Showing posts from 2018

How to Upgrade PostgreSQL from 9.6 to 10.0 on Ubuntu 16

A Step-by-Step Guide to upgrade postgresql from 9-6 to 10 on ubuntu 16 1.Make a backup. Make sure that your database is not being updated.   pg_dumpall > outputfile  2. Install Postgres 10.             a) Create the file /etc/apt/sources.list.d/pgdg.list and add a line for the repository                     deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main                       b) Import the repository signing key, and update the package lists                    wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - sudo apt-get update 3. Run sudo apt-get install postgresql-10 . A newer version will be installed side-by-side with the earlier version. 4. Run pg_lsclusters: Ver  Cluster   Port     Status  Owner      Data        directory Log file 9.6   main       5433    online    postgres   /9.6/main   /var/log/postgresql/postgresql-9.6-main.log 10    main       5432    online   postgres   /10/main   /var/log/postgr

How to copy data from one ubuntu machine to another

How can I copy folder from one computer to another in ubuntu? If you want to transfer some files from Ubuntu to Windows or Ubuntu to Ubuntu , you can transfer via smba or sftp using below steps : Steps to share from ubuntu To get started, right-click on the folder you wish to share and select ‘Sharing Options’ When prompted to install Samba services, do it. Then click ‘Create Share’ to complete the process. Access it from Windows On the Windows machine, go to Start –> All Programs –> Accessories –> run and type the command: \\computer_name\share_name computer name can be ip address of ubuntu machine , to check ip of ubuntu machine , go to ubuntu machine & open terminal & type ifconfig Type the Ubuntu computer name and the share name of the resource. You will get a prompted to enter your credentials. Type your Ubuntu username and password and click ‘OK’ Access it from ubuntu on same network sftp://192.168.x.x Username = Ubuntu Machine Username from whe