Re: adding more space to the existing server

On 7/31/19 5:21 PM, Julie Nishimura wrote: Hello postgres folks, We're tossing around the idea of upgrading a replicated postgres cluster (37 dbs) by breaking the replication, adding different size (larger) data disks to the hot-spare, then turning replication back on, letting it fully popula

adding more space to the existing server

Hello postgres folks, We're tossing around the idea of upgrading a replicated postgres cluster (37 dbs) by breaking the replication, adding different size (larger) data disks to the hot-spare, then turning replication back on, letting it fully populate, then breaking replication, making the sta

Re: Oracle to postgres migration via ora2pg (blob data)

Le 31/07/2019 à 18:02, Amol Tarte a écrit : > FullConvert does this job much faster than ora2pg > > > With Warm Regards, > Amol Tarte, > Project Lead, > Rajdeep InfoTechno Pvt. Ltd. > Visit us at http://it.rajdeepgroup.com > > On Wed 31 Jul, 2019, 5:16 PM Niels Jespersen, > wro

Re: How do I create a Backup Operator account ?

On 2019-07-31 07:48:36 +0200, Luca Ferrari wrote: > On Wed, Jul 31, 2019 at 2:48 AM Marcos Aurelio Nobre > wrote: > > But I don't know how to implement this on Linux, nor how to write this > > entry in the pg_hba.conf file. > > I would start with an entry in pg_hba.conf like the following: > >

Re: DDL and DML in a transaction

Thank you, David. I should get more sleep... Igal On 7/31/2019 11:52 AM, David G. Johnston wrote: On Wed, Jul 31, 2019 at 11:38 AM Igal @ Lucee.org > wrote:      alter table some_table     rename column amount_num to amount_text; alter table some

Re: DDL and DML in a transaction

On Wed, Jul 31, 2019 at 11:38 AM Igal @ Lucee.org wrote: > alter table some_table > rename column amount_num to amount_text; > > alter table some_table > drop column amount_num; > You just renamed amount_num to amount_text so I'm not sure why you expect the drop to su

DDL and DML in a transaction

I am trying to change a text column into a numeric one in a large table. My idea was to add a new column, update it, drop the old column, and rename the new one to the old name.  I am hoping that that would make it faster and minimize locking time though I'm not sure that it would. I am there

Re: Which version to upgrade upto

Vikas Sharma writes: > The architects and developers have perception that the latest release > always will have bugs and others might be using in production. They feel > 11.2 will be better bet than 11.4. Your architects are apparently completely unfamiliar with Postgres. Tell them to read https:

Re: Which version to upgrade upto

Vikas Sharma schrieb am 31.07.2019 um 17:57: The architects and developers have perception that the latest release always will have bugs and others might be using in production. They feel 11.2 will be better bet than 11.4. You should always use the latest minor version, so 11.4 is preferred ov

Re: Oracle to postgres migration via ora2pg (blob data)

FullConvert does this job much faster than ora2pg With Warm Regards, Amol Tarte, Project Lead, Rajdeep InfoTechno Pvt. Ltd. Visit us at http://it.rajdeepgroup.com On Wed 31 Jul, 2019, 5:16 PM Niels Jespersen, wrote: > I would look at the source table in Oracle first. It looks a lot like > audi

Re: Which version to upgrade upto

On Wed, Jul 31, 2019 at 8:58 AM Vikas Sharma wrote: > The architects and developers have perception that the latest release > always will have bugs and others might be using in production. They feel > 11.2 will be better bet than 11.4. > Beginning with version 10 the second position in the versi

Re: Which version to upgrade upto

On 7/31/19 9:57 AM, Vikas Sharma wrote: The architects and developers have perception that the latest release always will have bugs and others might be using in production. They feel 11.2 will be better bet than 11.4. Except of course for the bugs fixed in .3 and .4.

Re: Which version to upgrade upto

The architects and developers have perception that the latest release always will have bugs and others might be using in production. They feel 11.2 will be better bet than 11.4. On Wed, Jul 31, 2019, 16:24 Luca Ferrari wrote: > On Wed, Jul 31, 2019 at 4:55 PM Vikas Sharma wrote: > > Should I

Re: Which version to upgrade upto

On Wed, Jul 31, 2019 at 4:55 PM Vikas Sharma wrote: > Should I go for 10.9 or 11.2? The architects are suggesting 11.2 Moving fom 9.5 requires in any case a major version upgrade, therefore I would go for the latest one, 11.4. Are there any particular needs that feed your doubts about the version

Which version to upgrade upto

Hi All, We are using postgres 9.5.9 in streaming replication with repmgr. The project is now considering to update postgreSQL instances to latest versions. I am looking for which version to upgrade to. I can see the current version in postgres 11 is 11.4, and 10.9 in 10. How to decide on which

Re: Active connections are terminated because of small wal_sender_timeout

ayaho...@ibagroup.eu writes: >> I do not think anybody thinks this is a bug. Setting wal_sender_timeout >> too small is a configuration mistake. > Why is it a configuration mistake? This value is allowed to be set. There > is no any restriction about it. The fact that a parameter can be set do

Re: pgaudit.log_parameter

Hello, On 31.07.2019 14:21, Luca Ferrari wrote: Hello, I'm a little confused about the setting pgaudit.log_parameter of the pgaudit extension (https://github.com/pgaudit/pgaudit/blob/master/README.md). What's the purpose of this? AN example of query that will trigger such parameter logging? Appa

Re: pgaudit.log_parameter

Hello, On 31.07.2019 14:21, Luca Ferrari wrote: Hello, I'm a little confused about the setting pgaudit.log_parameter of the pgaudit extension (https://github.com/pgaudit/pgaudit/blob/master/README.md). What's the purpose of this? AN example of query that will trigger such parameter logging? Appa

SV: Oracle to postgres migration via ora2pg (blob data)

I would look at the source table in Oracle first. It looks a lot like audit data. Perhaps all content is not needed in Postgres. If it is, then the table and lobs may benefit from being reorganised in oracle. Alter table CLIENT_DB_AUDIT_LOG move; Alter table CLIENT_DB_AUDIT_LOG move lob (SYS_LO

Oracle to postgres migration via ora2pg (blob data)

Hello team, We have to migrate a schema from oracle to postgres but there is one table that is having following large lob segments. This table is taking time to export. What parameters we have to set in ora2pg.conf to speed up the data export by ora2pg. Table:CLIENT_DB_AUDIT_LOG LOBSEGME

pgaudit.log_parameter

Hello, I'm a little confused about the setting pgaudit.log_parameter of the pgaudit extension (https://github.com/pgaudit/pgaudit/blob/master/README.md). What's the purpose of this? AN example of query that will trigger such parameter logging? Apparently I cannot get it providing me more informatio

Re: Active connections are terminated because of small wal_sender_timeout

Hello Everyone! Sorry for being persistent. > I do not think anybody thinks this is a bug. Setting wal_sender_timeout > too small is a configuration mistake. Why is it a configuration mistake? This value is allowed to be set. There is no any restriction about it. I would like to ask a questio