RE: Unable to get PostgreSQL 15 with Kerberos (GSS) working

Here's the results: psql: error: connection to server at "hostname.mydomain.net" (::1), port 5432 failed: GSSAPI continuation error: Unspecified GSS failure. Minor code may provide more information: No Kerberos credentials available (default cache: KCM:) If I run kinit and get Kerberos ticket

Re: Fastest way to clone schema ~1000x

An update on this for anyone else who has similar issues/considerations: - As suggested, we are sticking to 1 database-per-test, and not a schema-per-test. - We moved our testing setup to maintain at most 1 connection per backend worker. If a request for a different test comes in, we close and reco

Re: Non-Stored Generated Columns

On Thu, 2024-02-29 at 08:55 +0100, Dominique Devienne wrote: > On Wed, Feb 28, 2024 at 8:11 PM Tom Lane wrote: > > Dominique Devienne writes: > > > Views can have foreign-keys? > > > > Surely you'd put the FK on the underlying table. > > Again, the FKs are on the *generated* columns. So  >   >

Re: Content for talk on Postgres Type System at PostgresConf

On Wed, 2024-02-28 at 17:08 -0800, Guyren Howe wrote: > I am to talk about Postgres’s type system at PGConf: > > https://postgresconf.org/conferences/2024/program/proposals/postgres-s-type-system > > I picked the issue because I think it’s poorly understood, greatly > under-discussed, and an exce

Re: Non-Stored Generated Columns

On Thu, Feb 29, 2024 at 10:03 AM Laurenz Albe wrote: > On Thu, 2024-02-29 at 08:55 +0100, Dominique Devienne wrote: > Polymorphic Foreign Keys are nigh impossible to model well in SQL, > and I doubt that non-stored generated columns will solve that. > It is modelled. It works. As I already wrote

SUSE repositories not longer available

I have noticed since the changes on the 27th this month (https://people.planetpostgresql.org/devrim/index.php?/archives/122-Installing-PostgreSQL-on-SLES-15-just-got-easier-and-better!.html) that some repositories are no longer available. I specifically noticed it with all SuSE 15.4 repositories,

Re: Non-Stored Generated Columns

On 2024-Feb-29, Dominique Devienne wrote: > Honestly, I'm not sure why supporting the non-stored variant of generated > columns is so controversial... I don't think there's anything controversial about virtual generated columns, really ... it's just that it's tricky to implement and we don't have

Re: Non-Stored Generated Columns

On 28.02.24 16:09, Dominique Devienne wrote: We use generated columns extensively. And we have foreign-keys attached to those generated columns. The fact they are always Stored thus wastes space in our case. Any chance PostgreSQL might gain actual virtual / non-stored generated columns soon? Eve

Re: Non-Stored Generated Columns

On Thu, Feb 29, 2024 at 11:26 AM Peter Eisentraut wrote: > On 28.02.24 16:09, Dominique Devienne wrote: > > Any chance PostgreSQL might gain actual virtual / non-stored generated > > columns soon? Ever? > > I plan to work on this for PG18. > Thanks for the update, Peter and Alvaro. --DD

Re: SUSE repositories not longer available

El día jueves, febrero 29, 2024 a las 10:16:59 +, Or Cohen escribió: > ... > Thanks, > Or > --- > This message is confidential. If you believe you received this message in > error, please inform the sender and delete this message and all attachments. I

Re: Non-Stored Generated Columns

On Thu, 2024-02-29 at 10:55 +0100, Dominique Devienne wrote: > On Thu, Feb 29, 2024 at 10:03 AM Laurenz Albe > wrote: > > Honestly, I'm not sure why supporting the non-stored variant of generated > columns is so controversial... >   > > I am sure there are some use cases for "virtual" generated

Re: Moving PostgreSQL servers to a new server

Hello,I have the same question. I hope someone can answer this question clearly. On Wed, Feb 28, 2024 at 10:04 PM, normandavis1990 wrote: Hi,I am new to PostgreSQL. My scenario is as follows: https://cdn.bloghunch.com/uploads/uNxNoi5uVKeDibd5.webp I have a Master server and two Replica (R

Re: Non-Stored Generated Columns

On Thu, Feb 29, 2024 at 11:58 AM Laurenz Albe wrote: > On Thu, 2024-02-29 at 10:55 +0100, Dominique Devienne wrote: > > On Thu, Feb 29, 2024 at 10:03 AM Laurenz Albe > wrote: > > > You could use conditional indexes, but then you have to make sure that > > > the optimizer knows it can use these i

RE: SUSE repositories not longer available

Woops. Don't worry about it, just used wrong label. The rest of the world is free to view the message while it can. -Original Message- From: Matthias Apitz Sent: Thursday, February 29, 2024 12:46 PM To: Or Cohen Cc: pgsql-general@lists.postgresql.org Subject: Re: SUSE repositories not l

Re: Non-Stored Generated Columns

On Thu, 2024-02-29 at 12:07 +0100, Dominique Devienne wrote: > But I'm sure indexes on columns "not used at all in a statement" are > eliminated early and easily/cheaply, > w/o even getting into more complex consideration like statistics and co. > Aren't they? You may want a "SELECT count(*) FRO

Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working

Greetings, * Matthew Dennison (m...@matty-uk.co.uk) wrote: > If I run kinit and get Kerberos ticket ahead of running the command I then > receive: Right, have to kinit first. > psql: error: connection to server at " hostname.mydomain.net " (::1), port > 5432 failed: could not initiate GSSAPI s

Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working

On 2/29/24 01:18, Matthew Dennison wrote: Here's the results: psql: error: connection to server at "hostname.mydomain.net" (::1), port 5432 failed: GSSAPI continuation error: Unspecified GSS failure. Minor code may provide more information: No Kerberos credentials available (default cache:

Voluntary Product Assessment For pgAdmin 8.3

To whom it may concern, Your product, pgAdmin 8.3, is a candidate technology for use within the U.S. General Services Administration (GSA) enterprise environment. Technologies under review by GSA’s Office of the Chief Technology Officer (OCTO) must be accompanied by a completed Voluntary Product A

Re: Excel Source [24]] Error: System.Exception: SqlTruncateException: Numeric arithmetic causes

