Re: "PANIC: could not open critical system index 2662" - twice

2023-07-13 Thread Andres Freund
Hi, On 2023-06-19 10:04:35 +, Evgeny Morozov wrote: > There haven't been any updates posted to > https://www.postgresql.org/message-id/20230509040203.z6mvijumv7wxcuib%40awork3.anarazel.de > so I just wanted to check if there is any update on the status of the > patch? Can we expect it in

Re: Problem perhaps after upgrading to pgadmin4 7.4

2023-07-13 Thread Erik Wienhold
> On 13/07/2023 13:20 CEST Carl Erik Eriksson wrote: > > Query tool PGadmin on my mac > > If I enter a query like select count(*) from table_1I get a correct > response from the server > If I enter select * from table_1 I get an error message that I do not > understand: > Error

Re: Problem perhaps after upgrading to pgadmin4 7.4

2023-07-13 Thread Carl Erik Eriksson
Problem solved - thanks Depez! (The solution for now is to downgrade to PGadmin4 version 7.2) > On 13 Jul 2023, at 13:52, hubert depesz lubaczewski wrote: > > On Thu, Jul 13, 2023 at 01:20:03PM +0200, Carl Erik Eriksson wrote: >> If I enter a query like select count(*) from table_1I

Re: Problem perhaps after upgrading to pgadmin4 7.4

2023-07-13 Thread Carl Erik Eriksson
Thanks - it seems we might be on pg 10.17-1 /Carl > On 13 Jul 2023, at 13:52, hubert depesz lubaczewski wrote: > > On Thu, Jul 13, 2023 at 01:20:03PM +0200, Carl Erik Eriksson wrote: >> If I enter a query like select count(*) from table_1I get a correct >> response from the server >> If

Re: Problem perhaps after upgrading to pgadmin4 7.4

2023-07-13 Thread hubert depesz lubaczewski
On Thu, Jul 13, 2023 at 01:20:03PM +0200, Carl Erik Eriksson wrote: > If I enter a query like select count(*) from table_1I get a correct > response from the server > If I enter select * from table_1 I get an error message that I do not > understand: > Error Message:missing FROM-clause

Problem perhaps after upgrading to pgadmin4 7.4

2023-07-13 Thread Carl Erik Eriksson
Query tool PGadmin on my mac If I enter a query like select count(*) from table_1I get a correct response from the server If I enter select * from table_1 I get an error message that I do not understand: Error Message:missing FROM-clause entry for table "rel" LINE 8: ...ER JOIN

JOB | DBA (Tokyo)

2023-07-13 Thread James Tobin
Hello, I'm working with an employer that is looking to hire a DBA for their office in Tokyo. They use MySQL but are looking to migrate in the near future to Postgres. Consequently, I had hoped some members of this group may like to discuss. I can be reached using "JamesBTobin (at) Gmail (dot)

Re: create a temp table in SPI

2023-07-13 Thread Laurenz Albe
On Thu, 2023-07-13 at 13:12 +0800, 黄宁 wrote: > I want to create some temporary tables in SPI, but after I created the table > and inserted the data, I can’t query any data, why? > > the postgres version: > PostgreSQL 13.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.0, 64-bit > code: > >

Re: EDB to Postgres Migration

2023-07-13 Thread Laurenz Albe
On Thu, 2023-07-13 at 11:58 +0530, KK CHN wrote: > Recently I happened to have  managed a few  EDB instances running on the > EDB-10 version .  > > I am looking for an option for migrating all these EDB instances  to Postgres > Community edition. If you are not using any of EDB's special

create a temp table in SPI

2023-07-13 Thread 黄宁
I want to create some temporary tables in SPI, but after I created the table and inserted the data, I can’t query any data, why? the postgres version: PostgreSQL 13.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.0, 64-bit code: int ret = 0; SPI_connect(); ret =

pg_restore mostly idle on restoring a large number of tables

2023-07-13 Thread Boris Sagadin
Hi, restoring a 1.5TB database with about 800k tables on i3.4xlarge AWS instace, PgSQL V12.15 on Ubuntu. Running pg_restore with -j 16, I noticed the pg_restore is busy for an hour or so with IO at 80%+ and then most of processes start idling and only a few doing some work, disk IO at 1-2%,

EDB to Postgres Migration

2023-07-13 Thread KK CHN
List, Recently I happened to have managed a few EDB instances running on the EDB-10 version . I am looking for an option for migrating all these EDB instances to Postgres Community edition. 1. What major steps / actions involved ( in bird's eye view ) for a successful migration to