On Tue, Sep 03, 2024 at 10:28:44PM -0400, Tom Lane wrote:
> raf writes:
> > On Tue, Sep 03, 2024 at 06:43:22PM -0700, "David G. Johnston"
> > wrote:
> >> You specified “-1” so I don’t get why you believe pg_restore should be
> >> continuing to execute in the face of the SQL error.
>
> > The r
raf writes:
> On Tue, Sep 03, 2024 at 06:43:22PM -0700, "David G. Johnston"
> wrote:
>> You specified “-1” so I don’t get why you believe pg_restore should be
>> continuing to execute in the face of the SQL error.
> The reason I believe pg_restore should be continuing to execute in the face of
On Tue, Sep 03, 2024 at 06:43:22PM -0700, "David G. Johnston"
wrote:
> On Tuesday, September 3, 2024, raf wrote:
>
> > Hi,
> >
> > I need help!
> >
> > I'm upgrading an ancient (but still awesome) postgresql-9.6.24 (via
> > EnterpriseDB)
> > to (a no doubt even more awesome) postgresql-15.8 (v
On Tuesday, September 3, 2024, raf wrote:
> Hi,
>
> I need help!
>
> I'm upgrading an ancient (but still awesome) postgresql-9.6.24 (via
> EnterpriseDB)
> to (a no doubt even more awesome) postgresql-15.8 (via debian (stable)
> packages)
> but am unable to load database backups that were encrypte
Hi,
I need help!
I'm upgrading an ancient (but still awesome) postgresql-9.6.24 (via
EnterpriseDB)
to (a no doubt even more awesome) postgresql-15.8 (via debian (stable) packages)
but am unable to load database backups that were encrypted via gpg. Loading
from
unencrypted backups works fine (a
postgres_fdw will be required if the tables are in separate databases.
On Tue, Sep 3, 2024 at 12:36 PM David Mullineux wrote:
> Yes, PostgreSQL.
> Why not just do this via SQL join ?
>
> On Tue, 3 Sept 2024, 17:34 arun chirappurath,
> wrote:
>
>> Hi All,
>>
>> Do we have any open-source utility
On 9/3/24 09:37, Adrian Klaver wrote:
On 9/3/24 09:25, Muhammad Usman Khan wrote:
Hi,
You need to install plpython3u on your new server and also make sure
to use python3. You need to make changes to your functions also to
make them compatible with python3
That only works if the dump from the
On 9/3/24 09:25, Muhammad Usman Khan wrote:
Hi,
You need to install plpython3u on your new server and also make sure to
use python3. You need to make changes to your functions also to make
them compatible with python3
That only works if the dump from the old server is outputting
plpython3u.
Yes, PostgreSQL.
Why not just do this via SQL join ?
On Tue, 3 Sept 2024, 17:34 arun chirappurath, wrote:
> Hi All,
>
> Do we have any open-source utility to compare two table data not structure
> and then provide some sort of reports?
>
> Row by row comparison
>
> Thanks,
> Arun
>
Hi All,
Do we have any open-source utility to compare two table data not structure
and then provide some sort of reports?
Row by row comparison
Thanks,
Arun
Hi,
You need to install plpython3u on your new server and also make sure to use
python3. You need to make changes to your functions also to make them
compatible with python3
On Tue, 3 Sept 2024 at 19:31, Sam Son wrote:
> Hi Team,
>
> I am working on a project where we have applications run on o
On 9/2/24 04:37, Sam Son wrote:
Hi Team,
I am working on a project where we have applications run on old versions
of postgres, we are using *plpythonu* in all Functions extension,
What versions of Postgres?
Now we have upgraded postgres to latest which does not support plpythonu
anymore,
Andrus writes:
> Postgres 16 has user ingmar which is marked as superuser and has create
> role rights:
> CREATE ROLE ingmar WITH
> LOGIN
> SUPERUSER
> INHERIT
> CREATEDB
> CREATEROLE
> NOREPLICATION
> BYPASSRLS
> ENCRYPTED PASSWORD 'm
On Tue, Sep 3, 2024 at 4:31 PM Andrus wrote:
> GRANT "eeva_owner" TO "ingmar.e"
> This command throws error
> ERROR: permission denied to grant role "eeva_owner"
Works are expected when I try it. FWIW. --DD
c:\Users\ddevienne>psql service=pau16
psql (17beta3, server 16.1)
ddevienne=> creat
Hi Team,
I am working on a project where we have applications run on old versions of
postgres, we are using *plpythonu* in all Functions extension,
Now we have upgraded postgres to latest which does not support plpythonu
anymore, So we are facing an issue while restoring dump which has
plpythonu,
Hi!
Postgres 16 has user ingmar which is marked as superuser and has create
role rights:
CREATE ROLE ingmar WITH
LOGIN
SUPERUSER
INHERIT
CREATEDB
CREATEROLE
NOREPLICATION
BYPASSRLS
ENCRYPTED PASSWORD 'md5aaa790012b7aa47017f124e263d8';
Mostly to close the loop on this, now that I have things going seemingly
reliably...
On Tue, 18 Jun 2024 at 14:33, Ron Johnson wrote:
> On Tue, Jun 18, 2024 at 5:03 AM Shaheed Haque
> wrote:
>
>> Hi all,
>>
>> Is there an "official" pairing of LSN values on the publication and
>> subscription s
On 03/09/2024 10:34, Pavel Luzanov wrote:
On 03.09.2024 00:11, Heikki Linnakangas wrote:
Pavel, did you test v17 with checksums enabled and v16 with checksums
disabled, by any chance?
Exactly, You are right!
My v16 cluster comes from the default Ubuntu distribution.
I forgot that checksums di
On 03.09.2024 00:11, Heikki Linnakangas wrote:
Pavel, did you test v17 with checksums enabled and v16 with checksums
disabled, by any chance?
Exactly, You are right!
My v16 cluster comes from the default Ubuntu distribution.
I forgot that checksums disabled by default.
But when I initialize th
19 matches
Mail list logo
