Hi Thorsten:
On Thu, Jul 15, 2021 at 6:30 PM Thorsten Schöning wrote:
> I need to backup multiple host with multiple Postgres databases each.
> In all of those cases I'm interested to backup all databases, which
> makes pg_dumpall a natural choice at first glance. Though, from my
> understanding
Hi everyone,
I need to backup multiple host with multiple Postgres databases each.
In all of those cases I'm interested to backup all databases, which
makes pg_dumpall a natural choice at first glance. Though, from my
understanding of the docs that is only capable of storing all
databases per host
hubert depesz lubaczewski wrote on 7/15/21 5:15 AM:
select * from regexp_matches(_YOUR_MULTIRANGE_::text, '[\[(][^\])]+[\])]', 'g');
I wrote more, including explanation, and ready-to-use function, in here:
https://www.depesz.com/2021/07/15/how-to-get-list-of-elements-from-multiranges/
So ugly
One thing I forgot is that these XIDs are fairly old, perhaps dating
back to when this database was freshly initdb'd if there has been no XID
wraparound. In that case you were probably running a version much older
than 10.14 when they were written. Do you happen to know when did you
initdb this,
Hi Sasha
On 2021-Jul-14, Sasha Aliashkevich wrote:
> lp | ctid | xmin| xmax | xmax_is_lock | xmax_committed |
> xmax_rolled_back | xmax_multixact
> +-+---+--+--++--+
> 19 | (75,21) | 571 | 572
On Wed, Jul 14, 2021 at 04:19:48PM -0700, Ben Chobot wrote:
> I'm really, really liking the multirange types in PG14. Thank you for making
> them! Unfortunately I am struggling with how to loop over the segments of a
> multirange. There doesn't seem to be a way to convert them to arrays, and I
> ca
Hi, here's an update on this old thread.
I've found the problem, it was because of long transactions.
I reproduced the problem when I added a second publication and another
postgres cluster with a subscription to it (on acceptance still).
This query came in handy to show me what was happening:
se
‐‐ Original Message ‐‐‐
On Wednesday, July 14th, 2021 at 5:30 PM, Laurenz Albe laurenz.a...@cybertec.at
wrote:
On Tue, 2021-07-13 at 20:14 -0700, David G. Johnston wrote:
> > On Tue, Jul 13, 2021 at 8:01 PM Lucas r...@sud0.nz wrote:
> >
> > > According to the documentation, max_standb
Hi Ho John Lee,
I found one can in DBeaver upload an image into bytea data type column.
So my issue is gone; by using DBeaver I can upload images and also
display those images stored in a postgresql database.
Thanks!
2021. 07. 15. 6:47 keltezéssel, Ho John Lee írta:
I use python with psycopg
On Wed, 2021-07-14 at 16:12 +, Adam Norwood wrote:
> First post and I'm a complete beginner when it comes to Postgresql, however
> I've been tasked
> with updating a versionn 9.5 install on Ubuntu 20.04 to just about any later
> version I can
> get (latest preferably) but have hit a number
On 12-07-2021 23:21, Tom Lane wrote:
Jurrie Overgoor writes:
Is this considered a bug in PostgreSQL, or
am I misusing the database engine by doing DROP DATABASE and CREATE
DATABASE over and over again?
It's not a bug. I suppose in a perfect world the stats would
automatically be up to date al
I use python with psycopg2, for a table 'myimage_table' with columns
'label' and 'b' of type varchar and bytea something like this:
query = 'insert into myimage_table (label, b) values (%s, %s)'
imagelabel = 'some_label'
imagebuf =
b = psycopg2.Binary(imagebuf)
cur.execute(query, (imagelabel, b
If you have the binary data for the image in the bytea field, DBeaver will
display the image when you select that field in table view of the data.
The field will display something like "ÿØÿà JFIF [n]" in the row
(first part of data as unicode, and data length in bytes), you won't see
the ima
Hi Everyone,
First post and I'm a complete beginner when it comes to Postgresql, however
I've been tasked with updating a versionn 9.5 install on Ubuntu 20.04 to just
about any later version I can get (latest preferably) but have hit a number of
roadblocks.
The machine has version 10 and 12 o
14 matches
Mail list logo
