PostgreSQL Tutorial

Installing Postgres :
Sudo apt-get update
Sudo install postgresql postgresql-contrib

 How lo login to user postgres :
sudo -i -u postgres

 Running Postgresql using :
psql

 Quit Postgresql using :
\q

 How to create new role :
createuser --interactive

 How to backup database using pg_dump utility :
pg_dump name_of_database > name_of_backup_file

 How to create Odoo User :
sudo adduser --system --home=/opt/odoo --group odoo
sudo su - odoo -s /bin/bash

Comments

Post a Comment

Popular posts from this blog

How to learn data structure effectively

Step 1 : Learn the theory and fundamentals Understand top fundamental topics covered in data structures such as: Algorithms, Arrays, Collections, Complexity Analysis, Graphs, Hashtables, Heaps, Linked Lists, Queues, Recursion, Search, Sort, Stacks, Trees You can checkout these websites to help cover fundamentals: www.geeks4geeks.com  - explains all the high level fundamentals www.beehyve.io/data-structures  — student crowdsourced resources and community for any topic in CS including Data Structures Time complexity resources [BeeHyve]Time Complexity Cheat Sheet https://visualgo.net/en  - has visualizations of a lot of helpful algorithms Here are more schools that have DS classes which you may find helpful: CS 226 Algorithms and Data Structures Brown CS 16 Introduction to Algorithms and Data Structures Stanford CS 166 Data Structures CMU CSE 15-211 Fundamental Data Structures and Algorithms University of Washington at St. Louis CSE 241 Algorithms and Data Struct
Read more

How to resolve some issue while Installing Moodle Ubuntu 16.04 using Xampp

How to resolve moodle fresh installation issue :  mysql_full_unicode_support#File_format and mysql_full_unicode_support#Large_prefix 1. Go to /opt/lampp/etc then edit my.cnf to add below code [client] default-character-set = utf8mb4 [mysqld] innodb_file_format = Barracuda innodb_file_per_table = 1 innodb_large_prefix character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci skip-character-set-client-handshake [mysql] default-character-set = utf8mb4    2. Restart Xampp      
Read more

How to change phpmyadmin URL in Xampp Ubuntu and how to solve 'New Security Concept while accessing Phpmyadmin - Xampp' ?

Image
How to change Xampp phpmyadmin URL ini Ubuntu 1. Open file  httpd-xampp.conf   which is located in directory  /opt/lampp/etc/extra/ with your text editor or type in your terminal: sudo nano /opt/lampp/etc/extra/httpd-xampp.conf 2. Change line Alias with your desired path. In below sample, I change my phpadmin url to: localhost/myanothersql How to solve 'New Security Concept' while accessing Phpmyadmin - Xampp ubuntu: Type in your terminal : sudo nano /opt/lampp/etc/extra/httpd-xampp.conf edit line : Require local to Require all granted
Read more