Re: synchronous streaming replication

2022-10-23 Thread Laurenz Albe
On Sat, 2022-10-22 at 17:28 +0200, Joseph Kennedy wrote: > Hi,I have a question. Its stays at the intersection of software engineering > and PostgreSQL. > > I have configured streaming synchronous replication and whit setting > "synchronous_commit=remote_apply" > to make sure that the slave will

Re: Upgrading error

2022-10-23 Thread Tom Lane
chris navarroza writes: > could not connect to source postmaster started with the command: > "/usr/pgsql-12/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D > "/home/dmartuser/pgdata/data" -o "-p 50432 -b -c > config_file=/var/lib/pgsql/12/data/postgresql.conf -c listen_addresses='' > -c unix_socket_p

Re: How to find an oid that's not uesd now?

2022-10-23 Thread Tom Lane
"jack...@gmail.com" writes: > I'm adding a new index in pg, but I find this. > Duplicate OIDs detected: > Duplicate OIDs detected: > 357 > 357 > found 1 duplicate OID(s) in catalog data > found 1 duplicate OID(s) in catalog data > what sql should I run to find one? https://www.postgresql.org/doc

Re: Asking for existence of a GUI frame work similar to Oracle APEX for PostgreSQL

2022-10-23 Thread Robert Treat
On Fri, Oct 21, 2022 at 1:49 PM Dionisis Kontominas wrote: > It depends on whether you keep the GUI in Oracle APEX. If so then yes, as > APEX and tomcat and ORDS are free and need only the basic license for the > Oracle DB. Otherwise if a free/low cost low code tool/framework is found then > th

Re: How to find an oid that's not uesd now?

2022-10-23 Thread Adrian Klaver
On 10/23/22 09:00, jack...@gmail.com wrote: I'm adding a new index in pg, but I find this. Duplicate OIDs detected: Duplicate OIDs detected: 357 357 found 1 duplicate OID(s) in catalog data found 1 duplicate OID(s) in catalog data what sql should I run to find one? More information need

How to find an oid that's not uesd now?

2022-10-23 Thread jack...@gmail.com
I'm adding a new index in pg, but I find this. Duplicate OIDs detected: Duplicate OIDs detected: 357 357 found 1 duplicate OID(s) in catalog data found 1 duplicate OID(s) in catalog data what sql should I run to find one?

Re: could not find shared library for Python

2022-10-23 Thread jacktby
ok, I'm sorry for that