Re: How to Build Postgres in a Portable / Relocatable fashion?

2024-05-04 Thread grimy . outshine830
On Fri, May 03, 2024 at 11:27:12PM GMT, AJ ONeal wrote:

> What I want to create (and provide) is a portable tarball that has
> most of all what it needs in the tarball and will look for relevant
> libraries relative to itself. Something that Just Works™ *almost*
> anywhere (Ubuntu, Debian, RedHat, Suse... maybe even Alpine).

Alpine is based on musl (not glibc), so you're pretty much OOL at
least on that point.

Have you thought about using a container?

-- 
Ian




I have ansible for postgres-etcd-patroni

2024-05-04 Thread Iman Bakhtiari
Hi i have written this ansible with https://github/sudoix together
https://github.com/imanbakhtiari/postgres-ansible.git
This ansible needs 5  virtual machine
in 3 of them it install postgresql with patroni replication
and in two of them it install haproxy and keepalived
finally it became so stable idea for database with a SQL and also etcd NOSQL

with this single command
ansible-playbook -i inventory/db-servers.ini postgres.yml --become
--become-method=sudo --tags "preinstall,postgres,haproxy" --ask-become-pass

i just want to share this with others and your community
and also i am living in Iran right now and eager to accept job offer for
emigration or any job recommendations
Here is my resume
https://gitea.com/imanbakhtiari/resume
Thank you


Re: I have ansible for postgres-etcd-patroni

2024-05-04 Thread Vijaykumar Jain
Hi Iman.

Thank you for sharing.


On Sun, May 5, 2024, 1:42 AM Iman Bakhtiari 
wrote:

> Hi i have written this ansible with https://github/sudoix together
> https://github.com/imanbakhtiari/postgres-ansible.git
> This ansible needs 5  virtual machine
> in 3 of them it install postgresql with patroni replication
> and in two of them it install haproxy and keepalived
> finally it became so stable idea for database with a SQL and also etcd
> NOSQL
>
> with this single command
> ansible-playbook -i inventory/db-servers.ini postgres.yml --become
> --become-method=sudo --tags "preinstall,postgres,haproxy" --ask-become-pass
>
> i just want to share this with others and your community
> and also i am living in Iran right now and eager to accept job offer for
> emigration or any job recommendations
> Here is my resume
> https://gitea.com/imanbakhtiari/resume
> Thank you
>