Re: Strategy for migrating from Oracle to PG

2023-09-05 Thread Deep
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: Question on Partition key

2023-09-03 Thread Deep
Have your friends also mentioned how it is going to help to convert date field to integer !??? On Sun, Sep 3, 2023 at 3:51 AM Erik Wienhold wrote: > On 03/09/2023 00:35 CEST veem v wrote: > > > We are trying to create a monthly range partition table , partitioned on > > column PART_DATE. This w

Re: PSQLException: An I/O error occurred while sending to the backend.

2020-07-30 Thread Argha Deep Ghoshal
Hi Tom, Appreciate your inputs. Please find my comments inline below. > We are using PostgreSQL 11 wherein intermittently the below exception is > > popping up, causing our application to lose connection with the database. > > It isn't reconnecting until the application is restarted. > > > o

PSQLException: An I/O error occurred while sending to the backend.

2020-07-30 Thread Argha Deep Ghoshal
Hi Team, We are using PostgreSQL 11 wherein intermittently the below exception is popping up, causing our application to lose connection with the database. It isn't reconnecting until the application is restarted. org.postgresql.util.PSQLException: An I/O error occurred while sending to the b