Hi all,
There is a logical replication slot I can't drop. Tried using
select pg_terminate_backend(PID) OK
select pg_drop_replication_slot('slot_name) OK
But the slot_name restarts with other active_pid. There is not subscriber
connected and no errors in database log. We are using PG14.
Any help
Fact Table:
-- DROP TABLE IF EXISTS system."IMETA_ZTRB_MP$F_ZTBR_TA_BW";
CREATE TABLE IF NOT EXISTS system."IMETA_ZTRB_MP$F_ZTBR_TA_BW"
(
"ZTBR_TransactionCode" integer NOT NULL DEFAULT
nextval('system."IMETA_ZTRB_MP$F_ZTBR_TA_BW_ZTBR_TransactionCode_seq"'::regclass),
"Company_Code" charac
> On 11 Sep 2023, at 16:09, Anthony Apollis wrote:
>
> Fact Table:
> CREATE TABLE IF NOT EXISTS system."IMETA_ZTRB_MP$F_ZTBR_TA_BW"
> (
(…)
> )
> and Dimension:CREATE TABLE IF NOT EXISTS dim."IMETA_Region_Mapping"
> (
(…)
> )
> How do i get that all these columns that are joined are align
Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg
15. I'm at the point of running pg_upgrade but have received anerror
message:
/mga8/usr/bin/postgres: error while loading shared libraries:
libssl.so.1.1: cannot open shared object file: No such file or directory
no data
Graeme writes:
> Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg
> 15. I'm at the point of running pg_upgrade but have received anerror
> message:
> /mga8/usr/bin/postgres: error while loading shared libraries:
> libssl.so.1.1: cannot open shared object file: No such fi
On 9/11/23 09:04, Graeme wrote:
Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg
15. I'm at the point of running pg_upgrade but have received anerror
message:
You are going to have to be more specific on the Postgres version. Prior
to Postgres 10 major version changes w
On 11/09/2023 17:10, Tom Lane wrote:
Graeme writes:
Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg
15. I'm at the point of running pg_upgrade but have received anerror
message:
/mga8/usr/bin/postgres: error while loading shared libraries:
libssl.so.1.1: cannot open shar
Graeme writes:
> Tom, thanks: it's finding other so. files in the correct place
> libpam.so.0 => /lib64/libpam.so.0 (0x7f8d49e1e000)
> libssl.so.1.1 => not found
> libcrypto.so.1.1 => not found
> librt.so.1 => /lib64/librt.so.1 (0x7f8d49e16000)
Note this only shows it looking in /lib64,
On 11/09/2023 17:13, Adrian Klaver wrote:
On 9/11/23 09:04, Graeme wrote:
Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia
9/Pg 15. I'm at the point of running pg_upgrade but have received
anerror message:
You are going to have to be more specific on the Postgres version.
P
On 9/11/23 09:33, Graeme wrote:
On 11/09/2023 17:13, Adrian Klaver wrote:
On 9/11/23 09:04, Graeme wrote:
Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia
9/Pg 15. I'm at the point of running pg_upgrade but have received
anerror message:
You are going to have to be more spe
On 11/09/2023 17:33, Graeme wrote:
On 11/09/2023 17:13, Adrian Klaver wrote:
On 9/11/23 09:04, Graeme wrote:
Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia
9/Pg 15. I'm at the point of running pg_upgrade but have received
anerror message:
You are going to have to be more
On 11/09/2023 20:07 CEST Johnson, Bruce E - (bjohnson)
wrote:
> I’ve created the database ‘webdata', successfully used ora2pg to migrate one
> schema ‘trav’ to Postgres.
>
> The schema on the oracle side is called trav the owner is webdata, and I
> created the role trav and granted all table rig
(Background I’m working on migrating an existing set of Oracle schemas with a
bunch of inter-schema grants to a Postgres 15 system)
I’ve created the database ‘webdata', successfully used ora2pg to migrate one
schema ‘trav’ to Postgres.
The schema on the oracle side is called trav the owner is w
13 matches
Mail list logo
