Stéfano Araujo beingsane

How to dump and import PostgreSQL database

Below some step by step with bash functions example on how to dump your database and restore it to your db server.

✅ Dump the source database to a file.

function pgDumpDB() {
    echo 'Type db user: ' && read DBUSER;
    echo 'Type db name: ' && read DBNAME;
 pg_dump -U $DBNAME -O $DBNAME $DBNAME.sql

Filter	Description	Example
allintext	Searches for occurrences of all the keywords given.	`allintext:"keyword"`
intext	Searches for the occurrences of keywords all at once or one at a time.	`intext:"keyword"`
inurl	Searches for a URL matching one of the keywords.	`inurl:"keyword"`
allinurl	Searches for a URL matching all the keywords in the query.	`allinurl:"keyword"`
intitle	Searches for occurrences of keywords in title all or one.	`intitle:"keyword"`

	#!/bin/bash

	if [ $# -lt 1 ]
	then
	echo "Uso : $0 Stack a ser usado (zabbix/webdev)"
	exit
	fi

	case "$1" in



	use GuzzleHttp\Client;
	class yourController extends Controller {

	public function saveApiData()
	{
	$client = new Client();
	$res = $client->request('POST', 'https://url_to_the_api', [
	'form_params' => [

	#!/bin/sh

	for f in *.mp4;
	do
	HandBrakeCLI -i "$f" -o "${f}.m4v" --preset="480p";
	done

	// This configuration file allows you to pass permanent command line arguments to VS Code.
	// Only a subset of arguments is currently supported to reduce the likelyhood of breaking
	// the installation.
	//
	// PLEASE DO NOT CHANGE WITHOUT UNDERSTANDING THE IMPACT
	//
	// NOTE: Changing this file requires a restart of VS Code.
	{
	// Use software rendering instead of hardware accelerated rendering.
	// This can help in cases where you see rendering issues in VS Code.

	curl -i -X POST -H 'Content-type:application/json' -d '{"jsonrpc":"2.0","method":"user.login","params":{ "user":"myUserName","password":"myPassword"},"auth":null,"id":0}' https://zabbix.server/api_jsonrpc.php

	curl -i -X POST -H 'Content-type:application/json' -d '{"jsonrpc":"2.0","method":"host.get","params":{"output": ["hostid", "name"]},"auth":"<AUTH_KEY>","id":0}' https://zabbix.server/api_jsonrpc.php

	#!/bin/bash
	pdftk *.pdf cat output combined.pdf