Re: Pgsql 16 to 14 using builtin logical

2024-10-25 Thread Asad Ali
Hi Durgamahesh, Yes, you can replicate a PostgreSQL 16 database to PostgreSQL 14 using built-in logical replication. PostgreSQL's built-in logical replication allows for replicating data between different versions of PostgreSQL, provided the source version is higher than or equal to the target ver

Pgsql 16 to 14 using builtin logical

2024-10-25 Thread Durgamahesh Manne
Hi Can we replicate 16 to 14 using builtin logical similarly pglogical? Regards Durga Mahesh

Plans for partitioning of inheriting tables

2024-10-25 Thread Thiemo Kellner
Am 25.10.2024 um 17:57 schrieb Adrian Klaver: I do not feel it applies to my case. I tried to create a partitioned table that inherits columns from a base table. The documentation you provided the URL seems to speak of realising partitioning by using inheritance. This needs a code example

Re: Plans for partitioning of inheriting tables

2024-10-25 Thread Thiemo Kellner
Am 25.10.2024 um 17:57 schrieb Adrian Klaver: I do not feel it applies to my case. I tried to create a partitioned table that inherits columns from a base table. The documentation you provided the URL seems to speak of realising partitioning by using inheritance. This needs a code example

Re: Plans for partitioning of inheriting tables

2024-10-25 Thread Adrian Klaver
On 10/24/24 22:33, Thiemo Kellner wrote: Thanks for taking this up. 24.10.2024 22:44:11 Adrian Klaver : 1) Have you looked at?: https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-USING-INHERITANCE I do not feel it applies to my case. I tried to create a partitio

Re: Unable to completely uninstall PostgreSQL 14.2 + pgAdmin 6.4

2024-10-25 Thread Adrian Klaver
On 10/25/24 04:38, Magnus Nilsson wrote: Hi It is time to update our aging installation of PostgreSQL 14.2 + pgAdmin 6.4 on our Windows 10 machines. We have a centrally administered environment and we use SCCM to manage installations. However, we are unable to install newer versions of Postgre

Re: Need support

2024-10-25 Thread Adrian Klaver
On 10/24/24 20:13, 侯海军Cole wrote: Hello, postgresql. I've encountered some technical situations when using it, and I need to discuss it with other or postgresql officials. But I can't join Libera Chat, what's going on? The message under Libre.Chat and above the login tells you why. Short vers

Re: Compatibility Issues with Npgsql and .NET Framework 3.5 after Upgrading to PostgreSQL 16.3

2024-10-25 Thread Daniel Gustafsson
> On 25 Oct 2024, at 05:45, 馬 騰飛 wrote: > > Dear PostgreSQL Community, > > After upgrading PostgreSQL to version 16.3, our server encountered the error > "Only AuthenticationClearTextPassword and AuthenticationMD5Password supported > for now. Received: 10" when connecting to the database. > >

Re: Need support

2024-10-25 Thread Daniel Gustafsson
> On 25 Oct 2024, at 05:13, 侯海军Cole wrote: > > Hello, postgresql. I've encountered some technical situations when using it, > and I need to discuss it with other or postgresql officials. But I can't join > Libera Chat, what's going on? The postgres project are not affiliated with Libera Chat i

Unable to completely uninstall PostgreSQL 14.2 + pgAdmin 6.4

2024-10-25 Thread Magnus Nilsson
Hi It is time to update our aging installation of PostgreSQL 14.2 + pgAdmin 6.4 on our Windows 10 machines. We have a centrally administered environment and we use SCCM to manage installations. However, we are unable to install newer versions of PostgreSQL + pgAdmin from https://www.postgresql.org/

Need support

2024-10-25 Thread 侯海军Cole
Hello, postgresql. I've encountered some technical situations when using it, and I need to discuss it with other or postgresql officials. But I can't join Libera Chat, what's going on? 固强科技

Compatibility Issues with Npgsql and .NET Framework 3.5 after Upgrading to PostgreSQL 16.3

2024-10-25 Thread 馬 騰飛
Dear PostgreSQL Community, After upgrading PostgreSQL to version 16.3, our server encountered the error "Only AuthenticationClearTextPassword and AuthenticationMD5Password supported for now. Received: 10" when connecting to the database. We are currently using .NET Framework version 3.5. If we

Re: Plans for partitioning of inheriting tables

2024-10-25 Thread Adrian Klaver
On 10/24/24 12:47 PM, thi...@gelassene-pferde.biz wrote: Hi Up to version 17, partitioning of tables inheriting from other tables is not possible. psql:../code_files/data_storage/PostgreSQL/tables/TOPO_FILES.pg_sql:68: ERROR:  no se puede crear una tabla particionada como hija de herencia