psql's default database on connect (our internal ref. SRP-30861)

Hello, testpos@srap53dxr1:~> psql --help ... -d, --dbname=DBNAME database name to connect to (default: "testpos") testpos@srap53dxr1:~> whoami testpos testpos@srap53dxr1:~> env | grep PG PGPASSWORD= PGHOST=localhost PGPORT=5432 testpos@srap53dxr1:~> LANG=C psql -Usisis psql (

Re: Series of 10 questions about the use of postgresql, generally.

On Thu, Aug 5, 2021 at 9:46 PM A Z wrote: > >1. Are there free script for CREATE TYPE (native type) or types out >there, online, free for commercial use? With function support, too? Can >someone reply with a link or a suggestion? > > Look at the PostgreSQL source code, contrib directo

Re: Series of 10 questions about the use of postgresql, generally.

Hi pá 6. 8. 2021 v 6:46 odesílatel A Z napsal: > I have been going through the free online book LEARNING postgresql book, > that has been compiled by Stack Overflow contributors. I have gotten to the > point where I have the following series of unanswered questions: > > >1. Are there free sc

Series of 10 questions about the use of postgresql, generally.

I have been going through the free online book LEARNING postgresql book, that has been compiled by Stack Overflow contributors. I have gotten to the point where I have the following series of unanswered questions: 1. Are there free script for CREATE TYPE (native type) or types out there, on

Re: autovacuum worker started without a worker entry

I am attempting to dive into code using english, not c, if i am misguiding, pls ignore. On Thu, 5 Aug 2021 at 11:38, Luca Ferrari wrote: > Hi all, > I occasionally see the message "WARNING: autovacuum worker started > without a worker entry" in the logs. > From what I can see here > < > https:/

Re: Logical Replication - Different Primary Key on Source Table and Destination Table

On Thu, Aug 5, 2021 at 12:22 AM Avi Weinberg wrote: > Is it permitted to have different primary key on source and destination > tables? > Sure, but you are still going to want a unique index on the source table that includes the site ID to act as a replica identity. Which of the two unique inde

PostgreSQL Apt Repository instructions need updating

Re: https://www.postgresql.org/download/linux/debian/ The instructions presented for key handling are not inline with Debian best-practices  As per https://wiki.debian.org/DebianRepository/UseThirdParty: "The key MUST be downloaded over a secure mechanism like HTTPS to a location only writable

Logical Replication - Different Primary Key on Source Table and Destination Table

Hi I use logical replication to copy data from many source tables to one destination table. On destination table I would like to have primary key composed of the source site ID and row ID. On the source table I only need the primary key to be the row ID since the site ID is always the same pe