[Testcase] Queries running forever, because of wrong rowcount estimate

2023-02-12 Thread Peter
CREATE DATABASE ttc WITH OWNER = admin ENCODING = 'UTF8' LC_COLLATE = 'de_DE.UTF-8' LC_CTYPE = 'de_DE.UTF-8' TABLESPACE = pg_default CONNECTION LIMIT = -1 IS_TEMPLATE = False; select version(); PostgreSQL 12.13 on amd64-portbld-freebsd13.1, compiled by FreeBSD

Re: pg_dump problem with postgres user

2023-02-12 Thread Adrian Klaver
On 2/12/23 13:10, ertan.kucuko...@1nar.com.tr wrote: Hello, My service provider spam filter just blocked your message and so I send a separate one. Your suspicion seems like correct. Postgres user is no more a superuser. Seems like they added postgresql_user and made it superuser. Who is

Re: pg_dump problem with postgres user

2023-02-12 Thread ertan.kucukoglu
Hello, My service provider spam filter just blocked your message and so I send a separate one. Your suspicion seems like correct. Postgres user is no more a superuser. Seems like they added postgresql_user and made it superuser. I thought I only allow access with certificate to the database. OS

Re: psql "\d" no longer working

2023-02-12 Thread Rob Sargent
I doubt that is the problem as the issue is the column in the table not finding the table. pg_class.relhasoids no longer exists 12+, so the post from Georg is probably pointing in the right direction. Ah, yes.  My client machine at compute centre has to be told to put version 14 on the

Re: psql "\d" no longer working

2023-02-12 Thread Adrian Klaver
On 2/12/23 08:49, Ron wrote: On 2/12/23 03:02, Rob Sargent wrote: 2023-02-10 13:42:55.214 MST [524159] STATEMENT:  SELECT c.relchecks, c.relkind, c.relhasindex, c.relhasrules, c.relhastriggers, c.relhasoids, '', c.reltablespace, CASE WHEN c.reloftype = 0 THEN '' ELSE

Re: psql "\d" no longer working

2023-02-12 Thread Ron
On 2/12/23 03:02, Rob Sargent wrote: Seems I've lost the table definition meta-command riftehr=> \d actual_and_inf_rel_clean_final ERROR:  column c.relhasoids does not exist LINE 1: ..., c.relhasindex, c.relhasrules, c.relhastriggers, c.relhasoi... while listing tables still

Re: psql "\d" no longer working

2023-02-12 Thread Adrian Klaver
On 2/12/23 01:24, Georg H. wrote: Hello Rob, Check the version of your psql binary. I assume it's below v13. There was a change in pg_catalog. Clients below 13 assume, the column is still there. That would be 11 and below. kind regards Georg -- Adrian Klaver

Re: pg_dump problem with postgres user

2023-02-12 Thread David G. Johnston
On Sun, Feb 12, 2023 at 7:22 AM wrote: > > I am using postgresql 14.6. PostgreSQL 15.1 is also installed in my system. > I just recognize that my scheduled backups are failing. > > I am using postgres user for backup user and .pgpass file for no password > prompt. > Given that you have

pg_dump problem with postgres user

2023-02-12 Thread ertan.kucukoglu
Hello, I am using postgresql 14.6. PostgreSQL 15.1 is also installed in my system. I just recognize that my scheduled backups are failing. I am using postgres user for backup user and .pgpass file for no password prompt. Result is same even I force a password prompt. Google results are I get are

Re: psql "\d" no longer working

2023-02-12 Thread Georg H.
Hello Rob, Am 12.02.2023 um 10:02 schrieb Rob Sargent: Seems I've lost the table definition meta-command riftehr=> \d actual_and_inf_rel_clean_final ERROR:  column c.relhasoids does not exist LINE 1: ..., c.relhasindex, c.relhasrules, c.relhastriggers, c.relhasoi... while

psql "\d" no longer working

2023-02-12 Thread Rob Sargent
Seems I've lost the table definition meta-command riftehr=> \d actual_and_inf_rel_clean_final ERROR:  column c.relhasoids does not exist LINE 1: ..., c.relhasindex, c.relhasrules, c.relhastriggers, c.relhasoi... while listing tables still works riftehr=> \dt act* List of