Prevent users from executing pg_dump against tables

2024-05-01 Thread RAJAMOHAN
Hello all, In our production db infrastructure, we have one read_only role which has read privileges against all tables in schema A. We are planning to grant this role to some developers for viewing the data, but also I want to limit the users from executing statements like copy or using

Re: Linked directory or explicit reference

2024-05-01 Thread Senor Cervesa
On 4/30/2024 17:31, Ron Johnson wrote: On Tue, Apr 30, 2024 at 7:00 PM Senor Cervesa wrote: Hi All; When doing an initial install of PostgreSQL on RHEL 7 or 8 derived OS via rpm, what are pros, cons and recommendations of these 2 procedures for utilizing a second disk?

Re: Table data migration from single server to Flexi server

2024-05-01 Thread Kashif Zeeshan
Hi Please use pg_dump for taking the backup, you can find the details on the link below. https://www.postgresql.org/docs/current/app-pgdump.html Regards Kashif Zeeshan On Thu, May 2, 2024 at 8:24 AM Bagesh kamar singh wrote: > > Hi team, >> >> I need help. Recently we migrated our postgreSQL

Table data migration from single server to Flexi server

2024-05-01 Thread Bagesh kamar singh
> Hi team, > > I need help. Recently we migrated our postgreSQL single server to flexi > server. We need to move data from a table from a single server database to > a flexi server database. My table has around 12GB data. We need to migrate > only this table data to the flexi server. > Can someone

Re: Posgresql 14 and CarbonBlack on RHEL8?

2024-05-01 Thread Ron Johnson
On Tue, Apr 30, 2024 at 10:07 PM Tom Lane wrote: > Ron Johnson writes: > > When running stress tests on the systems (in prod, during the maintenance > > window), 171K events/second are generated on the RHEL8 servers, and CB > > needs (according to top(1)) 325% of CPU to handle that, and still >