Re: ltree and PHP

Open _ writes: > I've created the ltree extensioncreated a table with an ltree column called > ltree_path > In php I can access the table, insert, update, delete.but ltree operators > don't work. It sounds like the ltree extension is in a schema that's not in the search_path setting you're usin

updating(column) Porting from Oracle Trigger to PostgreSQL trigger

Hi Team, When we do an implementation from Oracle to PostgreSQL in trigger for clause like : updating(column_name) ==> (TG_OP='UPDATE' and OLD.column_name IS DISTINCT FROM NEW.column_name) But this condition would mostly not be sufficient when we are updating any column and with similar val

ltree and PHP

I've created the ltree extensioncreated a table with an ltree column called ltree_path In php I can access the table, insert, update, delete.but ltree operators don't work. select count() from schema.table  where 'A.B.C' @> ltree_path; gives me a "could not determine polymorphic type anyrange bec

Re: Unable To Drop Tablespace

On Fri, Feb 5, 2021 at 12:43 PM Ian Lawrence Barwick wrote: > 2021年2月5日(金) 3:52 Pavan Pusuluri : >> We are trying to drop a table space on RDS Postgres . We have removed the >> objects etc, but it still won't drop. >> >> I have checked and there's no reference anywhere to this tablespace but it

Re: Unable To Drop Tablespace

Thank you very much Ian. Will check it out. Regards On Thu, Feb 4, 2021, 5:43 PM Ian Lawrence Barwick wrote: > 2021年2月5日(金) 3:52 Pavan Pusuluri : > >> Hi there >> >> We are trying to drop a table space on RDS Postgres . We have removed the >> objects etc, but it still won't drop. >> >> I have

Re: Unable To Drop Tablespace

2021年2月5日(金) 3:52 Pavan Pusuluri : > Hi there > > We are trying to drop a table space on RDS Postgres . We have removed the > objects etc, but it still won't drop. > > I have checked and there's no reference anywhere to this tablespace but it > complains it's not empty. > > I checked if it is a de

Re: Partition Creation Permissions

Ah, I didn't realize that was an option on the function. They're already being created by a trigger (the table is partitioned on a foreign key, so partitions are created by a trigger on the referenced table); it sounds like I can just update that trigger function with `security definer`. -Sam ht

Re: Partition Creation Permissions

On Thu, Feb 4, 2021 at 3:39 PM Samuel Nelson wrote: > I've been trying to restrict permissions of some users in our system and > noticed that `create table foo partition of bar for values from (x) to (y)` > complains that I must be the owner of the table. Is there another GRANT I > can give to m

Partition Creation Permissions

Hi list! I've been trying to restrict permissions of some users in our system and noticed that `create table foo partition of bar for values from (x) to (y)` complains that I must be the owner of the table. Is there another GRANT I can give to my user to allow creation and dropping of partitions

Re: vacuumdb not letting me connect to db

>There is no error message, when I try to connect the database while >running vacuumdb with 300 jobs, it gets stuck. But you mentioned max connection which now seems to be a red herring. Based on your description, the impression I got is that you are getting "sorry, too many clients already" e

Unable To Drop Tablespace

Hi there We are trying to drop a table space on RDS Postgres . We have removed the objects etc, but it still won't drop. I have checked and there's no reference anywhere to this tablespace but it complains it's not empty. I checked if it is a default for a database, revoked all privileges on the

Re: vacuumdb not letting me connect to db

Your problem screams "IO saturation". On 2/4/21 12:07 PM, Atul Kumar wrote: There is no error message, when I try to connect the database while running vacuumdb with 300 jobs, it gets stuck. On Thursday, February 4, 2021, Ravi Krishna > wrote: >The CPU and RAM

Re: vacuumdb not letting me connect to db

There is no error message, when I try to connect the database while running vacuumdb with 300 jobs, it gets stuck. On Thursday, February 4, 2021, Ron wrote: > On 2/4/21 5:26 AM, Atul Kumar wrote: > > Hi, > > I have 160 GB of RAM, postgres 9.6 is running on the server. > > after upgrade I ran the

