Sample data generator for performance testing

Hi All, Do we have any open source tools which can be used to create sample data at scale from our postgres databases? Which considers data distribution and randomness Regards, Arun

Re: encoding option when database backup

On Wed, 2024-01-03 at 15:59 +0900, Taek Oh wrote: > Hi there, > > I would like to make an inquiry regarding the encoding option for the > database backup. > When I was using the previous version of PGADMIN 4, I had a > dropbar for the encoding format for the backup option. > But I recently

Re: Logical replication breaks: "unexpected duplicate for tablespace 0, relfilenode 2774069304"

On Thu, Dec 28, 2023 at 02:03:12PM +0200, Kouber Saparev wrote: >> The first problem that we have here is that we've lost track of the >> patch proposed, so I have added a CF entry for now: >> https://commitfest.postgresql.org/46/4720/ > > Thank you. Is there a bug report or should we file one?

Re: Import csv to temp table

On 1/2/24 11:47, arun chirappurath wrote: Reply to list Ccing list Hi Adrian, Love this tool..however it doesn't like supporting RDS. 1) This was Daniel Vérité's suggestion not mine. 2) Define "... doesn't like supporting RDS". a) You can generate an SQL statement without connecting to the

Re: New SET privilege for pg_has_role() in v16+

On 1/2/24 08:15, Dominique Devienne wrote: On Tue, Jan 2, 2024 at 5:09 PM Adrian Klaver > wrote: On 1/2/24 07:24, Dominique Devienne wrote: > pg_has_role() from > https://www.postgresql.org/docs/current/functions-info.html

Re: New SET privilege for pg_has_role() in v16+

On 1/2/24 08:21, Dominique Devienne wrote: On Tue, Jan 2, 2024 at 5:11 PM David G. Johnston mailto:david.g.johns...@gmail.com>> wrote: On Tue, Jan 2, 2024 at 8:25 AM Dominique Devienne mailto:ddevie...@gmail.com>> wrote: pg_has_role() from

Re: New SET privilege for pg_has_role() in v16+

On Tue, Jan 2, 2024 at 9:21 AM Dominique Devienne wrote: > On Tue, Jan 2, 2024 at 5:11 PM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Tue, Jan 2, 2024 at 8:25 AM Dominique Devienne >> wrote: >> >>> pg_has_role() from >>>

Re: New SET privilege for pg_has_role() in v16+

On Tue, Jan 2, 2024 at 5:11 PM David G. Johnston wrote: > On Tue, Jan 2, 2024 at 8:25 AM Dominique Devienne > wrote: > >> pg_has_role() from >> https://www.postgresql.org/docs/current/functions-info.html >> added the 'SET' privilege in v16, and on top of the existing 'MEMBER' and >> 'USAGE'

Re: New SET privilege for pg_has_role() in v16+

On Tue, Jan 2, 2024 at 5:09 PM Adrian Klaver wrote: > On 1/2/24 07:24, Dominique Devienne wrote: > > pg_has_role() from > > https://www.postgresql.org/docs/current/functions-info.html > > > > added the 'SET' privilege in v16, and on

Re: New SET privilege for pg_has_role() in v16+

On Tue, Jan 2, 2024 at 8:25 AM Dominique Devienne wrote: > Hi. And happy new year (for those using the Gregorian calendar). > > pg_has_role() from > https://www.postgresql.org/docs/current/functions-info.html > added the 'SET' privilege in v16, and on top of the existing 'MEMBER' and > 'USAGE'

Re: New SET privilege for pg_has_role() in v16+

On 1/2/24 07:24, Dominique Devienne wrote: Hi. And happy new year (for those using the Gregorian calendar). pg_has_role() from https://www.postgresql.org/docs/current/functions-info.html added the 'SET' privilege in v16, and on top

Re: Import csv to temp table

On 1/2/24 06:51, Daniel Verite wrote: arun chirappurath wrote: Do we have any scripts that create a temp table with column names from the first row of csv files? csvkit [1] does that. [1] https://csvkit.readthedocs.io/en/latest/ In addition to the above which I have used you might

New SET privilege for pg_has_role() in v16+

Hi. And happy new year (for those using the Gregorian calendar). pg_has_role() from https://www.postgresql.org/docs/current/functions-info.html added the 'SET' privilege in v16, and on top of the existing 'MEMBER' and 'USAGE' ones: > MEMBER denotes direct or indirect membership in the role [...]

Re: Import csv to temp table

arun chirappurath wrote: > Do we have any scripts that create a temp table with column names > from the first row of csv files? csvkit [1] does that. [1] https://csvkit.readthedocs.io/en/latest/ Best regards, -- Daniel Vérité https://postgresql.verite.pro/ Twitter: @DanielVerite

Re: Testing - Please ignore/delete this message

The way to check if your email was received by the list is to search for it in the archives. https://www.postgresql.org/search/?m=1 Please stop sending testing emails to the entire hundreds of thousands or millions of people on this list. David J. On Tuesday, January 2, 2024, Ray O'Donnell

Re: Testing - Please ignore/delete this message

On 02/01/2024 13:12, Arbol One wrote: Did it work? No idea - I ignored it...! :-) Ray. -- Raymond O'Donnell // Galway // Ireland r...@rodonnell.ie

Re: Testing - Please ignore/delete this message

Received! On Tue, Jan 2, 2024, 8:13 AM Arbol One wrote: > Did it work? > > -- > ArbolOne.ca > Using Fire Fox and Thunderbird. > ArbolOne is composed of students and volunteers dedicated to providing > free services to charitable organizations. > ArbolOne on Java Development is in progress [ í ]

Re: Import csv to temp table

On Tue, Jan 2, 2024 at 7:02 AM arun chirappurath wrote: > Dear All, > > Do we have any scripts that create a temp table with column names from the > first row of csv files? > How would you determine the data type? If you assume TEXT for all of them, then it's relatively simple to write bash

Testing - Please ignore/delete this message

Did it work? -- ArbolOne.ca Using Fire Fox and Thunderbird. ArbolOne is composed of students and volunteers dedicated to providing free services to charitable organizations. ArbolOne on Java Development is in progress [ í ]

Import csv to temp table

Dear All, Do we have any scripts that create a temp table with column names from the first row of csv files? any functions which we can pass the file name as parameter which loads the data to csv based on the data Thanks, ACDBA