This is true. Such a feature is not available in PostgreSQL.
What you need to do is you have to take a structure dump, and change the
schema name as per required. And, then, you may copy the data.
Regards,
Ninad Shah
On Fri, 23 Jul 2021 at 23:08, Mayan wrote:
> Hi,
>
>
>
> I had a general que
Hi,
I had a general question about a feature that we depended on heavily when
using other RDBMS providers which was the ability to take a schema dump and
restore it to a different database and a different schema in that database
(could be to the same database as well). Basically, there was an o
Version 9.2 is very old and has a lot of issues related to streaming
replication. Additionally, it is already EOL.
Furthermore, max_standby_streaming_delay has no relation with the streaming
lag. It's associated with queries conflicting with data. This parameter
will not speed up the WAL apply ope
Question 1 : What's a need to perform a VACUUM FULL operation on pg_class?
Question 2 : Ideally, a VACUUM FULL operation seeks an exclusive lock on a
table, while I can see it waiting for a shared lock here. Why? (Not asking
you)
Additionally, The situation you have described should be termed a
"
Just to make it clear, "idle in transaction" and "idle" are different
terms. "Idle in transaction" refers to connections that are waiting for
either commit or rollback.
Additionally, this could be a bug as well. However, it's difficult to
conclude at this stage. You may report this to postgresql-b
Hello,
unfortunately, it's my companys choice of OS.
In private life I'm riding the penguin.
One last thing: I have 2 Laptops, where the shutdown doesn't work, and
one VirtualBox machine where it works like a charm. Maybe it has
something to do with the power management.
As a workaround I se
Le ven. 23 juil. 2021 à 12:06, Luca Ferrari a écrit :
> On Thu, Jul 15, 2021 at 7:27 PM Francisco Olarte
> wrote:
> > It would probably complicate it, and dumping a whole cluster using
> > something like pg_dumpall -g for the globals plus a loop over the
> > databases using something like pg_dum
On Fri, Jul 16, 2021 at 2:43 PM Markhof, Ingolf
wrote:
> I wonder how you deal with it in a professional way. Sounds like some type of
> "make" (that UNIX tool dealing with dependencies in the context of e.g.
> programming in C) would be helpful...
>
I see this question coming out very often, a
On Thu, Jul 15, 2021 at 7:27 PM Francisco Olarte wrote:
> It would probably complicate it, and dumping a whole cluster using
> something like pg_dumpall -g for the globals plus a loop over the
> databases using something like pg_dump -Fc ( which I would always
> recommend over plain sql format ) i
On Fri, Jul 16, 2021 at 12:38 AM Lucas wrote:
> However, it hasn't changed and the replication lag is still high all the time.
>
Since the documentation states that max_standby_streaming_delay
"[...]it is the maximum total time allowed to apply WAL data once it
has been received from the primary
10 matches
Mail list logo