Re: vacuumdb not letting me connect to db

There is no error message, when I try to connect the database while running vacuumdb with 300 jobs, it gets stuck. On Thursday, February 4, 2021, Ravi Krishna wrote: > >The CPU and RAM are normal even on 300 jobs ( only 1-4% of consumption) > >but I don’t understand one thing here that if max_co

Re: vacuumdb not letting me connect to db

>The CPU and RAM are normal even on 300 jobs ( only 1-4% of consumption) >but I don’t understand one thing here that if max_connections is set to 700 >then >why I am not able to connect the db. As the running jobs (300) are lesser than >half of max_connections. Please paste the error message

Re: vacuumdb not letting me connect to db

What about disk IO?  That's what really gets saturated when running 300 threads. On 2/4/21 11:00 AM, Atul Kumar wrote: Hi, The CPU and RAM are normal even on 300 jobs ( only 1-4% of consumption) but I don’t understand one thing here that if max_connections is set to 700 then why I am not able

Re: vacuumdb not letting me connect to db

On 2/4/21 5:26 AM, Atul Kumar wrote: Hi, I have 160 GB of RAM, postgres 9.6 is running on the server. after upgrade I ran the below command: "/usr/edb/as9.6/bin/vacuumdb" -U 'enterprisedb' --verbose --all -j 300 --analyze-only after running that command I was not able to connect the database

Re: vacuumdb not letting me connect to db

Hi, The CPU and RAM are normal even on 300 jobs ( only 1-4% of consumption) but I don’t understand one thing here that if max_connections is set to 700 then why I am not able to connect the db. As the running jobs (300) are lesser than half of max_connections. Regards Atul On Thursday, Februa

Re: Request for example using pqconnectstart,pqconnectpoll part.

On Thu, 2021-02-04 at 15:27 +, Om Prakash Jaiswal wrote: > Please provide a sample example using pqconnectstart , pqconnectpoll to make > a asynchronous connection and executing a query for client application in C. > It is part of libpq - C Library. > I am able to do query using PQconnectdb and

Request for example using pqconnectstart,pqconnectpoll part.

Hi,Please provide a sample example using pqconnectstart , pqconnectpoll to make  a asynchronous connection and executing a query for client application in C.It is part of libpq - C Library. I am able to do query using PQconnectdb and PQexec.I have also used PQconnectdb and PQsendQuery.  PQconne

Re: cant connect to localhost:5432 (but unix socket ok)

On Thu, Feb 4, 2021 at 3:04 PM Joao Miguel Ferreira < joao.miguel.c.ferre...@gmail.com> wrote: > > > On Thu, Feb 4, 2021 at 3:02 PM Joao Miguel Ferreira < > joao.miguel.c.ferre...@gmail.com> wrote: > >> Hi Tom >> >> On Thu, Feb 4, 2021 at 2:50 PM Tom Lane wrote: >> >>> Joao Miguel Ferreira write

Re: PgAdmin 4 GUI not responding

https://www.pgadmin.org/support/list/ On 2/4/21 3:46 AM, Adith Suresh wrote: Hi Team, I have installed postgres 13 on windows server and I am facing an issue while opening PgAdmin 4. The GUI is not responding. I have tried restarting the service, still the issue is persisting. Please provid

Re: cant connect to localhost:5432 (but unix socket ok)

On Thu, Feb 4, 2021 at 3:02 PM Joao Miguel Ferreira < joao.miguel.c.ferre...@gmail.com> wrote: > Hi Tom > > On Thu, Feb 4, 2021 at 2:50 PM Tom Lane wrote: > >> Joao Miguel Ferreira writes: >> > On Thu, Feb 4, 2021 at 2:26 PM hubert depesz lubaczewski < >> dep...@depesz.com> >> > wrote: >> >>> My

Re: cant connect to localhost:5432 (but unix socket ok)

