标签

 postgresql 

相关的文章:

Planet PostgreSQL -

Ryan Booz: Review: PostgreSQL at PASS Data Community Summit 2023

PGSQL Phriday #014 is hosted by Pavlo Golub and we're talking about PostgreSQL events!

AI生成摘要 这篇文章主要讲述了作者参加了PASS Data Community Summit,并分享了他对参加会议的经历和收获。作者强调参加会议可以扩展人际关系和社区连接,并提到了一些具体的会议内容和亮点。他还表达了对未来将SQL Server和PostgreSQL社区联系在一起的期望,并鼓励读者参加会议并与他人分享所学。

相关推荐 去reddit讨论

Planet PostgreSQL -

Grant Fritchey: PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014

For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple question: What do you think about PostgreSQL events? Prior to this year, I’d never attended an event focused on PostgreSQL. Heck, I’d never attended an event that had an intentional track or learning pathway, or whatever, focused on PostgreSQL. In the […] The post PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014 appeared first on Grant Fritchey.

AI生成摘要 这篇文章讲述了作者对于PostgreSQL社区的看法。作者认为PostgreSQL社区非常友好和热情,对新人提出的问题给予理解和回答。然而,作者也指出了PostgreSQL社区管理方式较为集中,相对于SQL Server社区来说,缺乏自由和创新。作者希望看到Data Saturday和SQLSaturday组织者与PostgreSQL社区进行交流和合作。总的来说,作者对PostgreSQL社区非常感激,并认为社区的强大和友善是PostgreSQL技术的重要支撑。

相关推荐 去reddit讨论

Percona Database Performance Blog -

Partitioning in PostgreSQL With pg_partman (Serial-Based & Trigger-Based)

The PostgreSQL partition manager pg_partman is an open source extension widely supported and actively maintained by the PostgreSQL community.  pg_partman is an extension that streamlines the creation and management of table partition sets, supporting both time-based and serial-based partitioning approaches. You can use pg_partman to automate and create partitions by breaking large tables into smaller […]

AI生成摘要 pg_partman是一个广受支持和积极维护的开源扩展,用于简化PostgreSQL表分区集的创建和管理。它支持基于时间和序列的分区方法,并可以通过将大表分割为较小的分区来提高性能。本文介绍了使用pg_partman进行序列分区的方法,并提供了相应的示例代码。

相关推荐 去reddit讨论

Planet PostgreSQL -

semab tariq: PostgreSQL with Python – A Developer’s Guide

This guide will delve into the seamless integration of PostgreSQL and Python, covering optimal connection methods and demonstrating how to execute CRUD operations (Create, Read, Update, Delete) efficiently within PostgreSQL using Python. The post PostgreSQL with Python – A Developer’s Guide appeared first on Stormatics.

AI生成摘要 PostgreSQL和Python的结合为开发人员提供了良好的合作伙伴关系。当与Python结合使用时,PostgreSQL作为一个有影响力的开源数据库系统,成为处理数据密集型应用程序的坚实基础。本指南将深入探讨PostgreSQL和Python的无缝集成,涵盖最佳连接方法,并演示如何使用Python在PostgreSQL中高效执行CRUD操作(创建、读取、更新、删除)。

相关推荐 去reddit讨论

Planet PostgreSQL -

Syed Salman Ahmed Bokhari: How To Set Up and Run a PostgreSQL Database Using Docker

Learn how to set up Postgres using Docker: this tutorial will help you install a PostgreSQL database using a Docker container. The post How To Set Up and Run a PostgreSQL Database Using Docker appeared first on Stormatics.

AI生成摘要 PostgreSQL是一种开源的关系型数据库管理系统,可以在Docker容器上运行。使用PostgreSQL在Docker容器上可以带来很多好处,如隔离性、可移植性和资源利用率。安装PostgreSQL需要先安装Docker Desktop,然后拉取PostgreSQL镜像并运行容器。可以使用PSQL连接到PostgreSQL数据库。使用Docker在隔离的容器中运行PostgreSQL是一种高效可靠的方式。

相关推荐 去reddit讨论

Planet PostgreSQL -

Pavlo Golub: PGSQL Phriday #014: PostgreSQL Events

