/explore
|
You are here 
|
www.claudiokuenzler.com | ||
| | | | |
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. | |
| | | | |
dwaves.de
|
|
| | | | | Why keep all your results to yourself? - Blog with howtos and public free software and hardware OpenSource searchable knowledgebase about Linux and OpenSource - with a touch security, politics and philosophy. | |
| | | | |
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. | |
| | | | |
juffalow.com
|
|
| | | I am currently working on three computers and it is real pain to get everything synchronized. Of course I am using git repositories and cloud but I still have to get rid of apache server, databases, etc. So I decided to create Virtual Machine which I save on USB drive and try to do it this way. | ||
