Skip to content

Instantly share code, notes, and snippets.

View Samoylenko666's full-sized avatar
💥

Dmitry Samoylenko666

💥
View GitHub Profile
@Samoylenko666
Samoylenko666 / install-composer.yml
Created March 20, 2024 08:36 — forked from onlime/install-composer.yml
Small Ansible playbook to install latest-stable Composer
- hosts: webservers
tasks:
# Install Composer the lightweight way (without using installer)
# https://getcomposer.org/download
- name: Composer | Install Composer latest-stable
get_url:
url: https://getcomposer.org/download/latest-stable/composer.phar
checksum: 'sha256:https://getcomposer.org/download/latest-stable/composer.phar.sha256sum'
dest: /usr/local/bin/composer.phar

Create dump on server with postgres

pg_dump databaseName -U postgres -h localhost -F c -f foo.sql

Use scp to copy file on local machine

scp root@ip-address:/path/foo.sql ~/pathOnLocal/foo.sql

Check container_id

docker ps

copy our dump file

@Samoylenko666
Samoylenko666 / Use pgloader migrate data from mariaDB 10.5.18 to Postgresql 15.4.md
Last active September 7, 2023 09:47
Use pgloader migrate data from mariaDB 10.5.18 to Postgresql 15.4.md

install pgloader

apt-get update && apt-get install pgloader

create database in postgres

su postgres
psql

postgres=# create database mydb;
@Samoylenko666
Samoylenko666 / Enums.php
Created January 25, 2022 11:50 — forked from jhoff/Enums.php
Laravel Model Enumeration Trait
<?php
namespace App\Traits;
use Illuminate\Support\Str;
use App\Exceptions\InvalidEnumException;
trait Enums
{
/**