As PostgreSQL enthusiasts, we all know that the community’s heartbeat lies in PostgreSQL Events, whether local meetups, big conferences, or virtual gatherings, that have become prevalent during the COVID-19 pandemic. During a thrilling conference season, the PostgreSQL community is abuzz with activity. We’ve just wrapped up the PASS Data Community Summit, which featured a dedicated PostgreSQL presence that left us inspired and eager for more. The DOAG conference is underway, where numerous PostgreSQL experts are sharing their insights. And on the horizon, we eagerly anticipate the upcoming PostgreSQL Conference Europe in just a couple of weeks. I invite you to share your PostgreSQL Events experiences in your dedicated blog post. Whether you’re a seasoned attendee, a speaker, a trainer, a sponsor, an organizer, or a first-timer, your unique perspective contributes to the canvas of the PostgreSQL community. Reflecting on Personal Experiences and Favorite Moments Share the stories that resonate with you — the moments that left a lasting impression. Do you remember your first in-person event? Were there unexpected highlights or connections that made the event memorable for you? Unpacking PostgreSQL Events Highlights PostgreSQL events offer rich content, from training sessions to lightning talks. What were the standout sessions for you? Which speakers left you inspired or equipped with newfound wisdom? Share the gems you discovered during these sessions. Comparing Virtual and In-Person Experiences As the landscape of events evolves, so does the format. Reflect on your experiences attending both virtual and in-person events. What unique advantages and challenges does each setting present? How has the shift to virtual impacted your engagement with the PostgreSQL community? Networking and Collaborations For many of us, PostgreSQL events are more than just learning opportunities — they are epicenters for networking and collaboration. Discuss the importance of networking. Hav[...]

AI生成摘要 PostgreSQL社区举办了一系列活动,包括会议、培训和演讲,参与者可以分享他们的经历和见解。文章还提到了参加虚拟和现场活动的不同体验,以及活动对个人和专业成长的影响。此外,还鼓励参与者在博客上发布关于PostgreSQL活动的文章,并在社交媒体上宣传。最后,文章提到了对未来PostgreSQL活动和会议的期望。

相关推荐 去reddit讨论

Planet PostgreSQL -

Paolo Melchiorre: Database generated columns⁽²⁾: Django & PostgreSQL

An introduction to database generated columns, using PostgreSQL and the new GeneratedField added in Django 5.0.

AI生成摘要 这篇文章介绍了Django 5.0中的数据库生成列功能,使用PostgreSQL和新添加的GeneratedField。GeneratedField是一个全新的Django 5.0功能,具有以下特点:它的值完全由数据库计算,适用于所有支持的后端数据库。文章提供了一个使用GeneratedField的模型示例,用于与PostgreSQL作为数据库后端的情况。作者还分享了一些使用GeneratedField的常见模型字段的示例,包括计算JSON键字段、计算连接字段、计算搜索向量字段和计算数组长度字段。作者鼓励读者尝试使用Django 5.0的beta版本,并报告任何异常行为或错误,以改进最终的功能。

相关推荐 去reddit讨论

Planet PostgreSQL -

semab tariq: Unlocking Secure Connections: A Guide to PostgreSQL Authentication Methods

Authentication is the process of verifying the identity of a user or system attempting to access a database. In the realm of PostgreSQL, authentication serves as the first line of defense, ensuring that only authorized individuals or applications gain entry. As the gateway to sensitive data, robust authentication is imperative, safeguarding against unauthorized access and […] The post Unlocking Secure Connections: A Guide to PostgreSQL Authentication Methods appeared first on Stormatics.

AI生成摘要 认证是验证用户或系统尝试访问数据库身份的过程。在PostgreSQL领域,认证作为第一道防线,确保只有授权的个人或应用程序能够进入。PostgreSQL支持各种认证方法来保护其数据库的访问。pg_hba.conf文件是一个类似安全卫士的文件,决定谁可以何时访问数据库。它设置了认证规则、IP地址和用户权限,为敏感数据创建了强大的防御。pg_hba.conf文件使用逐行格式,忽略空行和#注释后的文本。记录由用空格或制表符分隔的字段组成,可以跨行扩展并包含引用值。基本语法是指定规则的类型、数据库、用户、地址和认证方法。PostgreSQL还支持其他认证方法,如Trust、Password、MD5、SCRAM-SHA-256、Peer、LDAP、Certificate、pg_ident.conf文件映射和RADIUS。通过理解和使用这些认证选项,可以根据动态环境的需求定制PostgreSQL设置,实现强大的安全性。

