Make sure there is at least one file in it (even just the README.md)
ssh-keygen -t rsa -C "[email protected]"
cd /var/lib/postgresql/13/main | |
# Create a self-signed certificate | |
openssl req -new -nodes -text -out server.csr \ | |
-keyout server.key -subj "/CN=postgresql.otaviomiranda.com.br" | |
openssl x509 -req -in server.csr -text -days 3650 \ | |
-extfile /etc/ssl/openssl.cnf -extensions v3_ca \ | |
-signkey server.key -out server.crt |
#!/bin/bash | |
# Executar comandos a seguir para atualizar os pacotes | |
sudo apt update -y | |
sudo apt upgrade -y | |
# Só o Python | |
sudo apt install python3.10-full python3.10-dev -y | |
# Instalar pacotes a seguir |
sudo apt update -y | |
sudo apt upgrade -y | |
sudo apt install git curl build-essential -y | |
sudo apt install gcc make default-libmysqlclient-dev libssl-dev -y | |
sudo apt install python3.10-full python3.10-dev -y |
#!/bin/bash | |
# Executar comandos a seguir para atualizar os pacotes | |
sudo apt update -y | |
sudo apt upgrade -y | |
# Só o Python | |
sudo apt install python3.10-full python3.10-dev -y | |
# Instalar pacotes a seguir |
sudo apt update | |
sudo apt install build-essential zlib1g-dev libncurses5-dev libgdbm-dev libnss3-dev libssl-dev libreadline-dev libffi-dev libsqlite3-dev wget libbz2-dev | |
sudo apt-get install build-essential checkinstall | |
sudo apt autoremove | |
sudo apt-get install libreadline-gplv2-dev libncursesw5-dev libssl-dev libsqlite3-dev tk-dev libgdbm-dev libc6-dev libbz2-dev libffi-dev zlib1g-dev | |
cd /opt | |
sudo wget https://www.python.org/ftp/python/3.8.6/Python-3.8.6.tgz | |
sudo tar xzf Python-3.8.6.tgz | |
ls -la | |
sudo rm -f Python-3.8.6.tgz |
#include <iostream> | |
#include <chrono> | |
#include <pqxx/pqxx> | |
int main(int, char *argv[]) | |
{ | |
pqxx::connection c("dbname=arete user=postgres password=postgres"); | |
{ | |
pqxx::work txn(c); |
Make sure there is at least one file in it (even just the README.md)
ssh-keygen -t rsa -C "[email protected]"