Arky
/
base_infrastructure
mirror of https://github.com/archellir/base_infrastructure
1
0
Fork 0
Code Issues Packages Projects Releases Wiki Activity
Infrastructure for base server
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
71 Commits
1 Branch
0 Tags
244 KiB
 
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
Go to file
arcbjorn f586146c6f
fix(memos): reverse proxy config 		2 years ago
caddy fix(memos): reverse proxy config 2 years ago
dozzle revert(Dozzle): add ports 2 years ago
filebrowser fix(FileBrowser): expose all data 2 years ago
gitea fix(gitea): db creds 2 years ago
memos feat(memos): add to caddy-network 2 years ago
postgresql ref(all stacks): version 2 years ago
umami fix(Umami): networking 2 years ago
uptime-kuma fix(Uptime-kuma): data volume folder 2 years ago
README.md docs(readme): add pgAdmin instructions 2 years ago

README.md

base_infrastructure

Infrastructure for base server

For postgreSQL multiple databases scripts:

chmod +x scripts/create-multiple-postgresql-databases.sh

For pgAdmin:

sudo chown -R 5050:5050 <host_directory>

Database backup & restore:

Backup:

docker exec -t <postgres-container-id> pg_dumpall -c -U <user> > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

Restore:

cat <dump_name>.sql | docker exec -i <postgres-container-id> psql -U <user>

Example of connection:

# host = container_name
postgres://username:password@container_name:port/db_name