Re: \dt shows table but \d says the table doesn't exist ?
On Fri, May 03, 2024 at 04:58:26PM -0400, David Gauthier wrote: > Soo... what am I missing ? > owner is "cron_user". \dt shows cron_user is the owner of the table. Magnus already helped you, but you might want to check this: https://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_upper_case_table_or_column_names and generally read the whole "Don't Do This" wiki page. Best regards, depesz
Re: I have ansible for postgres-etcd-patroni
Hi Iman It's a great help, thanks for sharing. Regards Kashif Zeeshan On Sun, May 5, 2024 at 1:12 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 >
