/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

www.claudiokuenzler.com
| | thecodinginterface.com

This is the third article of a series featuring a collection of useful tasks for administering PostgreSQL on the Linux operating systems Ubuntu 18 LTS as well as CentOS 7. For those unfamiliar, PostgreSQL is a powerful and robust Object Relational Database which is freely available as open source software and widely popular. In this article I cover how to create user accounts and establish connections with these accounts.
2.5 parsecs

Travel
| |
| | njmulsqb.github.io

This is the list of open source software I use. I admire FOSS and prefer using it over any proprietary solution
2.5 parsecs

Travel
| |
| | jinyuz.dev

So, I was trying to reproduce some issues and bugs that only happened in production. I needed an exact copy of the production database and run it locally. Here's how I did it using pg_dump and pg_restore. $ pg_dump -U postgres -Fc -Z 9 -j 8 production.dump -d postgres Here's the breakdown for the arguments: U means username. It's used to connect to your postgres database. In this case, my username is postgres.
1.9 parsecs

Travel
| |
| | amanhimself.dev

[AI summary] This article explains how to use import statements in Node.js by setting up a project with Babel to enable ES6 modules, avoiding syntax errors.
23.1 parsecs

Travel
|