PostgreSQL – www.goldencoder.com

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 →

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