相关推荐 去reddit讨论

Devart Blog -

How to Connect to PostgreSQL in Delphi with Devart PgDAC

We will guide you through the steps to connect to PostgreSQL in Delphi using Devart PgDAC. The post How to Connect to PostgreSQL in Delphi with Devart PgDAC appeared first on Devart Blog.

AI生成摘要 PostgreSQL是一种流行的开源关系型数据库管理系统,用于构建强大和可扩展的应用程序。使用Devart PgDAC(PostgreSQL数据访问组件)可以简化在Delphi中连接和交互与PostgreSQL数据库的过程。PgDAC具有直接模式、跨平台支持、可视化查询构建器、高级连接池等功能,并提供全面的数据类型映射、SSL支持、BLOB流式处理、Unicode支持等。PgDAC适用于Delphi和C++ Builder开发人员、企业应用程序开发人员、独立软件供应商和数据库管理员。与其他类似产品相比,PgDAC在性能和功能方面具有优势。

相关推荐 去reddit讨论

Planet PostgreSQL -

Dan Langille: I figured out why pg_dump was failing with PostgreSQL 15-16

In recent blog post, I outlined a problem I hit with pg_dump. Specifically, pg_dump was picking up and using ~/.pgpass with pg_dump from PostgreSQL 12-14, but with PostgreSQL 15-16, it was failing. In this blog post: FreeBSD 13.2 PostgreSQL server 12 / 16 PostgreSQL client 12-16 Bacula 9.6.7 Today we figured out why: $HOME. $HOME for the script was set to / In PostgreSQL < 15, the code used the database to determine HOME and then pick up ~/.pgpass Stumbling through the environment variables In PostgreSQL 16, the code first checks $HOME (as shown in this commit). The order is now: PGPASSFILE $HOME/.pgpass (starting with v15) ~/.pgpass (i.e. the home directory from /etc/passwd) I stumbled across the problem this morning when pg_dump wasn’t running with a 16 client against a 16 server. The output was: 22-Nov 13:36 bacula-dir JobId 361250: Start Backup JobId 361250, Job=BackupCatalog.2023-11-22_13.36.38_39 22-Nov 13:36 bacula-dir JobId 361250: There are no more Jobs associated with Volume "FullAutoNoNextPool-04-17758". Marking it purged. 22-Nov 13:36 bacula-dir JobId 361250: All records pruned from Volume "FullAutoNoNextPool-04-17758"; marking it "Purged" 22-Nov 13:36 bacula-dir JobId 361250: Recycled volume "FullAutoNoNextPool-04-17758" 22-Nov 13:36 bacula-dir JobId 361250: Using Device "vDrive-FullFileNoNextPool-0" to write. 22-Nov 13:36 dbclone-fd JobId 361250: shell command: run ClientRunBeforeJob "/usr/local/bacula/dump_catalog.sh" 22-Nov 13:36 dbclone-fd JobId 361250: ClientRunBeforeJob: Password: 22-Nov 13:36 dbclone-fd JobId 361250: ClientRunBeforeJob: pg_dump: error: connection to server at "pg03.int.unixathome.org" (10.55.0.34), port 5432 failed: fe_sendauth: no password supplied 22-Nov 13:36 bacula-sd-04 JobId 361250: Recycled volume "FullAutoNoNextPool-04-17758" on File device "vDrive-FullFileNoNextPool-0" (/usr/local/bacula/volumes/FullFileNoNextPool), all previous data lost. 22-Nov 13:36 bacula-dir JobId 3612[...]

AI生成摘要 这篇文章没有提供任何内容。

相关推荐 去reddit讨论

...
Dify.AI
...
eolink
...
观测云
...
白鲸技术栈
...
LigaAI
...
天勤数据
...
ShowMeBug
推荐或自荐