Re: psycopg2 mail list subscription issues

Here is the link to reset your password and manage your account: https://www.postgresql.org/account/reset/ On 13/07/2021 14:29, Rich Shepard wrote: I apologize for writing to the list, but my attempts to subscribe to the psycopg2 mail list fail and I've not seen a response to my email message

Re: Does psqlodbc_10_03_0000-x86(32bit) support PostgreSQL 12.6 64bit?

hi, Try with a newer version of odbc driver, something like psqlodbc_12_02_ On 07/07/2021 07:38, 管竚 wrote: Created by: gzhcoder Email address: gzhco...@126.com PostgreSQL version: 12.6 Operating system: windows 10 Description: I have a classic ASP Website on IIS. I

Re: how to troubleshoot: FATAL: canceling authentication due to timeout

hi! What you see in the log files of CentOS ( /var/log ) ? i On 17/03/2021 16:00, Marc wrote: hi all, We are facing a problem with a user login into database. It happens when there is large load and only from time to time. Once we get this error, the user becomes unusable until database is

Re: What's your experience with using Postgres in IoT-contexts?

I use pg in my raspberrypy 3b, for a weather station and works fine, but to be honest, I have a sencond raspi with a pgbouncer and a pendrive of 256GBs as data storage In other, I have a zabbix server with pg monitoring aboutn 100 devices, but with an external hdd. but, at the end of the

Re: Procedure to install and configure pgadmin4 in desktop mode in Red Hat Linux 8 and other Linux distributions

Hi Maria! Add the repo: sudo rpm -i https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/pgadmin4-redhat-repo-1-1.noarch.rpm # Install for desktop mode only. sudo yum install pgadmin4-desktop Final config sudo /usr/pgadmin4/bin/setup-web.sh Here are the instructions:

Re: how to check PEM version

Hi Atul, copy from program is your friend ;P https://www.postgresql.org/docs/current/sql-copy.html On 2020-09-10 05:49, Atul Kumar wrote: Hi, I have installed pem in centos 7, now i want to check the version of PEM using sql query. Please let me know, how should i do that. My postgres

Re: Extensión pldebugger para Postgresql 12 en Centos 7, no encontrada

Hi all! It's possible that pldebugger12 does not exists for centos 7? Thanks a lot, Diego On 2020-09-07 10:16, Lucas Luengas wrote: Centos 6: https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-6-x86_64/pldebugger12-1.1-1.rhel6.1.x86_64.rpm https://download.postgresql.org/pub/repos

Re: Getting away from Oracle APEX, recommendations for PostgreSQL?

perl, is the most common. but you can use C, SQL, python or any other can be activate, check: https://www.postgresql.org/docs/current/xplang.html https://www.postgresql.org/docs/current/xfunc-c.html On 2020-08-22 19:32, Dirk Krautschick wrote: Hi all, if someone wants to get away from

Re: Fwd: changing password pgagent service account

yep, or the password does not meet the windows requirements. On 2020-08-13 14:31, Adrian Klaver wrote: On 8/13/20 10:19 AM, Henry Francisco Garcia Cortez wrote: Good morning I need to help I installed pgagent but I want to change password pgagent service account r5w83.png To me it looks

Re: Track pgsql steps

are you running the psql with -c or -f? add -o to put all in a file and -e to write the last query, and with a tail to the log, you can see where is the problem On 2020-07-30 10:11, Olivier Leprêtre wrote: Hi, thanks for your answers, Application_name is a good tip, 64 chars are enough to

Re: Security Vulnerability on PostgreSQL VMs

Hi! Try with "yum deplist " to check who app use phyton. Diego, On 2020-07-17 12:44, Hilbert, Karin wrote: We have PostgreSQL v9.6 & also PostgreSQL v11.8 installed on various Linux VMs with Red Hat Enterprise Linux Server release 7.8 (Maipo) OS.  We're also running

Re: About compress in pg_dump

Yep, I transfer backups files all the time with -Fc and never the problem was rsync On 2020-07-17 12:07, David G. Johnston wrote: On Fri, Jul 17, 2020 at 7:49 AM Edmundo Robles > wrote: To backup  a database  I do:  nice -n +19  pg_dump -Fc  database |

pg_hba & ldap

e next one to continue authenticating? It's a pg11 and ldap is an ipa server thanks a lot, Diego

Research survey

ublish the results and try to use them to benefit the OSS communities. Kindly also distribute this survey to your friends or colleagues which are members from open source communities (regardless of the project). Thanks in advance! Kind Regards, DIego Ruiz

PostgreSQL System Views or Dictionary Tables

of this is to familiarized with the structure of Postgresql databases. _My test environment:_ Windows physical server machine intel x86-64 architecture with PostgreSQL Database version 10.5 and pgAdmin 4 version 3.2 . Thanks so much for your help. Regards, Diego.