Re: vacuumdb seems not to like option -j when run from crontab

2023-12-05 Thread Joshua Drake
8.4 does not support -j On Mon, Dec 4, 2023 at 8:22 AM Ron Johnson wrote: > (Sorry for top-posting. Blame gmail.) > > Turns out that PG 8.4.20 is also installed from the RHEL repository. > > Thanks. > > On Mon, Dec 4, 2023 at 11:13 AM Alan Hodgson > wrote: > >> On Mon, 2023-12-04 at 11:07

Re: Postgres calendar?

2022-10-04 Thread Joshua Drake
Bruce, It would certainly help in keeping track of things. JD On Tue, Oct 4, 2022 at 2:02 PM Bruce Momjian wrote: > Would people be interesting in subscribing to a Postgres calendar that > includes dates for minor releases, final minor release dates for major > versions, commit fests, and

Re: Logical replication of large objects

2022-06-09 Thread Joshua Drake
Large objects are largely considered a deprecated feature. Though I like the idea, was there any consensus on -hackers? JD On Sun, Jun 5, 2022 at 2:23 AM Andreas Joseph Krogh wrote: > I started this thread 5 years ago: >

Re: Sharing DSA pointer between parallel workers after they've been created

2022-06-09 Thread Joshua Drake
Marcus, This is probably better suited for -hackers. JD On Wed, Jun 8, 2022 at 8:00 PM Ma, Marcus wrote: > Hey, > > > > I’m currently working on a parallelization optimization of the Sequential > Scan in the codebase, and I need to share information between the workers > as they scan a

Re: Cluster OID Limit

2022-06-09 Thread Joshua Drake
Lucas, If you run out of OIDs you are doing something wrong. We haven't supported user space OIDs in a lot of releases. Which release are you using? JD On Thu, Jun 9, 2022 at 2:11 AM Lucas wrote: > Hello, > > In the company I work for, some clusters reached the OID limit (2^32) and > we had

Re: Ubuntu 14.04 (trusty) Postgres 13 deb package

2021-06-28 Thread Joshua Drake
On Sun, Jun 27, 2021 at 10:42 AM Bhavesh Mistry wrote: > Hi All, > > I was trying to install PSQL 13 on Ubuntu 14.04 (trusty) but I could not > find the package. It seems the path has been removed. Can you please tell > me how to build deb package for trusty from psql source? I tried psql 13

Re: bottom / top posting

2021-06-07 Thread Joshua Drake
> > > > It > > could probably be argued that the prohibition was more relevant in the > days > > before 99% of users read their email via clients which hide quoted > content > > unless it is explicitly expanded. > > Yeah, gmail is aggressively unfriendly for this purpose. But if you > can't be

Re: PL/java

2020-12-07 Thread Joshua Drake
> > > > The PL/java “add-on” is not supported directly by Postgres. > > With a few exceptions (Perl, Python) this is how the community handles all "add-ons". A great number of features available to you are available as third party extensions and not part of core. Zombodb, Timescale and Citus are

Re: Multiple result set not displayed in PgAdmin4

2020-11-23 Thread Joshua Drake
Howdy, I believe you would receive more help from the proper forum for PgAdmin4: https://www.pgadmin.org/support/list/ This is a list for PostgreSQL and it's software. PostgreSQL's client is psql which is a command line client. Thanks! JD >> >>

Re: pg_dump - how to force to show timestamps in client log

2020-11-20 Thread Joshua Drake
Howdy, pg_dump is just issuing SQL commands, you could turn on timestamps in your postgresql log. JD On Fri, Nov 20, 2020 at 10:02 AM Durumdara wrote: > Hello! > > We need to log the pg_dump's state. > What objects are in copy, and what are the starting and ending times. > > But when I try to

Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?

2020-09-21 Thread Joshua Drake
Howdy, First let me say thanks for the feedback! It is rare that we receive detailed "user feedback" on these lists so it is good to hear from the outside world. I am only going to address a few things as others have addressed the rest. > 2. pg_dump misinterprets non-ANSI values for the

Re: Function Speed vs UI Function Speed

2020-08-31 Thread Joshua Drake
On Mon, Aug 31, 2020 at 10:32 AM Susan Hurst wrote: > > For example, a batch load script that inserts multiple rows into a table > may call an insert function within a cursor to populate each row into > the target table. Meanwhile, a non-technical business user may want to > create only one

Re: Logical replication

2020-06-17 Thread Joshua Drake
Javi, What does your PostgreSQL log say about replication? JD On Wed, Jun 17, 2020 at 2:07 AM Javi Legido wrote: > Good morning. > > I'm testing logical replication, but after creating subscription nothing > happens, and I expected replication start. > > Details here:

Re: Minor Upgrade Question

2020-06-17 Thread Joshua Drake
Susan You can use -Uvh to upgrade the rpms on the existing machine. You can then use symlinks to link the expected pgsql data directories. Make sure you take a backup, and stop the service before you proceed. JD On Tue, Jun 16, 2020 at 7:12 AM Susan Joseph wrote: > So when I first started

Re: PostgreSQL native multi-master

2020-04-09 Thread Joshua Drake
In this instance, BDR from 2ndquadrant is probably your best bet. It is commercial but they are a community supporting company. JD On Wed, Apr 8, 2020, 08:53 Stephen Frost wrote: > Greetings, > > * Vano Beridze (vanua...@gmail.com) wrote: > > What are the plans to support multi-master

Re: full text

2020-04-08 Thread Joshua Drake
Roberto, I would look at ZomboDB: https://www.zombodb.com/ . Which is exactly what you suggest. JD On Wed, Apr 8, 2020 at 10:28 AM Roberto Della Pasqua < roberto.dellapas...@live.com> wrote: > Please sorry because I’m newbie of PGSQL > > > > I need the best performing and overall quality