Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

sql scripts that I use in my personal projects

Notifications You must be signed in to change notification settings

michellima28/sql

Open more actions menu

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
6 Commits
 
 
 
 

Repository files navigation

SQL

SQL scripts that I use in my personal projects.


Prerequisites

You must have installed a database in your machine.


Installing PostgreSQL

Update your system

sudo apt update
sudo apt -y upgrade

Install PostgreSQL database server

sudo apt install postgresql postgresql-client

Check if server is running

The service is automatically started upon installation, you can confirm if it is running with the command:

systemctl status postgresql.service

Update PostgreSQL admin user's password

sudo su - postgres
psql -c "alter user postgres with password 'your_password'"

Try creating a test database and user

createuser dbuser
createdb testdb -O dbuser
psql testdb
alter user dbuser with password 'StrongPassword';
\q

List created databases

psql -l

References

PostgreSQL installation

https://computingforgeeks.com/installing-postgresql-database-server-on-ubuntu/

About

sql scripts that I use in my personal projects

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages

Morty Proxy This is a proxified and sanitized view of the page, visit original site.