PostgreSQL basic commnad

How to connect AWS-RDS of PostgreSQL using terminal or CMD & basic of PostgreSQL

- syntax format

psql -h HOSTNAME --port=5432 -U USERNAME DATABASENAME -W

-h = host or RDS Endpoint

-p 5432 pre define port for postgresql

-u user name for database access
-w password of user ( not heat with single command it will ask after hit this syntax  & password are not visible )

- for login in main user
sudo -u postgres psql

- for create database
CREATE DATABASE dbname;

- for create user with password
create user USERNAME with password 'PASSWORD';

- give access of db with user
GRANT ALL PRIVILEGES ON DATABASE databasename to dbusername;

- for delete full database

DROP DATABASE [IF EXISTS] database_name;

Connect GCP PostgreSQL with local machine Linux

Required data for connection :
-> connection string
-> user name
-> user password
-> check the status of SSL for connection
-> public IP address

Required installation steps in machine
 
$ sudo apt-get update -y
$ sudo apt-get install postgresql-client

$ gcloud auth login
- need login for access data using email-password

$psql "sslmode=disable dbname=DB_NAME user=USER hostaddr=xx.xx.xx.xx"
- for connection local to db.

Note :
- must check the status of connection -> Public IP.
- status of security [ SSL ]
- database & user name is existing in server panel.

     

• Related Articles

• AWS Services

  AWS also provides many other functionalities other than server like domain hosting, Email sending, Monitoring, Alerting, AI  For a website, we can use the following basic AWS services 1. EC2- Elastic Compute Cloud It consists of Compute and ...

• HOW TO LOGIN OPENXCELL AWS ACCOUNT

  Login steps for openxcell AWS. Step 1 : Raise ticket for AWS Access. ( mail address  : devops@openxcell.info ) [ Ticket will required only for new access ] Hit this URL Step 2 : https://openxcelldev.awsapps.com/start#/ Step 3 : Enter login I'd / ...

• AWS Free Tier

  Some Common Frequently asked questions! 1. What is the capacity of free tier? How many users it can hold. - that entirely upon your application. We can test load balancing on that server after your application gets developed. Before that, it's ...

• Basic Command For LAMP

  Find largest files find / -size +10M -ls                   Server size (use/available) df -h Basic Command https://www.fastwebhost.in/blog/putty-30-useful-putty-commands-for-beginners/ Basic Git Command ...

• AWS Services Pricing

  AWS EC2 Pricing.  Instance Type vCPUs RAM Per/Hour Per/Month  t2.nano 1 0.5 $0.0058 $4.23 t2.micro 1 1 $0.0116 $8.47 t2.small 1 2 $0.0232 $16.04 t2.medium 2 4 $0.0464 $33.87 t2.large 2 8 $0.0928 $67.74 t2.xlarge 4 16 $0.1856 $135.49 t2.2xlarge 8 32 ...