cc'ing list. On 2024-02-29 07:16 +0100, Anthony Apollis wrote: > I cant change data type using the advance editor in destination: > [image: image.png] > [image: image.png] The column type must be changed in the database itself. On second thought, are you sure "Metric Value" is the right destinat

Re: Voluntary Product Assessment For pgAdmin 8.3

On Thu, 2024-02-29 at 07:31 -0500, Anthony Codjoe - IQ-C wrote: > Your product, pgAdmin 8.3, is a candidate technology for use within the > U.S. General Services Administration (GSA) enterprise environment. > Technologies under review by GSA’s Office of the Chief Technology Officer > (OCTO) > must

Re: SUSE repositories not longer available

On 2/29/24 02:16, Or Cohen wrote: I have noticed since the changes on the 27^th this month (https://people.planetpostgresql.org/devrim/index.php?/archives/122-Installing-PostgreSQL-on-SLES-15-just-got-easier-and-better!.html

RE: SUSE repositories not longer available

I am aware of it, that's not the problem. The problem I have is repositories are non-existent, returning 404 - https://download.postgresql.org/pub/repos/zypp/15/suse/sles-15.4-x86_64/ That's one for instance, it was the same for me for 12-16, and I can't even find a reference of PostgreSQL repo f

Re: Voluntary Product Assessment For pgAdmin 8.3

On 2/29/24 04:31, Anthony Codjoe - IQ-C wrote: To whom it may concern, Your product, pgAdmin 8.3, is a candidate technology for use within the U.S. General Services Administration (GSA) enterprise environment. Technologies under review by GSA’s Office of the Chief Technology Officer (OCTO) m

Re: SUSE repositories not longer available

On 2/29/24 08:07, Or Cohen wrote: I am aware of it, that's not the problem. The problem I have is repositories are non-existent, returning 404 - https://download.postgresql.org/pub/repos/zypp/15/suse/sles-15.4-x86_64/ That's one for instance, it was the same for me for 12-16, and I can't even f

Re: Content for talk on Postgres Type System at PostgresConf

On Thu, Feb 29, 2024 at 10:11:03AM +0100, Laurenz Albe wrote: > It might be good to explain how "timestamp with time zone" works. > That's often confusing for beginners, because it is different from > other databases and arguably deviates from the SQL standard. The most confusing part is the name

High Availability and Replication

Hello, What is the difference between High Availability and Replication? Cheers.

Re: High Availability and Replication

On Thursday, February 29, 2024, normandavis1990 wrote: > > What is the difference between High Availability and Replication? > The former is a goal, the later is a technique. David J.

RE: High Availability and Replication

What David said 😉 Disclaimer – I work for Quest Software – we produce database tools, including SharePlex, which can be used to help create High Availably and Disaster Recovery solutions. Here’s a blog I did several years ago that might be helpful https://www.quest.com/community/blogs/b/databas

Re: High Availability and Replication

What does this technique do? On Thursday, February 29th, 2024 at 10:45 PM, David G. Johnston wrote: > On Thursday, February 29, 2024, normandavis1990 > wrote: > >> What is the difference between High Availability and Replication? > > The former is a goal, the later is a technique. > > David J

Re: High Availability and Replication

On 2/29/24 12:02, normandavis1990 wrote: What does this technique do? https://www.postgresql.org/docs/current/high-availability.html On Thursday, February 29th, 2024 at 10:45 PM, David G. Johnston wrote: On Thursday, February 29, 2024, normandavis1990 mailto:normandavis1...@proton.me>>

Re: High Availability and Replication

> On Feb 29, 2024, at 10:15 AM, David G. Johnston > wrote: > > > > On Thursday, February 29, 2024, normandavis1990 > wrote: >> >> What is the difference between High Availability and Replication? > > The former is a goal, the later is a technique. Perhaps

Re: Question on Table creation

Thank you so much. I tested and it worked as you mentioned i.e the template table is helping to add the extra indexes or constraints to the child table/partitions (by inheriting those from the template table if defined), those are not defined there in the main table. Also dropping the default part

Re: Content for talk on Postgres Type System at PostgresConf

In case I’m not correct on the issues with these types, myself, what are the misconceptions, or where might I find them for  myself? My current understanding: • character is fixed-length, blank-padded. Not sure when you’d want that, but it seems clear. Is the name just confusing? • timestamptz

Re: Content for talk on Postgres Type System at PostgresConf

On 2/29/24 1:38 PM, Guyren Howe wrote: In case I’m not correct on the issues with these types, myself, what are the misconceptions, or where might I find them for  myself? My current understanding: * character is fixed-length, blank-padded. Not sure when you’d want that, but it seems cl

Re: Content for talk on Postgres Type System at PostgresConf

On Thu, Feb 29, 2024 at 2:38 PM Guyren Howe wrote: > In case I’m not correct on the issues with these types, myself, what are > the misconceptions, or where might I find them for myself? > > My current understanding: > >- character is fixed-length, blank-padded. Not sure when you’d want >

Re: Content for talk on Postgres Type System at PostgresConf

On 28 Feb 2024, at 17:08, Guyren Howe wrote: > > I am to talk about Postgres’s type system at PGConf: > > https://postgresconf.org/conferences/2024/program/proposals/postgres-s-type-system > > I picked the issue because I think it’s poorly understood, greatly > under-discussed, and an excellen

Re: Content for talk on Postgres Type System at PostgresConf

"David G. Johnston" writes: > On Thu, Feb 29, 2024 at 2:38 PM Guyren Howe wrote: >> My current understanding: >> >> - character is fixed-length, blank-padded. Not sure when you’d want >> that, but it seems clear. Is the name just confusing? > Character is not stored fixed length, it is stored v

Re: Content for talk on Postgres Type System at PostgresConf

On 29 Feb 2024, at 14:51, Tom Lane wrote: > >>> - time with time zone *does* store the time zone, but this isn’t >>> actually useful and should be avoided (I’m not entirely sure why and the >>> docs only gesture at the problems without stating them, IIRC) > >> No it doesn't store the time zone.

Re: Content for talk on Postgres Type System at PostgresConf

On 2/29/24 14:47, Guyren Howe wrote: What is worth saying about custom range types? What even would be a good use case? A range of strings or ip address ranges, something like that, I suppose? I wrote a blog post and an extension for an inetrange type. It's from 2016 so it might need some upda

Re: walreceiver fails on asynchronous replica [EXTERNAL] [SEC=UNOFFICIAL]

Hi, Mark. At Thu, 29 Feb 2024 04:39:49 +, Mark Schloss wrote in > Thanks for looking at this. I think I complicated things by > including barman. I was just wanting to point out each primary > streams to two locations - the walreceiver on the replica and the > walreciver used by barman. We