Strategy for migrating from Oracle to PG

I have an oracle database with a bunch of schemas that are the data sources for bunch of web applications; what used to be called an ‘intranet’. I’ve installed pg2sql, and it’s working, and what I want to do is pretty much copy what I existing now as closely as possible. I've done ora2pg —proje

Re: pg_dump/pg_restore and the magic of the search_path

Hi, thanks for your answer ! Sorry for being late... I'm sure :-) But I made more research and find the problem : the function I use... I'm using the gen_random_uuid() function wich is included into postgresql core since v13 and was originally into the pgcrypto extension. So when you don't prefi

Efficient Partitioning Strategies for PostgreSQL Table with KSUID and High Volume

Hi Team, I'm working with a PostgreSQL table containing terabytes of data, and it grows by millions of rows weekly. Each row is identified by a [KSUID][1], and my primary read patterns are: 1. Retrieve a row by its KSUID. 2. List rows by `user_id` in descending order, pagination acceptable. Curr

Re: Will PostgreSQL 16 supports native transparent data encryption ?

message from Stephen Frost mailto:sfr...@snowman.net> > > > Greetings, > > > * Ron (ronljohnso...@gmail.com ) wrote: > > On 8/21/23 18:49, Bruce Momjian wrote: > > > On Mon, Aug 21, 2023 at 07:02:46PM +0300, Mostafa Fathy wrote: > > > > It is mentioned here > >

./configure doesn't make effect?

I use “rm -rf /data”, the ‘/data’ is the prefix when I execute ./configure command firstly, but after I ‘rm’ it, and use the command again, I can’t get the /data content. Why?

Re: rollback to savepoint issue

On 2023-Sep-04, Erik Wienhold wrote: > On 04/09/2023 16:56 CEST David G. Johnston wrote: > > > On Monday, September 4, 2023, Erik Wienhold wrote: > > > > > On 04/09/2023 11:51 CEST Lorusso Domenico wrote: > > > > > > > The original code in embedded in a function, but the problem is the > > >

Re: ./configure doesn't make effect?

On 05/09/2023 13:41 CEST jacktby jacktby wrote: > I use “rm -rf /data”, the ‘/data’ is the prefix when I execute ./configure > command firstly, but after I ‘rm’ it, and use the command again, I can’t get > the /data content. Why? ./configure only configures make. You need to run make install

Re: ./configure doesn't make effect?

On Tuesday, September 5, 2023, jacktby jacktby wrote: > I use “rm -rf /data”, the ‘/data’ is the prefix when I execute ./configure > command firstly, but after I ‘rm’ it, and use the command again, I can’t > get the /data content. Why? > > You might want to show a terminal transcript, your descri

Re: ./configure doesn't make effect?

Sorry, I make a mistake, I should make install. That’s my fault > 2023年9月5日 20:08，Jeremy Garniaux 写道： > > Hi, > > The command you described: > > Le 05/09/2023 à 13:41, jacktby jacktby a écrit : >> rm -rf /data > has for effect to remove the /data directory and all its content. See: > https:/

Re: rollback to savepoint issue

Alvaro Herrera writes: > But it gets worse. If you create a procedure (no longer a function) > with a SAVEPOINT and ROLLBACK TO SAVEPOINT, it'll complain about the > ROLLBACK TO command, but not about SAVEPOINT; and if you remove that, > then it'll fail at runtime saying that SAVEPOINT is unsuppo

Re: ./configure doesn't make effect?

On 9/5/23 06:07, jacktby jacktby wrote: Sorry, I make a mistake, I should make install. That’s my fault FYI, that will not create the data/ directory by itself. You will need to do that yourself. See the steps here: https://www.postgresql.org/docs/current/install-short.html The above assum

Re: Strategy for migrating from Oracle to PG

As far as I know, you don't need to create the users, if you create the user anyway before migration then ora2pg will skip the create statement, but objects under the user/schema will be created On Tue, Sep 5, 2023 at 10:24 AM Johnson, Bruce E - (bjohnson) < john...@pharmacy.arizona.edu> wrote: >

Re: Efficient Partitioning Strategies for PostgreSQL Table with KSUID and High Volume

Hello, Increase of access cost is logarithmic when we access by index, so partition often isn't a solution to improve performance, but a solution to solve human difficulties to manage huge amounts of data, to develop expensive parallel jobs and, in some cases, to improve performance for sequential