Re: Oracle to postgres migration

Hi, May I first suggest that you first look at some of EnterpriseDB’s technical literature. They have some documents which list what their products add to PostgreSQL to make it more like Oracle. If your firm isn’t doing this just to get out of licensing fees, they would probably be a good opti

Re: [OT] subscribtion with no-mail option?

> On Dec 25, 2017, at 2:49 AM, Michelle Konzack > wrote: > > Hello anyone, > > is there an option for the pgsql lists to subscribe only for posting > and not receiving messages? Yes. The button is labeled "Disable mail delivery". You can manage your subscriptions, including disabling deliver

Re: [OT] subscribtion with no-mail option?

Hello Kumar, On 2017-12-26 01:11:23 Rakesh Kumar hacked into the keyboard: > Well I do recollect the option in the old mailing list to not email any > postings. IIRC, there were following options: > > 1- Email every messgages > 2- Daily digest of messages > 3- No email of any message. > > Opt

Oracle to postgres migration

Hello, Can anyone guide me through the steps for migration from oracle to postgres with config changes required, keeping in mind that neither I am a oracle DBA not postgres admin -- Regards, Azim

Oacle to Postgres migration

Hello, Can anyone suggest me -- Regards, Azim Virus-free. www.avast.com

Re: High CPU usage in postgres servers

On Mon, Dec 25, 2017 at 06:12:05PM -0500, Melvin Davidson wrote: > On Mon, Dec 25, 2017 at 1:28 PM, nikhil raj wrote: >> Hi guys , >> when check the task manager I see these many postgres.exe are running. How >> to identify which pid is running for which process please any one can help >> me out.

Re: [OT] subscribtion with no-mail option?

Well I do recollect the option in the old mailing list to not email any postings.  IIRC, there were following options:   1- Email every messgages 2- Daily digest of messages 3- No email of any message.   Option (3) can be used for only posting. I did that for some time.

Re: High CPU usage in postgres servers

On Mon, Dec 25, 2017 at 1:28 PM, nikhil raj wrote: > > > > Hi guys , > when check the task manager I see these many postgres.exe are running. How > to identify which pid is running for which process please any one can help > me out. > or Why these many postgres.exe are running on the server > >

High CPU usage in postgres servers

Hi guys , when check the task manager I see these many postgres.exe are running. How to identify which pid is running for which process please any one can help me out. or Why these many postgres.exe are running on the server [image: Inline image 1] Thanks , Nikhil

Re: Stand by server (9.6.6) with corrupt file

I've used rsync method as described in PostgreSQL wiki. Database is quite large, and pg_basebackup fail after running for several hours over a 5Mbps link. To me, rsync appears to be more reliable over unstable links. Nevertheless, if some data has been corrupted during copy across the wire,

Re: [OT] subscribtion with no-mail option?

I don't think that it's possible, but why don't you open a free gmail account or another web-based email service that's available in your region/language and subscribe to all of the mailing lists through that account? Igal On Mon, Dec 25, 2017 at 2:49 AM, Michelle Konzack < linux4miche...@tamay-

[OT] subscribtion with no-mail option?

Hello anyone, is there an option for the pgsql lists to subscribe only for posting and not receiving messages? I can read them in the archives, but the is one of the most active lists I am subscribed to. Not even can beat that. (there I can whitelist me, without receiving messages) Oh, I shou

Re: Scheme conversion MySQL to PGSQL

> On 24 Dec 2017, at 18:52, Michelle Konzack > wrote: > CREATE TABLE sqmf_stat ( > stat_loginvarchar(70) NOT NULL, > stat_post integer default '1', > stat_thread integer default '1', > PRIMARY KEY (stat_login), > UNIQUE KE