(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
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
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 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
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.
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: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
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
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
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
> 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
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"
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
13 matches
Mail list logo