Hi Tom On Thu, Feb 4, 2021 at 2:50 PM Tom Lane wrote: > Joao Miguel Ferreira writes: > > On Thu, Feb 4, 2021 at 2:26 PM hubert depesz lubaczewski < > dep...@depesz.com> > > wrote: > >>> My database is not listening on TCP/localhost, desptite it is listening > on the unix socket. How can I

Re: cant connect to localhost:5432 (but unix socket ok)

Joao Miguel Ferreira writes: > On Thu, Feb 4, 2021 at 2:26 PM hubert depesz lubaczewski > wrote: >>> My database is not listening on TCP/localhost, desptite it is listening on the unix socket. How can I investigate this? > it's on 5433: Hmm, something odd there, because a port number misma

PgAdmin 4 GUI not responding

Hi Team, I have installed postgres 13 on windows server and I am facing an issue while opening PgAdmin 4. The GUI is not responding. I have tried restarting the service, still the issue is persisting. Please provide help for fixing this issue as early as possible Regards, Adith Suresh

Re: cant connect to localhost:5432 (but unix socket ok)

On Thu, Feb 4, 2021 at 2:26 PM hubert depesz lubaczewski wrote: > On Thu, Feb 04, 2021 at 02:20:10PM +, Joao Miguel Ferreira wrote: > > My database is not listening on TCP/localhost, desptite it is listening > on the unix socket. How can I investigate this? > > I could have done something tha

Re: cant connect to localhost:5432 (but unix socket ok)

On Thu, Feb 04, 2021 at 02:20:10PM +, Joao Miguel Ferreira wrote: > My database is not listening on TCP/localhost, desptite it is listening on > the unix socket. How can I investigate this? > I could have done something that is out of my understanding because I have > been loading some big pg

cant connect to localhost:5432 (but unix socket ok)

Hello all, My database is not listening on TCP/localhost, desptite it is listening on the unix socket. How can I investigate this? I could have done something that is out of my understanding because I have been loading some big pg_dumpall files that might contain administrative changes that I am

Re: when is useful min_wal_size?

On Thu, 2021-02-04 at 12:41 +0100, Luca Ferrari wrote: > this may sound trivial, but in my opinion min_wal_size is useful only > when the cluster is initialized or the wals are reset. > Am I wrong? The amount of WAL that PostgreSQL pre-creates for future use depends on the database activity but ha

Re: curious vacuum full behavior

On Thu, 2021-02-04 at 10:03 +, Zwettler Markus (OIZ) wrote: > I have 2 identical systems A + B. > B being a clone of A. > > The table pg_catalog.pg_largeobject was identical on both systems: 300GB in > total size; 100GB bloated. > > I did following on A: > ð vacuum full pg_catalog.pg_largeo

when is useful min_wal_size?

Hi all, this may sound trivial, but in my opinion min_wal_size is useful only when the cluster is initialized or the wals are reset. Am I wrong? Luca

Re: vacuumdb not letting me connect to db

On Thu, 2021-02-04 at 16:56 +0530, Atul Kumar wrote: > I have 160 GB of RAM, postgres 9.6 is running on the server. > > after upgrade I ran the below command: > > "/usr/edb/as9.6/bin/vacuumdb" -U 'enterprisedb' --verbose --all -j 300 > --analyze-only > > after running that command I was not abl

vacuumdb not letting me connect to db

Hi, I have 160 GB of RAM, postgres 9.6 is running on the server. after upgrade I ran the below command: "/usr/edb/as9.6/bin/vacuumdb" -U 'enterprisedb' --verbose --all -j 300 --analyze-only after running that command I was not able to connect the database using psql for few minutes. After 20-

curious vacuum full behavior

I have 2 identical systems A + B. B being a clone of A. The table pg_catalog.pg_largeobject was identical on both systems: 300GB in total size; 100GB bloated. I did following on A: ? vacuum full pg_catalog.pg_largeobject; (using the default maintenance_work_mem of 64MB) It took around 45 min

COPY command in ODBC

Hi, How to use COPY command in ODBC for reading STDIN buffer. It would be great if someone explains with an example of ODBC COPY call along with STDIN buffer. Thanks in advance. Thanks Braj