Hi Thomas,
We have tried kafka, but in that we stuck in CDC part, update/delete was not
working due to some NULL value issue. Do you have any helping material for
Oracle to PostgreSQL data migration using debezium?
Regards,
Inzamam Shafiq
Sr. DBA
From: Thomas K
Hi Ron,
I have used ora2pg for a small database, but we have limitation of zero
downtime, how do we replicate real time data from Oracle to PostgreSQL. We can
migrate schema from Oracle to PostgreSQL using ora2pg and single time bulk data
but what about the changed data after bulk load?
Regard
On 3/20/23 1:46 PM, Bryn Llewellyn wrote:
adrian.kla...@aklaver.com wrote:
b...@yugabyte.com wrote:
adrian.kla...@aklaver.com wrote:
I have a hard time fathoming why someone who writes documentation does not
actually read documentation.
Ouch. In fact, I had read the whole of the "43.7. C
> adrian.kla...@aklaver.com wrote:
>
>> b...@yugabyte.com wrote:
>>
>>> adrian.kla...@aklaver.com wrote:
>>>
>>> I have a hard time fathoming why someone who writes documentation does not
>>> actually read documentation.
>>
>>
>> Ouch. In fact, I had read the whole of the "43.7. Cursors" sect
https://dba.stackexchange.com/questions/37012/difference-between-database-vs-user-vs-schema
On Mon, Mar 20, 2023 at 2:57 PM Bryn Llewellyn wrote:
> > david.g.johns...@gmail.com wrote:
> >
> >> adapt...@comcast.net wrote:
> >>
> >> Is there any good reference to explain the best usage of each of
> david.g.johns...@gmail.com wrote:
>
>> adapt...@comcast.net wrote:
>>
>> Is there any good reference to explain the best usage of each of these
>> structures. I am coming from Oracle. What is the best analog to Oracle's
>> "user".
>
> A schema is a namespace mechanism for objects. It has n
On Mon, Mar 20, 2023 at 9:13 AM DAVID ROTH wrote:
> Is there any good reference to explain the best usage of each of these
> structures.
> I am coming from Oracle. What is the best analog to Oracle's "user".
>
A schema is a namespace mechanism for objects. It has no relationship to
roles aside
Please don't hijack threads.
https://www.postgresql.org/docs/13/limits.html
No mention of schemas.
On Mon, Mar 20, 2023 at 12:08 PM DAVID ROTH wrote:
> Is there any practical limit on the number of schemas in a database?
> Will the number of schemas in a user's search path impact performance?
>
Hi
po 20. 3. 2023 v 17:08 odesílatel DAVID ROTH napsal:
> Is there any practical limit on the number of schemas in a database?
> Will the number of schemas in a user's search path impact performance?
>
Sure, it should have an impact. When you use an unqualified identifier,
then the identifier
Is there any good reference to explain the best usage of each of these
structures.
I am coming from Oracle. What is the best analog to Oracle's "user".
Thanks
Dave Roth
> On 03/20/2023 10:15 AM Ron Johnson wrote:
>
>
> Real-time CDC is the difficult part. ora2pg (using views) can do
Is there any practical limit on the number of schemas in a database?
Will the number of schemas in a user's search path impact performance?
Thanks
Dave Roth
> On 03/20/2023 10:15 AM Ron Johnson wrote:
>
>
> Real-time CDC is the difficult part. ora2pg (using views) can do a
> static m
On Mon, Mar 20, 2023 at 10:21 AM Thomas Kellerer wrote:
> Inzamam Shafiq schrieb am 20.03.2023 um 13:57:
> > We have an Oracle DB which is around 1TB and we want to migrate to
> > PostgreSQL that have a new table structure, so we want to perform
> > data transformation and real time CDC from Orac
Inzamam Shafiq schrieb am 20.03.2023 um 13:57:
> We have an Oracle DB which is around 1TB and we want to migrate to
> PostgreSQL that have a new table structure, so we want to perform
> data transformation and real time CDC from Oracle to PostgreSQL. Do
> we have any good open source tool to achiev
On Mon, 20 Mar 2023, David G. Johnston wrote:
>On Monday, March 20, 2023, Dávid Suchan
>wrote:
>
>> I installed both postgres versions on ubuntu machine with 'apt-get install
>> postgres', which installed both client and server packages. Is that where I
>> made a mistake?
>Anyway, you had to hav
Real-time CDC is the difficult part. ora2pg (using views) can do a static
migration. No coding (unless you consider clever use of bash to modify
config files to be coding). I used it to migrate a 7TB db to Postgresql.
https://ora2pg.darold.net/
On Mon, Mar 20, 2023 at 8:58 AM Inzamam Shafiq
w
On Monday, March 20, 2023, Dávid Suchan
wrote:
> I installed both postgres versions on ubuntu machine with 'apt-get install
> postgres', which installed both client and server packages. Is that where I
> made a mistake?
>
>
Any chance you can in-line/bottom-post like the rest of us?
Anyway, you
I installed both postgres versions on ubuntu machine with 'apt-get install
postgres', which installed both client and server packages. Is that where I
made a mistake?
Od: David G. Johnston
Odoslané: pondelok 20. marca 2023 14:57
Komu: Dávid Suchan
Kópia: Tom Lan
On Monday, March 20, 2023, Dávid Suchan
wrote:
> rolname
> ---
> anon
> api
> heartbeat
> postgres
>
> only the default users..
>
You have an incorrect concept of default here. Only postgres is installed
by community PostgresSQL and thus pg_upgrade is rightfully complaining.
David
On Mon, Mar 20, 2023 at 2:18 PM Erik Wienhold wrote:
> > On 20/03/2023 13:50 CET Dominique Devienne wrote:
> >
> > On Mon, Mar 20, 2023 at 1:18 PM Erik Wienhold wrote:
> > > > On 20/03/2023 11:52 CET Dominique Devienne
> wrote:
> > > > What does a NULL AclItem[] mean exactly?
> > >
> > > It m
> On 20/03/2023 13:50 CET Dominique Devienne wrote:
>
> On Mon, Mar 20, 2023 at 1:18 PM Erik Wienhold wrote:
> > > On 20/03/2023 11:52 CET Dominique Devienne wrote:
> > > What does a NULL AclItem[] mean exactly?
> >
> > It means that the object has default privileges (before any GRANT or REVOKE
Hi,
Hope everyone is fine.
Can someone help or guide regarding Open Source tools for Oracle to PostgreSQL
migration with real time CDC. along with this is there any possibility to
change the structure of the database? Let me explain a little more,
We have an Oracle DB which is around 1TB and w
On Mon, Mar 20, 2023 at 1:18 PM Erik Wienhold wrote:
> > On 20/03/2023 11:52 CET Dominique Devienne wrote:
> > What does a NULL AclItem[] mean exactly?
>
> It means that the object has default privileges (before any GRANT or REVOKE
> is executed). For databases this means full privileges for th
Hello list,
We’re having some issues with Postgresql’s logical replication.
Specifically trying to add several replicas at once. Essentially we can add
replicas one at a time, but when we try and add two or more together some
of the table subscriptions (as described in pg_subscription_rel) fail to
> On 20/03/2023 11:52 CET Dominique Devienne wrote:
>
> Hi. I'm surprised, I thought ACLs would never be empty for a database.
> Does that mean nobody can connect to this database?
> I guess SUPERUSER and/or its datDBA can?
> What does a NULL AclItem[] mean exactly?
It means that the object has d
rolname
---
anon
api
heartbeat
postgres
only the default users..
Od: Tom Lane
Odoslané: štvrtok 16. marca 2023 19:24
Komu: Dávid Suchan
Kópia: Daniel Gustafsson ; pgsql-gene...@postgresql.org
Predmet: Re: pg_upgrade Only the install user can be def
Hi. I'm surprised, I thought ACLs would never be empty for a database.
Does that mean nobody can connect to this database?
I guess SUPERUSER and/or its datDBA can?
What does a NULL AclItem[] mean exactly?
(BTW, datallowconn is true)
Thanks, --DD
ddb=> select datname, datdba::regrole::text from pg
26 matches
Mail list logo
