Database – www.goldencoder.com

How to resolve ora error ORA-00823?

11 August 2022
Oracle
0 Comments

ORA-00823: Specified value of sga_target greater than sga_max_size This error tells us that there is configuration error: *.sga_target was set to a value that is larger than value of *.sga_max_size…Read more →

When to choose pg_dump, pg_restore or psql to backup and restore Postgresql database?

11 August 2022
PostgreSQL
0 Comments

If you created an SQL-format dump, all you can use is psql. If you created a custom-format (pg_dump -Fc) or directory-format (pg_dump -Fd) dump, you can and must use pg_restore. Custom and directory format…Read more →

MySQL cheat sheet

21 July 2022
MySQL
0 Comments

MySQL cheat sheet The SQL cheat sheet provides you with the most commonly used SQL statements for your reference. Getting started Connect MySQL mysql -u <user> -p mysql [db_name] mysql -h…Read more →

PostgreSQL cheat sheet

21 July 2022
PostgreSQL, PostgreSQL 11, PostgreSQL 12
0 Comments

PostgreSQL cheat sheet The PostgreSQL cheat sheet provides you with the common PostgreSQL commands and statements. Getting started Getting started Switch and connect $ sudo -u postgres psql List all databases postgres=# \l…Read more →

How to install bootstrap 5 and make it work with Ruby 2.7.2 + on Rails 6.1 +

29 November 2021
PostgreSQL 12, Programming, Ruby On Rails, Ubuntu LTS 20.04, VC(Visual Studio Code)
0 Comments

Rails 6 follow webpacker, you don't need to install a gem, do this instead In your Rails home directory, run this command, to install jQuery, popper.js and bootstrap, jQuery and…Read more →

How to solve “Failed to download metadata for repo ‘pgdg94’ “?

27 October 2021
CentOS, Linux, Operating Systems and Application Servers, PostgreSQL, PostgreSQL 11, PostgreSQL 12, VirtualBox
0 Comments

OS: Cent OS 8 Task: check if there is security update then update security only if there is any security update problem to solve: Run 'yum --security check-update' to see…Read more →

Useful PG (PostgreSQL) script

3 July 2020
PostgreSQL, PostgreSQL 11, PostgreSQL 12, Trick Treat Cheat Sheet
0 Comments

Useful MySQL script

Useful Oracle and PL/SQL script

3 July 2020
MS SQL Server, MS SQL Server 2008 R2, MS SQL Server 2012, MS SQL Server 2014, MS SQL Server 2017, MS SQL Server 2019, Trick Treat Cheat Sheet
0 Comments