Language Selection

English French German Italian Portuguese Spanish

PostgreSQL News and Tools

Filed under
  • PostgreSQL: Install a local, non-root PostgreSQL Server with Python "pip"

    I'd like to announce the first release of postgresql-wheel, a Python package containing an entire compiled PostgreSQL server in a single pip installable file.

  • PostgreSQL: Psycopg 3.0 beta 1 released!

    We are immensely proud to release on PyPI the first beta package of Psycopg 3!

    Psycopg 3 is a complete rewrite of Psycopg 2, maintaining the same fundamental libpq wrapper architecture and DB-API interface design, but exposing new features to better work with the newer versions of Python and PostgreSQL.

    On the Python side, Psycopg 3 allows the use of asyncio-based concurrency and static typing. Many improvement to the Python interface make the library much simpler and more idiomatic to use,

    On the PostgreSQL side, Psycopg 3 makes use of server-side parameters, prepared statements, binary parameters, and great support for COPY operations.

    But the most outstanding feature of the project is not a technical one: Psycopg 3 was made possible by the great generosity of many sponsors, who have funded the development of the project. Among the many backers, we are especially grateful to Postgres Professional and Command Prompt, Inc, which have given the most outstanding support. But many other companies and individuals, each one in their capacity, have shown concrete support for free software development and progress. We sincerely hope that you will find this work useful and that you will feel proud for having contributed to it.

  • PostgreSQL Weekly News - August 29, 2021

    pg_dbms_job 1.0.1, an extension to create, manage and use Oracle-style DBMS_JOB scheduled jobs, released.

    dbMigration .NET v14.4, a database migration and sync tool, released.

    WAL-G 1.1 a backup management system for PostgreSQL and other databases written in Go, released.

    pglogical 2.4.0, a logical-WAL-based replication system for PostgreSQL, released.

    Crunchy PostgreSQL Operator 5.0.0, a system for deploying and managing open source PostgreSQL clusters on Kubernetes, released.

    set_user 2.0.1, an extension allowing privilege escalation with enhanced logging and control, released

    AGE 0.5.0, a PostgreSQL extension that provides graph database functionality, released

    pg_msvc_generator 1.0.0 beta, a tool for making Windows versions of extensions, released.

  • PostgreSQL: pg_dbms_job v1.1.0 has been released

    pg_dbms_job is a PostgreSQL extension to create, manage and use Oracle-style DBMS_JOB scheduled job. The use and behavior is just like with the DBMS_JOB Oracle package.

    pg_dbms_job v1.1.0 has been released, this is a maintenance release to fix some possible wrong behaviors, give control over other ones and improve the documentation.

More in Tux Machines

digiKam 7.7.0 is released

After three months of active maintenance and another bug triage, the digiKam team is proud to present version 7.7.0 of its open source digital photo manager. See below the list of most important features coming with this release. Read more

Dilution and Misuse of the "Linux" Brand

Samsung, Red Hat to Work on Linux Drivers for Future Tech

The metaverse is expected to uproot system design as we know it, and Samsung is one of many hardware vendors re-imagining data center infrastructure in preparation for a parallel 3D world. Samsung is working on new memory technologies that provide faster bandwidth inside hardware for data to travel between CPUs, storage and other computing resources. The company also announced it was partnering with Red Hat to ensure these technologies have Linux compatibility. Read more

today's howtos

  • How to install go1.19beta on Ubuntu 22.04 – NextGenTips

    In this tutorial, we are going to explore how to install go on Ubuntu 22.04 Golang is an open-source programming language that is easy to learn and use. It is built-in concurrency and has a robust standard library. It is reliable, builds fast, and efficient software that scales fast. Its concurrency mechanisms make it easy to write programs that get the most out of multicore and networked machines, while its novel-type systems enable flexible and modular program constructions. Go compiles quickly to machine code and has the convenience of garbage collection and the power of run-time reflection. In this guide, we are going to learn how to install golang 1.19beta on Ubuntu 22.04. Go 1.19beta1 is not yet released. There is so much work in progress with all the documentation.

  • molecule test: failed to connect to bus in systemd container - openQA bites

    Ansible Molecule is a project to help you test your ansible roles. I’m using molecule for automatically testing the ansible roles of geekoops.

  • How To Install MongoDB on AlmaLinux 9 - idroot

    In this tutorial, we will show you how to install MongoDB on AlmaLinux 9. For those of you who didn’t know, MongoDB is a high-performance, highly scalable document-oriented NoSQL database. Unlike in SQL databases where data is stored in rows and columns inside tables, in MongoDB, data is structured in JSON-like format inside records which are referred to as documents. The open-source attribute of MongoDB as a database software makes it an ideal candidate for almost any database-related project. This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you the step-by-step installation of the MongoDB NoSQL database on AlmaLinux 9. You can follow the same instructions for CentOS and Rocky Linux.

  • An introduction (and how-to) to Plugin Loader for the Steam Deck. - Invidious
  • Self-host a Ghost Blog With Traefik

    Ghost is a very popular open-source content management system. Started as an alternative to WordPress and it went on to become an alternative to Substack by focusing on membership and newsletter. The creators of Ghost offer managed Pro hosting but it may not fit everyone's budget. Alternatively, you can self-host it on your own cloud servers. On Linux handbook, we already have a guide on deploying Ghost with Docker in a reverse proxy setup. Instead of Ngnix reverse proxy, you can also use another software called Traefik with Docker. It is a popular open-source cloud-native application proxy, API Gateway, Edge-router, and more. I use Traefik to secure my websites using an SSL certificate obtained from Let's Encrypt. Once deployed, Traefik can automatically manage your certificates and their renewals. In this tutorial, I'll share the necessary steps for deploying a Ghost blog with Docker and Traefik.